How To Make A Graph On Google Sheets With Multiple Data Sets & Independent Variables

How To Make A Graph On Google Sheets With Multiple Data Sets & Independent Variables
If you are learning how to make graphs on google sheets this video will help. I will show you how to create a chart on google sheets using a data table as well as add a second set of data on the same chart. Google sheets does not allow you to add multiple independent variables so you have to use this to be able to do so. This was used in my physics lab for the velocity of a cart.
💥**THE DATA FOR THIS LAB IS FOUND IN THIS VIDEO**💥
• Time & Distance Lab Da...
🔥Review Books I Use & Recommend🔥
SAT Physics: amzn.to/3jA8CeT
AP Physics 1:amzn.to/32MtklD
NY Regents Physics: amzn.to/30GqVpP
AP CALC: amzn.to/3lhAe9u
If there is a topic you want me to do leave them in the comments below.
#physicstutor #mathtutor
DISCLAIMER: The content discussed in these videos are solely my opinion and I have on affiliation with the SAT/College Board or any other products discussed in this video. This channel is for Educational purposes only. This video and description contain affiliate links, which means that if you click on one of the product links, I’ll receive a small commission at no extra cost to you; all of which helps grow the channel! Thank you for your support!

[@themathandphysicstutor]

*Data From These Graphs Can Be Found Here* kzbin.info/www/bejne/f2qyfaiLgqqZoK8

[@sunshine5293]

Are you married? I could marry you. Like, right now. I wouldn't mind. GOD, thank you so much for this!! I needed this. I was about to cry while trying to figure this out. Oh, well. Thank you again. Seriously. I hope you read this. But at the same time, not really because I just proposed and I'm pretty sure I'll get rejected. Have a good life.

[@themathandphysicstutor]

Glad it helped

[@Gigaamped]

This is incredibly helpful. Couldn't find the solution you showed here anywhere in Google's own help pages.

[@themathandphysicstutor]

Please share!

[@Gigaamped]

@Lordeverfall100 well what are you trying to do?? This was very helpful for what I wanted to do lol

[@niladerp]

THANK YOU SO MUCH! I HAVE BEEN SPENDING THE PAST 2 HOURS TRYING TO FIGURE THIS OUT. I CANNOT THANK YOU ENOUGH!!!

[@themathandphysicstutor]

You're very welcome!

[@restfulcube-notyet]

Absolutely amazing! Every single thing you said in this video helped me set up my graph!

[@themathandphysicstutor]

Awesome

[@lluiszardoya]

thank you, really useful!

[@themathandphysicstutor]

You're welcome!

[@robertbyerley3577]

Really well made video and very helpful. Probably saved me a couple of hours of my life trying to work it out and much frustration haha

[@themathandphysicstutor]

Awesome

[@CheriEdwards-d6e]

Thank you. Exactly what my students needed to learn and an easy way to understand and do at the same time.

[@themathandphysicstutor]

Glad it was helpful!

[@autin2343]

It seems like the primary issue preventing this from working the way a lot of people might expect it too is that you have to put different "series" of data in different columns. Ideally you would just be able to specify what 'x set' goes with which 'y set' so that you could apply different colors, equations, etc to different sets. Not sure if I missed something, but that seems to be the key functionality missing from google sheets in this instance.

[@themathandphysicstutor]

Oh

[@MichaelThompson-pe1wi]

This is better than Kahn Academy

[@themathandphysicstutor]

Thank you Michael. Please share!

[@vincenthuynh4793]

hope your video gets more likes; this really helped me when my Excel stopped working

[@themathandphysicstutor]

Cheers. Thank you

[@seanstanchina600]

Saved my fucking life. 1st time watching your channel and I'm terrible with any graphing technology, but you explained it clear and precise. Thumbs up on this video👍

[@themathandphysicstutor]

Best wishes

[@Gabby_T]

Honestly perfect explanation. Thank you so much!

[@themathandphysicstutor]

You’re welcome

[@WisdomTooth_]

Thank you so much 😊 this was so helpful. You just saved me

[@themathandphysicstutor]

Great news

[@HandzforHire]

Wow, great tutorial! Keep up the good work!

[@themathandphysicstutor]

Cheers

[@girldaddividendinvestor]

Hey, I recognize this voice. 🤣🤣🤣 Great work sir.

