How To Make A Graph On Google Sheets With Multiple Data Sets & Independent Variables
Vložit
- čas přidán 24. 09. 2020
- 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!
*Data From These Graphs Can Be Found Here* czcams.com/video/I9OLuUMEfjM/video.html
THANK YOU SO MUCH! I HAVE BEEN SPENDING THE PAST 2 HOURS TRYING TO FIGURE THIS OUT. I CANNOT THANK YOU ENOUGH!!!
You're very welcome!
Absolutely amazing! Every single thing you said in this video helped me set up my graph!
Awesome
This is incredibly helpful. Couldn't find the solution you showed here anywhere in Google's own help pages.
Please share!
@Lordeverfall100 well what are you trying to do?? This was very helpful for what I wanted to do lol
Honestly perfect explanation. Thank you so much!
You’re welcome
thank you, really useful!
You're welcome!
Wow, great tutorial! Keep up the good work!
Cheers
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
Awesome
YOU ARE A LIFESAVER!!
the only video which i found so so helpful!!! THANK U SO MUCHHHH
Cheers
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.
Oh
Thank you so much 😊 this was so helpful. You just saved me
Great news
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👍
hope your video gets more likes; this really helped me when my Excel stopped working
Cheers. Thank you
Thanks!!! Finally managed to do it thanks to you
Glad I could help!
This was Great!! thank you.
You're so welcome!
Thank you that helped a lot!!!
Cheers
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
Boom!
Amazing video, your students are lucky to have you!
You are so kind
God tier. Thank u
No problem
Perfect! Thanks!
You're welcome!
Worked like magic
Sweet
You're a lifesaver thank you
Cheers
Thank you very much for this video
You’re welcome
Holy crap, I should have used CZcams before attempting to figure this out by myself for three hours. Thank you.
No worries.
Really helpful
Thanks for watching. Please share
Thank you so much this helped me so much
You’re welcome
My x-values were the same, so different from your graphs, but I made it word because of you, thanks!
👍🏻
i connot explain how helpful this is wow
Glad to help
👍 Thanks for this. Google Sheets sure can be awkward sometimes!
Yes it can
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.
No reason
You're a legend. Thank you
Thank you for the kind words
Thank you!
You’re welcome
Thank you, you save me today
Happy to help
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?
Follow the steps in the video
Thankyou!
You’re very welcome
Can we do this in candlestick OHLC and adding 20 Ema (moving average)in same chart for stock market
Yeah I’m sure. Pull it from google finance. It will be delayed. Just use TradingView. Lol much easier
@@themathandphysicstutor i want to do this in google sheet
ty so much
You are very welcome
This is better than Kahn Academy
Thank you Michael. Please share!
Hey, I recognize this voice. 🤣🤣🤣 Great work sir.
🤫🤫🤫🚀
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."🤣🤣
:) Hi Rebecca!
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.
Glad it helped
Google sheet is the worst in plotting. I don't know how the designers thin.
Call them and ask them!
Great video thanks!
You're welcome!