As Donald Trump would like to put it, this is probably one of the most insightful excel video tutorial in the history of excel video tutorials, maybe ever. You have explained the concept by a lot. Record explanation. You've done a great job.
Blimey! You are a star. Thank you, thank you, thank you.Even though I am using a later version of Excel, I still found your explanations so clear, so straightforward and so easy to carry out.
ive been looking for a video like this for the past 1 hour and finally found.Its very few channels or google searches that answered my questionand my assighnments due....thanks!!!!😍😊
Thank you so much Sir..this was what I was searching for..many videos I got but no one was like this and could not get anything I needed from those..and your way of explaining is also fabulous Sir 🙏🏻
I've been looking for over an hour for how to do this! Thank you so much for explaining this so clearly (I only wish you had an updated version). Adding a line with my newer version of Excel doesn't seem to work the same way. :(
Instead of using the line graph, choose a scatter diagram. It'll show the X and Y series. You might also just insert the Excel file in word, they'll pop up.
excelent video only one question I am not sure why in my version when i click the Select Data Option it only shoes me the X axis and the z axis to the left side would you know how can i change that?
That depends on the type of data that you have. You would need to create another column that sums the dependent variable (y-axis variable) from your two data sets. Then just extend the approach of the video to add a third data set that is the total. In the case of this example, the two metals are different and so there is not expected to be any important relationship between the sum of their masses and their volumes.
Thanks for this video. However, I have a question! Even though the number of data for both line is same, but here is difference in plot. To plot 2nd line, why excel take only 4 points instead of 6 points. Please make me clear. It will be highly appretiable. thanks in advance.
LITERALLY SAVED ME FROM FAILING MY . COULD NOT FIGURE OUT HOW TO PLOT THE DATA I WANTED . CANT THANK YOU ENOUGH
Well this was super clear ,didn't have to watch it all to get what I was looking for ,well done.
Yeah same here
@@ecaterinagamez3314 yep same here aswell
As Donald Trump would like to put it, this is probably one of the most insightful excel video tutorial in the history of excel video tutorials, maybe ever. You have explained the concept by a lot. Record explanation. You've done a great job.
This man has saved me a lot of time to work on my post lab XD Thank you!
The best video out there ,if you don't have a clue on what you are doing
It's been about four years... still a great video. Thanks man.
Super clear, insightful, and straight to the point. Thank you so much sir.
Blimey! You are a star. Thank you, thank you, thank you.Even though I am using a later version of Excel, I still found your explanations so clear, so straightforward and so easy to carry out.
You make it sound so easy. I have known and used Excel since Office 97, but this is the first time I learned about plotting values.
ive been looking for a video like this for the past 1 hour and finally found.Its very few channels or google searches that answered my questionand my assighnments due....thanks!!!!😍😊
This guy is the actual 🐐
Thank you. I have been consistently trying to put all the data in at once. One line at a time. Great!!
you saved my assignment. The video is so on point that got me to subscribe to your channel and hit the notification button too.
short and to the point. great job Clayton
Yes, thank you so much Mr. Spencer. This worked for me; video was clear and concise. Other videos were so confusing.
If I ever see you, I'm gonna hug you :| Thank you sooooo much for this.
Thank you very much, it helped me a great deal without having to watch the entire video, this tells how precise it is.
7 years in, and still helping the world.
thank you so much. my chem prof asked us to graph two sets of data without explaining it at all but this was so helpful. thank you!
Thankyou, Sir
I have plot graph in my under-graduated project, case of 2 sample with a different horizontal-axis value
This so helpfull, Gbu
Thank You mister for saving our physics graph
Excellent video! Idk why Excel makes things so complicated, love you man 🔥
Thank you very much. Not many people showed this kind of plot.
Thank you so much Sir..this was what I was searching for..many videos I got but no one was like this and could not get anything I needed from those..and your way of explaining is also fabulous Sir 🙏🏻
This video was SO HELPFUL! Thank you
You are a LEGEND for this video
Thank you very much Mr. Spencer. This was exactly what I needed.
THANK YOU SO MUCH! Perfect job explaining this!!
Clearly, and concisely explained. Thank you very much indeed!
Thank you my kind sir. This helped me with my math modeling final project.
Sir, your explanation is perfect thanks a lot
I've been looking for over an hour for how to do this! Thank you so much for explaining this so clearly (I only wish you had an updated version). Adding a line with my newer version of Excel doesn't seem to work the same way. :(
Brilliant stuff straight to the point
Thank you for this its very helpful! Clear, short, and precise tutorial
Thank you! exactly what I was looking for.
you just saved my deadass sir...hats off
Thank you. A FABULOUS EXPLANATION.
thank god for your video! many thanks! and you were on point for everything - not dragging out the video for view minutes
idk my excel doesnt have series X/Y values edit, its only series name and " series values". Im using office 2016 pro plus.
Instead of using the line graph, choose a scatter diagram. It'll show the X and Y series. You might also just insert the Excel file in word, they'll pop up.
A million thanks to you.
Wonderful, just what I was looking for! Thank you!
oh my days... thank you so much for your help!!! I appreciate this a lot!!
Most perfect explanation. THANKS
This was very clear and concise , thanks!
Thank you so much! This was an easy to follow tutorial and saved me so much time.
i love you i dont understand why i never found usefule informations in polish language
Thank you for the video, it was really clear and helpful
extremely good helped me a lot thank you so much
Thanks a billion.I wasted my time watching a bunch of other videos that were of absolutely no help
Thank you so much ! It's a great help !
Awesome .Very well explained. Thanks a lot
You sir, have helped me tremendously for my kinetics and reactors course. Thank you !
Thank you so much that was so clear and straightforward
Very helpful and easy to understand!
Really great video, super concise and useful :)
how did you get the option to put in y-values?
my version only has 1 series option smh
this saved me so much time, thanks!
Very useful sir. Highly appreciated!
Amazing video. Very informative
That was amazing. Super easy to follow thank you sooo much
you deserve a big like
Thank you so much. It actually answered my question :D
How can you do this for classes (categorical variables) in a boxplot for example?
YOU ARE JUST THE BEST EVER !!! MY GOSH!!! thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu!!
clutchest video ever (it's 1:36 am) So i cant ask the professor rn
Thank you very much! The video is concise and clear.
Just an observation, you sound a little bit like Dave Foley! Thank you for the great video.
You the best !! My grade thanks you 🙏
You saved my life !! Thank you
Perfect for chem. graph. Thank you very much.
That's very useful and simple enough, thanks!
excelent video only one question
I am not sure why in my version when i click the Select Data Option it only shoes me the X axis and the z axis to the left side would you know how can i change that?
Thanks for sharing, only your video did it help me from others on understanding the combo graphs. Thanks and God bless =)
thank you so much that was quick and straight to the point
Thanks champ, very helpful. I hate this assignment
Thanks man your video really helped me out🤘🏻🤘🏻
Thanks very much. I've subbed. This will improve my life :D
Thank you...that's very helpful
That is really helpful...thanks
Great tutorial, thanks man
wonderful tutorial. Thank you!
How would you plot the average between the 2 sets of data?
THANK YOU, this was extremely helpful
Awesome video
Thank you
it was very good help
Thank you
Thank you very much ....it really helped me a lot🙏🤝
Thank you very much,it helps me very much
Very helpful - thank you!
You're a gentalman thanks so much.
Thanks so much for this video, massive help :)
*1 Question*
Sir does we make graph of total as well or not?
That depends on the type of data that you have. You would need to create another column that sums the dependent variable (y-axis variable) from your two data sets. Then just extend the approach of the video to add a third data set that is the total. In the case of this example, the two metals are different and so there is not expected to be any important relationship between the sum of their masses and their volumes.
@@TrueBlueChemProf
Thanks a million🌷
Stay blessed always
Ameen
Can we add 1 more data to the graph
Thank you this was really helpful
Thanks for this video. However, I have a question! Even though the number of data for both line is same, but here is difference in plot. To plot 2nd line, why excel take only 4 points instead of 6 points. Please make me clear. It will be highly appretiable. thanks in advance.
Thank you clear explanation
when i click ADD on the select data box i get a pop up with two slots instead of three. Kindly assist.
Thanks, Clayton!
Can we do this in spss?
Thaaaaaaanks, excellent explanation
what if i have the datas on two separate worsheets?