Plot multiple data ranges in Google Sheets stackoverflow

Recent Questions - Web Applications Stack Exchange

I'm doing a physics lab in class and we conducted multiple runs of a car rolling down a ramp. For each run, there are two columns of data for time and position. I want to graph all the data on a single graph, the x axis being time and the y axis being position. The problem is, the independent variable is not the same across all runs so google sheets cannot recognize the data and put all the time data in a single axis. I have seen the answer to this question, which is very similar to mine. The solution works, but I have 10 runs of data and each has about 50 rows, so copying and pasting each (not to mention inserting the columns) is very tedious. Is there any more elegant way to graph the data?


Recent Questions - Web Applications Stack Exchange Recent Questions - Web Applications Stack Exchange by jasonc via Recent Questions - Web Applications Stack Exchange

No comments:

Post a Comment