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.
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
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?
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!
You are a wonderful person. I hate excel but this make it easier. Best regards!!!!!
Thanks for posting this video, it's been helpful with my accounting class
Glad it was helpful!
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
Is there a way to add the dates in your example as a date label for each plot point?
very well explained 👍
Very useful great video !! 🏆🏆🏆
thank you
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?
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?
Thanks
my excel is just broken. wont let me swap x and y