Pinterest Pixel

XY Scatter Chart: Related Variables

XY Scatter Chart: Related Variables When you want to find out whether or not 2 variables are... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

XY Scatter Chart: Related Variables | MyExcelOnline XY Scatter Chart: Related Variables | MyExcelOnline

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.

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
XY Scatter Chart: Related Variables | MyExcelOnline XY Scatter Chart: Related Variables | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

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 Academy Online Course.

See also  Microsoft Excel Online Course Private Access - 20+ Hours Beginner to Advanced Course

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...