Its 2023 and Excel has remains extremely deficient in plotting the simplest and most basic of all charts - the xy Chart (Some variations of XY Scatter works but its horrendous and leaves out the label for the X axis.). It always wants to plot x and y as two DIFFERENT series when its ONE series (x,y). Its mind boggling that the folks at microsoft have not grasped the concept of XY Graphs.
Hi great video! How can I plot several Y values for the same X within the same series? I have my X values in a column and three values of Y for each X in the right side columns next to the X column. When I try to plot it it tooks each Y column as an individual series and not as a replicate. Can you help me?
This video is awesome, thank you for elegantly simplifying this complex software. This has been a tremendous help for my chemistry classes in calibration curves and Arrhenius Plots
thanks - one thing I find odd with excel is that it doesnt auto generate axis labels - this would make its approach to x vs y a lot simpler for novices i feel
Its 2023 and Excel has remains extremely deficient in plotting the simplest and most basic of all charts - the xy Chart (Some variations of XY Scatter works but its horrendous and leaves out the label for the X axis.). It always wants to plot x and y as two DIFFERENT series when its ONE series (x,y). Its mind boggling that the folks at microsoft have not grasped the concept of XY Graphs.
sadly I have to agree. Microsoft is clear example of humanity going dumber and dumber.
Sincere thanks Chester. Microsoft should hire you to create their Excel training videos! Your presentation is simple and very easy to understand!
Thank you! Very well structured tutorial.
By far the best video covering so much over the subject. Didn't know I could double click the axis numbers to do that!
Thanks for posting this video, it's been helpful with my accounting class
Glad it was helpful!
You are a wonderful person. I hate excel but this make it easier. Best regards!!!!!
Is there a way to add the dates in your example as a date label for each plot point?
very well explained 👍
Hi great video! How can I plot several Y values for the same X within the same series? I have my X values in a column and three values of Y for each X in the right side columns next to the X column. When I try to plot it it tooks each Y column as an individual series and not as a replicate. Can you help me?
This video is awesome, thank you for elegantly simplifying this complex software. This has been a tremendous help for my chemistry classes in calibration curves and Arrhenius Plots
Sharing this with all my classmates who have questions on excell
Very useful great video !! 🏆🏆🏆
thanks - one thing I find odd with excel is that it doesnt auto generate axis labels - this would make its approach to x vs y a lot simpler for novices i feel
why there is a red thing everytime i tried to plot the x and y values unlike yours it only has blue and violet?
thank you
my excel is just broken. wont let me swap x and y
Thanks