Plotting Two Data Sets in One Graph with Google Sheets

[steveselby]

Thank you for saving me lots of time. Google sheets requirement that all the x-values of multiple data sets have to be in one column is very limiting. After watching this video, I immediately exported my data to OpenOffice.

[Rickysqueaker]

So there is no way of doing this when all of the dependent data is in the same column?

[katherineanderson]

I was practically in tears over an assignment I have, and this made everything better. Thank you so much!!

[Serafiniert]

Thanks. Organizing the data the same way as you did the trick. 1 column for the Y-data, and then a new column for each series for the X-data.

[dbiswas]

This is what I needed for my ECON3000 case study! Thank you, Emily Pontius!

[solrakcs]

Thanks! I'm gonna pass my marketing analysis class thanks to this video!

[Samuitsuki]

Thank you for this. I had been tought a bit more complicated way of having two data sets in one graph, but this seems a lot easier and faster then just having to compare two data sets.

[AndreyMikhaylovlolmaus]

I was thinking of this solution but turned it down because it seemed kinda stupid like Silver Mirai mentioned. But when I saw your video, I tried it and it worked beautifully. Ugly table, beautiful chart!

[romanvelazquez]

thank you so much! your video helped with my paleoclimate project!

[TienTaioan]

I didn't realize that Google Spread sheet can do it automatically. Thank you.

[nicholaus]

This video is a lifesaver. It's unfortunate that I have to use four columns for each of my graphs though...

[aleksandracichowicz]

Thank you so much, that was a torture for so many hours <3 <3 <3

[MrMscience]

For some reason my trendlines don't show y=

[taikitaoka]

Thank you so much, this helped me a lot! <3

[silvermirai]

that's stupid, I want contiguous data because I generate it from api call