This video saved my task. Thank you so much! I actually saw some other video and got confused but after watching this I could create my task in 10 min.
Is there a way to add many series quickly to the one chart withough manually reading-in the cell ranges? Say if there are only 3 columns in the worksheet, 2 being the X & Y numerical variables, & the other being a categorical variable for which we want a separate series?
Great video. I had one issue - this only works well if the data is of the same type. How do you do this is the data you want is of different types (percentage vs. number over time) The horizontal axis at the bottom is date, I need to see at what point a specific date a count (number) crosses efficiency (percent - %). The data given to me in one chart with multiple columns labeled "count and efficiency. The data running vertically on the left are the dates.
how come whenever I try to do the same thing except when I dont do CTRL+shift+down and i just click and drag down I can then no longer select y-values?
Great video, thanks for the help. I still had a tough time plotting two sets of water elevation over time. One set of data from the US Geographical Survey (data taken every 3 minutes), and one set of monthly data that was hand written (data taken at random times maybe once a day over the course of a month). The thing is, I discovered that you must have the same time and equal number of time stamps in each data set. So you must copy the handwritten times to the USGS data to the closest time which is what I did. Or I could write a script to extrapolate the USGS elevation, and add a record that matches the time of the handwritten time. And MS Access? I couldn't find a way to graph two record sources.
Ok, so when I clicked "Insert," it did not allow me to select any type of visual representation form (bar, scatter, etc.). Those options were greyed out. I then tried to select some data first, and then it allowed me to select the graph I wanted. However, what my version of Excel presented did not match what you were talking us through. I'm currently using version 16.82, is your version different. I don't know how many updates have happened since your video was posted.
Here is my problem: I have two sets of data (one sorted ascending, the other descending). When I select the 1st series, it added to the Graph as usual. When I select the 2nd series (descending data), it only added the 1st data point...
OMG u saved my lab report! Thank you
Same here
Same here
Same here
Same
Same here
Excellent video! You took 3 minutes to explain what hours of googling could not. Thank you!
Glad it was helpful!
I was about to give up on the lab after 4 videos of this, thank you so much!
“Show a legend”… You are the legend!😌
it took me so many hours of searching through videos, forums and eventualy stumble on your video and it was perfect. Just what i nedded -- Thank you
ive been using excel extensively for some years now and that ctrl shift down trick is a MIRACLE
This video saved my task. Thank you so much! I actually saw some other video and got confused but after watching this I could create my task in 10 min.
Thanks for coming through I was really stuck here may God bless your work
This video is great. Thank you for this. Learned more from your video than I did while in class
U made it look so easy. Thank u
Absolute LEGEND this was so helpful and clear 🙏🙏 thank you thank you!
May god give you a long life!
very helpfull. thankyou , very calm and it worked for my chemistry excel graphing. i needed to put 3 plots on a graph and i used the same process.
Is there a way to add many series quickly to the one chart withough manually reading-in the cell ranges? Say if there are only 3 columns in the worksheet, 2 being the X & Y numerical variables, & the other being a categorical variable for which we want a separate series?
Thanks. This was a big help.
Great video. I had one issue - this only works well if the data is of the same type. How do you do this is the data you want is of different types (percentage vs. number over time) The horizontal axis at the bottom is date, I need to see at what point a specific date a count (number) crosses efficiency (percent - %). The data given to me in one chart with multiple columns labeled "count and efficiency. The data running vertically on the left are the dates.
This saved me a lot of struggle in the assignment, thank you!
Very useful video , thank you
Thanks a lot. you save my time
was trying to figure this one out for like 30 mins. good thing i saw this vid. lifesaver thanks!
Thank you so much! excel was driving me crazy
very helpful thx!
Great work!
Thank you! Cheers!
This helped me so much, thank you!
Thank you! Very useful and clear.
Great Video. Straight to the point!
Saved my lab report tonight! Thank you so much good sir! 🫡
Thank you. You are a Life saver
ayo
Hello sir. How did you seperate the years? Is it by mouse after the filter or something else ?
how come whenever I try to do the same thing except when I dont do CTRL+shift+down and i just click and drag down I can then no longer select y-values?
How do I do this in google sheets
exactly what I was looking for - wish I had found this sooner. thank you!
You're very welcome!
Great video, thanks for the help. I still had a tough time plotting two sets of water elevation over time. One set of data from the US Geographical Survey (data taken every 3 minutes), and one set of monthly data that was hand written (data taken at random times maybe once a day over the course of a month). The thing is, I discovered that you must have the same time and equal number of time stamps in each data set. So you must copy the handwritten times to the USGS data to the closest time which is what I did. Or I could write a script to extrapolate the USGS elevation, and add a record that matches the time of the handwritten time. And MS Access? I couldn't find a way to graph two record sources.
you rock Chester.
Ok, so when I clicked "Insert," it did not allow me to select any type of visual representation form (bar, scatter, etc.). Those options were greyed out. I then tried to select some data first, and then it allowed me to select the graph I wanted. However, what my version of Excel presented did not match what you were talking us through. I'm currently using version 16.82, is your version different. I don't know how many updates have happened since your video was posted.
Thanks soooooo much or your help!!!!!!!!!!!!!!!
I want to show the user login date, time and user names on one graph. Could it be possible to show three in one graph
Thanks, was very usefull.
How can I do this on a Chromebook?
Thank you ☝️😢👍🫡 making tge world a better place
thanks! Short, informative and handy video!
Thank you so much for a very simplified explanation.
Absolute lifesaver. Cheers, Chester!
Thanks!
THANK YOUUU
That was very helpful, thanks
This was really helpful to me, thanks a lot
but there is no series X value and series Y value
only series name and series value what should i do now? please tell me.
What if I have multiple data sets in separate sheets? Could I still follow this process? Thank you!
Very helpful. Thanks
why do my ctrl+shift+down is sometimes not working?
like, it work sometimes but other times it just refuses
How to locate inresection point of line
thnx this helps alot😊😊😊
Thanks
Thank you for the video this clearly explained how to do it🤝
thank you so much, you help me a lot
Thank you ❤️
Thanks Alot Sir
Excellent
Thank you! Cheers!
Thank you
I'm just getting 1 axis value. Please help! :(
Thank you!!!
Very helpful
Thanks
My third chart messes up the entire graph 😔
awesome!
Here is my problem: I have two sets of data (one sorted ascending, the other descending).
When I select the 1st series, it added to the Graph as usual.
When I select the 2nd series (descending data), it only added the 1st data point...
What about, say… 12 data series? All of the same X and Y axis type
thank you soooo much
💛🧡🔥
Thank you so much!
Thank you! 👍