Creating an XY Scatter Plot in Excel

0:00 Scatter plots show how two numerical values are related
0:29 Scatter graph examples
0:39 How to set up the data table in Excel
1:18 Insert the scatter chart
1:31 Add a title to the chart
1:38 Add labels for the X-axis and Y-axis
2:10 Display more than one set of data in the scatter plot
3:07 Add a legend to the chart
4:38 Add a trendline to a data series
5:17 Change the chart style and design

Don't Forget to Subscribe! 😃

How to Create a Scatter Plot in Google Sheets:

FOLLOW VERTEX42 HERE:

LOOKING FOR SPREADSHEET TEMPLATES? Start Here:

[ProjectQrow]

I’ve been struggling with making a chart for 20 minutes, this literally saved me. Thank you

[georgemensah]

This was easily explained and clear. You saved my butt and I finally got a complex scatter plot done for different groupings in Software and their relative market TDC ratio. Thank you!

[cameronhughes]

Can anyone explain to me why whenever I do a scatter chart it charts the variables seperately?

[lucasekman]

THANK YOU
Been trying to do this with the normal line chart for 2 hours and this took me literally 5 seconds

[Vanz]

This is the best tutorial video I've ever watched.

[theraptor]

This was very helpful easy to understand. There was something i was looking for that wasn't there but that might be apart of the video altogether. This will help with my assignments. Thanks

[choutzeshin]

Thank you so much!!! I was having a headache doing this stuff... and now finally!

[m.night_shyamamalama_sama_kun]

What an amazing level of detail in explanation and in segmenting the video...we can't thank you enough!

[kraigshort]

Even the first three minutes saved my teen as he tried to submit a summer school project. Thanks!

[ThePruneemac]

Thanks so much! Ive been struggling to figure out how to do scatter chart with differing data sets! My chart looks great!

[Not.Spooky]

Thank you so much, my teacher made this so hard to understand

[sibongiletsotetsi]

thank you so much this made things so much easier for me

[garyandrewranford]

I am sure I speak for many. I have also been looking for this as an answer to my question... multiple data patterns on the same chart. Thank you Vertex42

[lakshmankumara]

thank you very much for saving my time

[danielgillett]

what a coincidence, im using this for my research on Douglas fir growth predictions

[primate]

You just saved my life, thank you so much

[wetelectronics]

It's called a "Series" thanks

[ConspiracytardHunter]

thanks yo u helped me with my physics lab

[sonnywilliam]

I appreciate your work because now I've rediscovered the joy of learning computer skills, and most importantly it's fun. Thank you!

[samla]

My excel is missing some of the features ('+' sign and other little squares to the right of the chart). A number of commands, functions she mentions are not in my Excel version :-(