[@themathandphysicstutor]

🤫🤫🤫🚀

[@seharjaggi]

YOU ARE A LIFESAVER!! the only video which i found so so helpful!!! THANK U SO MUCHHHH

[@themathandphysicstutor]

Cheers

[@arantza8040]

Hey I'm trying to do the y axis but everytime it says it's invalid and I've tried to do the validation thingy and it's still invalid. What can I do to fix this?

[@themathandphysicstutor]

Follow the steps in the video

[@QuesttoFIRE]

Oh my word....🤣🤣🤣 I'm trying to do the most basic things in google sheets that I can't figure out, so I google... and come to this video... and I'm like, "I recognize this voice."🤣🤣

[@themathandphysicstutor]

:) Hi Rebecca!

[@twrbo6691]

Really helpful

[@themathandphysicstutor]

Thanks for watching. Please share

[@tramnguyenpham9640]

Thank you for the helpful tutorial. Why did you select use row 9 as header? I saw numbers in row #9 and no header. Thanks for your reply.

[@themathandphysicstutor]

No reason

[@ralisgroffen]

My x-values were the same, so different from your graphs, but I made it word because of you, thanks!

[@themathandphysicstutor]

👍🏻

[@notlegallyskylar]

Holy crap, I should have used KZbin before attempting to figure this out by myself for three hours. Thank you.

[@themathandphysicstutor]

No worries.

[@footg6090]

You're a lifesaver thank you

[@themathandphysicstutor]

Cheers

[@artashparalitycy2671]

Thank you, you save me today

[@themathandphysicstutor]

Happy to help

[@ianbarton1990]

👍 Thanks for this. Google Sheets sure can be awkward sometimes!

[@themathandphysicstutor]

Yes it can

[@navn9771]

Can we do this in candlestick OHLC and adding 20 Ema (moving average)in same chart for stock market

[@themathandphysicstutor]

Yeah I’m sure. Pull it from google finance. It will be delayed. Just use TradingView. Lol much easier

[@navn9771]

@@themathandphysicstutor i want to do this in google sheet

[@liamgoodyear8615]

Amazing video, your students are lucky to have you!

[@themathandphysicstutor]

You are so kind

[@zhifengzhang9205]

Google sheet is the worst in plotting. I don't know how the designers thin.

[@themathandphysicstutor]

Call them and ask them!

[@playdoob]

God tier. Thank u

[@themathandphysicstutor]

No problem

[@dahirabdihakim3977]

Thank you!

[@themathandphysicstutor]

You’re welcome

[@anupama990]

Worked like magic

[@themathandphysicstutor]

Sweet

[@UmiGamez]

3:03 Wow! I spent so long trying to figure how to add a new data set and all you had to do was select the blank ones as well

[@themathandphysicstutor]

Boom!

[@avivaben]

Thanks!!! Finally managed to do it thanks to you

[@themathandphysicstutor]

Glad I could help!

[@jaydenmorrobel1051]

ty so much

[@themathandphysicstutor]

You are very welcome

[@እየሩሳሌም-ቀ6ለ]

Thankyou!

[@themathandphysicstutor]

You’re very welcome

[@AliFajarHadi]

thank you

[@themathandphysicstutor]

You're welcome

[@summergallucci8194]

Thank you so much this helped me so much

[@themathandphysicstutor]

You’re welcome

[@RiteshKumar-ll8pp]

Thank you very much for this video

[@themathandphysicstutor]

You’re welcome

[@kelescarlet2585]

i connot explain how helpful this is wow

[@themathandphysicstutor]

Glad to help

[@joet.4053]

This was Great!! thank you.

[@themathandphysicstutor]

You're so welcome!

[@samgraham8742]

You're a legend. Thank you

[@themathandphysicstutor]

Thank you for the kind words

[@swapnilingale4364]

Thank you that helped a lot!!!

[@themathandphysicstutor]

Cheers

[@JarcoPenning]

Great video thanks!

[@themathandphysicstutor]

You're welcome!

[@urbanteachermom93]

Perfect! Thanks!

[@themathandphysicstutor]

You're welcome!

[@abdullahsaid8561]

OR JUST USE EXCEL AND THROW THIS IN THE BIN!

[@themathandphysicstutor]

Oh ok. Right after that I’ll meet you and the other boomers over at the pickle ball courts