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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.