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.

XY Scatter Chart: Related Variables | MyExcelOnline



Helpful Resource:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook


Tweet about this on Twitter

Share on LinkedIn