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.