**Scatter Plot Matrix** is very handy to compare the bivariate relations of multiple variables. In this article, I will demonstrate how to create a **Scatter Plot Matrix** in **Excel** with very simple steps.

**Table of Contents**hide

## Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.

## What is Scatter Plot Matrix?

Suppose you have a dataset of **multiple** variables. If you want to compare the relationship of each **2** variables of the dataset, you need to create a **Matrix** where every possible combination of bivariate variables is present. Now, in **Excel, **you can just create a **Scatter Chart** of each set of bivariate variables. Then arrange the scattered chart in a **Matrix **form. Therefore, you got your **Scatter Plot Matrix**. It is very functional in** Statistical **analysis.

## Step-by-Step Procedures to Create Scatter Plot Matrix in Excel

It is straightforward to plot **Scatter Plot Matrix** in **Excel**. I will** Insert** the **Scatter Chart** into my dataset to create a **Scatter Plot** in **Excel**. Later the chart will be resized and readjusted so that I can use it to create the** Matrix**. So, letâ€™s go through the process quickly.

### Step-01: Create a Dataset

In the first place, you need a dataset with multiple variables. I have a dataset here representing the **Monthly Average Weather Data **of** New York City**. Moreover, the dataset has **3** variables. Those are **Month**, **Avg. Temperature**, and **Humidity**.

**Read More: ****How to Create a Scatter Plot in Excel with 3 Variables (with Easy Steps)**

### Step-02: Insert Scatter Chart

This step will introduce a **Scatter Chart **with a selected array.

- First, select the columns
**Month**and**Temperature**. - Next, click on
**Insert**. - Then, choose the
**Charts option**.

- Afterward, from
**Charts**select the**ScatterÂ**one. - Finally, click on the
**1st**type from**Scatter ChartsÂ**option.

- Accordingly, you will get the
**Scatter****Chart**with selected columns.

**Read More: ****How to Make a Scatter Plot in Excel with Multiple Data Sets**

### Step-03: Remove Chart Title and Gridlines

To make the chart clean and prominent, I will remove the **Gridlines** and **Chart Title**.

- Initially, click on the
**+**sign at the top**right**corner of the**Scatter Chart**. - Notice that there is a
**tick**beside the**Gridlines**option.

- Now, uncheck
**Gridlines**. - As a result, you can see that
**Gridlines**from the chart have vanished.

- Besides, I will delete the
**Chart Title**as I will add**Labels**after completing the**Matrix**. - Again, click the
**+**sign at the top**right**corner of the**Scatter Chart**. **Chart Elements**will appear.- At this point, uncheck the
**Chart Title**.

- Consequently, the
**Chart Title**has disappeared.

**Read More: ****How to Make a Scatter Plot in Excel with Two Sets of Data (in Easy Steps)**

**Similar Readings**

**How to Connect Dots in Scatter Plot in Excel (with Easy Steps)****Add Multiple Series Labels in Scatter Plot in Excel****How to Make a Correlation Scatter Plot in Excel (2 Quick Methods)****Combine Two Scatter Plots in Excel (Step by Step Analysis)****How to Create a Scatter Chart in Excel (with Easy Steps)**

### Step-04: Change Minimum Axis Bound

In this step I will readjust the **Bound Maximum** and **Minimum **value in **Format Axis** Pane.

- In the first place, select the
**Vertical Axis**of the Chart which is also marked in the snapshot.

- Later,
**right-click**on the selected**Vertical Axis**. - From the options, hit the
**Format AxisÂ**option.

- Thus,
**Format Axis Pane**has opened. - Here, Bounds Minimum is set as
**0,**and the Maximum is set as**90.0**.

- Since in my dataset, the range of values for
**Temperature**is**40-80**, I will reset the**Minimum**value as**40.0**and the**Maximum**value as**80.0**.

- Finally, hit
**Enter**and eventually the**Maximum**and**Minimum**value of the**Axis**is changed, and this step makes the chart more relevant.

- Similarly, change the
**Bounds**value for the**Horizontal Axis**. - To start, click on the
**Horizontal Axis**marked in the picture.

