Pinterest Pixel

XY Scatter Chart: Related Variables

John Michaloudis
XY Scatter Chart: Related Variables.
When you want to find out whether or not 2 variables are related or correlated, then an XY Scatter Chart should be used to plot the graph.
XY Scatter Chart: Related Variables | MyExcelOnline XY Scatter Chart: Related Variables | MyExcelOnline

Related variables will show up on the graph as dots that are almost in a straight line.  Examples of variables that have relationships could be Richter scale values & Deaths, Temperature & Latitude and a Wife´s age with a Husband´s age.

download workbookScatter-Chart.xlsx

 

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Bubble Chart with 3 Variables On A Chart

Steps To Follow

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...