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 WORKBOOK

Scatter Chart

Helpful Resource:

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

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Clustered Column Chart: 12 Month Trend An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points. To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values. Below I sho...
Benchmark Chart in Excel 2010 Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months. I will show you how to do this using Using Excel 2010. DOWNLOAD EXCEL WORKBOOK STEP 1: Enter your data into three ...
Change the Axis Units in an Excel Chart Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set. If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in yo...
Create a Waterfall Chart With Excel 2016 Waterfall Charts are one of the many new Charts available only in Excel 2016. They are very popular in the current corporate environment as they graphically show the positive and negative movements within your Monthly Net Profit or Cash Flow. When I was working at General E...