How to Create a Scatterplot Matrix in Excel (With Example)


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:

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:

scatterplot matrix in Excel

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

Leave a Reply

Your email address will not be published.