A scatterplot matrix is a matrix of scatterplots that lets you understand the pairwise relationship between different variables in a dataset.
This tutorial explains how to create the following scatterplot matrix in Excel:
Let’s jump in!
Step 1: Enter the Data
First, let’s enter the following values for a dataset that contains three variables: points, assists, and rebounds.
Step 2: Create the Scatterplots
Next, let’s highlight the cell range A2:B9, then click the Insert tab, then click the Scatter button within the Charts group.
The following scatterplot of points vs. assists will automatically be created:
Next, perform the following steps:
- Click on the values on the x-axis and change the minimum axis bound to 80.
- Click the y-axis and change the minimum axis bound to 20.
- Click the Chart Title and delete it.
- Click on the gridlines in the chart and delete them.
- Lastly, resize the chart to make it smaller.
The end result should looking something like this:
Next, repeat these exact same steps for the points and rebounds variables and place the scatterplot under the existing scatterplot:
Lastly, repeat these steps for the assists and rebounds variables and place the scatterplot in the bottom right corner:
Step 3: Label the Scatterplots
Lastly, type the variable names next to the scatterplots so that it’s easy to understand which scatterplots represent which variables:
Here’s how to interpret the plots:
- The scatterplot in the top left corner represents the relationship between points and assists.
- The scatterplot in the bottom left corner represents the relationship between points and rebounds.
- The scatterplot in the bottom right corner represents the relationship between assists and rebounds.
Note: Feel free to modify the color and size of the points in the scatterplots to make them appear however you’d’ like.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
How to Create a Scatterplot with Multiple Series in Excel
How to Create a Correlation Matrix in Excel
How to Perform a Correlation Test in Excel