Excel Lesson in Gregory's Physics Class #1: Setup Data, X-Y Scatter Plot, Add Chart Labels

[@excelisfun]

I am glad that you like it!!!

[@ttranuyen]

thank you! you're so helpful! couldnt have done my chemistry project without the help of your vid!

[@adamhudson4332]

Thanks for a great tute on something that should be so easy, but is often counter-intuitive!

[@excelisfun]

Thanks you, Harvey3101 !!! Yes, you are correct. But I made these videos just for Gregory's Physics Class. (He works in the office next to mine and puts up with me making videos everyday (he can hear me through the wall) and so the least I can do is to make a few videos for him!!). In this regard, the entire series (4 videos) is REALLY good for anyone who wants to learn about X-Y Scatter. Video #4 is particular good!

[@GabiRav]

Thank you mike, Using the names (by Cntr+Shift+F3 ) to all the parameter can help. Build a Dynamic title is better for user who gone changed the parameters. (Doing this by concatenated) Same way build a note for starting point and step

[@excelisfun]

It is not easy to do. You have to create formulas in the cells that show half blanks and half values and then repeat the data series twice, then add both data series to chart. I do not have an X Y chart video to show that, but I do have an area chart video that shows that: Excel Dynamic Chart #11: Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics

[@aelone]

hi, can you show us how to shade the graph in few color for different zone? Let say, blue and red line is in different scale (it's fit as primary and secondary). e.g: how to shade the zone (blue line > red line "red color")

[@MGachegov]

You too have an increasing X. Do you have an example with X varying like 5-4-10-9-3-2-1? Fail to make a chart of blood pressure.

[@GabiRav]

my remark was for another video Plot F(x) Function & Chart In Excel - Gregory's Physics Class Acceleration of Block Up Down Ramp sorry

[@Harvey3101]

Great, as every time. But I dont think that this video is just interesting for physics, you could also make use of this video for finance, economics and all ohter kind of statistic, so I hope the title doesnt lead to looking only people who are interested in physics.