A scatter plot or scatter chart is a chart used to show the relationship between two quantitative variables.
On this worksheet, we have the height and weight for 10 high school football players.
Let’s create a scatter plot to show how height and weight are related.
When I hit the mouse, Excel builds the chart.
Let’s check Select Data to see how the chart is set up.
Here you might see there is one data series.
Just go for the title, key in an equal sign, and smack the cell.
Next let’s adjust the vertical axis scale.
I’ll double smack the axis, and set the minimum to 100.
Notice the horizontal axis scale was already adjusted by Excel automatically to fit the data.
Next, I’m going to add axis titles.
The easiest way to do this is to use the plus icon.
Just snag the chart, snag the plus icon, and check the checkbox.
While I’m here I’m also going to remove the gridlines.
choose the title, key in an equal sign, and click a cell.
Finally, let’s add a trendline.
Trendlines help make the relationship between the two variables clear.
Right click any data point, then select “Add trendline”.
Excel adds a linear trendline, which works fine for this data.
The data shows a strong linear relationship between height and weight.
Note that you might also use the plus icon to enable and shut down the trendline.
