Download Excel Workbook
Table of Contents
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
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.