- Secondly,
**right-click**on the**Horizontal Axis**. - Accordingly, choose the
**Format AxisÂ**option.

- Now, the
**Format Axis**Pane is visible. - You must
**Reset**the**Minimum**and**Maximum**values according to your dataset value.

- As my dataset has only
**6**Months, I will**Reset**the**Maximum**value to**0**. - Please follow your dataset to find the
**Maximum**and**Minimum**values and**Reset**accordingly.

- In conclusion, both of your
**Axis Bounds**are adjusted after following the steps.

**Read More: ****How to Draw 3-Axis Scatter Plot in Excel (with Easy Steps)**

### Step-05: Resize the Chart

This particular step is to make the overall outlook easy to readable for the readers.

**Resize**the**Scatter Chart**and place this below the dataset.- As this will be a
**Scatter Plot Matrix**, make the chart smaller so that other bivariate relations can be placed under this. Follow the picture for a better understanding.

**Read More: ****How to Make Scatter Plot in Excel (with Easy Steps)**

**Similar Readings**

**How to Create a Scatter Plot in Excel with 2 Variables****Add Horizontal Line in Excel Scatter Plot (2 Quick Methods)****How to Add Text to Scatter Plot in Excel (2 Easy Ways)****Add Line to Scatter Plot in Excel (3 Practical Examples)****How to Add Average Line to Scatter Plot in Excel (3 Ways)**

### Step-06: Complete the Scatter Matrix

The dataset has **3 **variables. This means another **2** combinations of variable sets are possible. So, letâ€™s complete the Scatter Plot Matrix.

- Initially, select the
**Month**and**HumidityÂ**columns. - Then, click on
**Insert,**and after that hit on the**ChartsÂ**option. - Choose the
**first**option under**ScatterÂ**type.

- As a result, you will get a
**Scatter Chart**representing the relationship between**Month**and**Humidity**.

- Furthermore, remove the
**Chart Title**and**Gridlines**following**Step-03**.

- Like the previous chart, adjust the
**Bounds Maximum**and**Minimum**values of the Chart. - For this, follow
**Step-04**.

- Hence, I have
**Reset**the range for**Vertical Axis**to**50-90**. Because in the**Humidity**column, the values are in this range. - Similarly, for
**Horizontal Axis**I have**Reset**the range to**0-6**.

- At this point, you can change the
**Color**of the**Scatter Chart**to differentiate among the relations. - In the first place, click on the
**Brush icon**just below the**+Â**sign. - Then, select
**Color**. - Finally, choose any color except the previous chartâ€™s color.

- Moreover, resize the chart and place this below the first chart to create the Matrix.

- Lastly, select the
**Temperature**and**Humidity**Column. - Insert
**Scatter Chart**by just repeating the same actions.

- In addition, resize the Chart and complete the
**Scatter Plot Matrix**.

**Read More: ****How to Create Excel Scatter Plot Color by Group (3 Suitable Ways)**

### Step-07: Introduce Label to the Scatter Plots

You must **Label** the chart so that readers can analyze the **Matrix** to understand the relationships. In this step, I will **Label** the Charts.

- Add the
**Labels**according to your dataset.

- After adding
**Labels**the**Scatter Plot Matrix**is ready now. - The top left corner indicates the relationship between
**Month**and**Temperature**. - Next, the bottom left represents the data points of
**Month**and**Humidity**. - In conclusion, the bottom right corner expresses the connection of
**Temperature**and**Humidity**.

**Read More: ****How to Add Data Labels to Scatter Plot in Excel (2 Easy Ways)**

## Things to Remember

- Be careful while
**Labeling**the**Scatter Plot Matrix**. One wrong Label can mislead the readers in the whole chart. - Try to keep the outlook simple and clean as there may be many variable pairs in one Matrix.

## Practice Section

Here, we have provided a practice sheet for you to practice.

## Conclusion

In this article, I have shown the steps of creating a **Scatter Chart** and making this into a **Matrix**. There may be more variables in your dataset. In that case, prepare the combinations and then arrange the charts accordingly. I hope this article gave you a clear idea about how to create a **Scatter Plot Matrix** in **Excel**. If you have any questions regarding this, please comment down.