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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Chart Layouts When you create an Excel chart you can choose from 11 different custom Chart Layouts.This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button.From this selection you can show your Chart with or without t...
Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can!To create an Excel Table you need to highlight your data and press CTRL+TSee Tutorial HereOnce you have your Excel Table you can add your Excel Sparklines inside one Column and us...
100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total.So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year.DOWNL...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function.The RPT function uses the vertical bar character | as the first argument: text and references the va...