A scatter plot helps a viewer visualize data. **Excel** users can analyze statistical data easily with the help of scatter plots. In this article, we will show you **how to make a scatter plot** in **Excel** with multiple data sets.

## Download Practice Workbook

You can download the free **Excel** workbook from here and practice on your own.

## 2 Easy Ways to Make a Scatter Plot in Excel with Multiple Data Sets

To analyze data more comprehensively, sometimes we need to combine two or more charts of data together. Or we have to compare data from different columns in the same chart. Using the **scatter plot** feature of **Excel** for this purpose will help users analyze data more precisely. But some users find it difficult to combine multiple data sets for this purpose. In this article, you will see three easy ways to make a scatter plot in** Excel** with multiple data sets. We will make the scatter plot from a single chart in the first procedure and will combine two charts in the second method and will use three tables in the third one. Consider the following table as a sample data set for our purposes.

### 1. Using Multiple Data Sets from Same Chart to Make a Scatter Plot in Excel

Making a scatter plot in **Excel** using the same chart is quite easy. To make a scatter plot using the same chart in **Excel**, follow the following steps.

**Step 1:**

- First of all,
the entire data set.*select*

**Step 2:**

- Secondly, go to the
*Insert* - Then, from the tab, go to the
from the*Insert Scatter*(X, Y) or*Bubble Chart**Charts.* - Lastly, choose the
*Scatter.*

**Step 3:**

- Finally, a scatter chart will appear.
- Then, we will title the chart as â€ś
**Earnings vs Savings**â€ť.

**Step 4:**

- At last, if you want to change the style of your plot, then select the â€ś
â€ť icon, which is on the right-side of your plot.*Style*

- From that option, select the style as per your choice.

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

### 2. Combining Multiple Data Sets from Different Charts to Make a Scatter Plot

Sometimes, while making a scatter plot in **Excel**, data might be in different tables or charts. Then, the users canâ€™t make the plot through the previous method. In that case, the second method will help in this regard. You can follow the below steps to make a scatter plot in **Excel **with multiple data sets.

**Step 1:**

- Letâ€™s take the following data set for making the scatter plot.
- Here more than one chart of data is present.

**Step 2:**

- First of all, select the first data chart.

**Step 3:**

- Next, go to the
*Insert* - From that tab, go to the
in the*Insert Scatter*(X, Y) or*Bubble Chart**Charts.* - Thirdly, choose
from the options.*Scatter*

**Step 4:**

- Then, after selecting
, you will see a scatter plot with one variable, which is â€ś*Scatter***Monthly Earnings**â€ť.

**Step 5:**

- Now, we will include the second data chart in the scatter plot.
- Then,
on the plot and press the*right-click*.*Select Data*

**Step 6:**

- After that, a dialogue box named â€ś
â€ť will appear.*Select Data Source* - From that box, click on
.*Add*

**Step 7:**

- After pressing, a new dialogue box named â€ś
*Edit*â€ť will appear.*Series* - There are three blank spaces in that box.
- In the â€ś
â€ť type box, type â€ś*Series name*â€ť.*Monthly Savings* - Select cell range
to*B13*of the second chart from the data table in the â€ś*B18*â€ť dropdown.*Series*__X__values - Thirdly, in the â€ś
â€ť type box, select cell range*Series*__Y__valuesto*C13*.*C18* - Finally, press
.*OK*

**Step 8:**

- Now, the dialogue box from step
will appear again.*5* - From that box, press
.*OK*

**Step 9:**

- Now you can see a
**scatter plot with two variables**. - We will name the scatter plot â€ś
**Earning vs Savings**â€ť.

**Step 10:**

- From the
option besides our scatter plot, mark the*Chart Elements*option.*Legend*

- After that, you will be able to see which color indicates which variable in the plot.

**Step 11:**

- Again, if you want to change the style of your plot, then select the â€ś
â€ť icon, which is on the right-side of your plot.*Style*

- Now, select the style as per your choice.

**Step 12:**

- To add more charts to the plot, first of all, we will add an extra data table.
- For example, here we will add the data table for
**Monthly Expenditure**.

**Step 13:**

- Now, right-click on the chart with two variables from previous method and select â€ś
â€ť.*Select Data*

**Step 14:**

- Like the previous method, a dialogue box will appear.
- In the box, click on
.*Add*

**Step 15:**

- In the
dialogue box, give â€ś*Edit Series***Monthly Expenditure**â€ť as the Series Name. - Then, select the cell range from
to*B21*as â€ś*B26*â€ť*Series*__X__Value**.** - Thirdly, give the cell range from
to*C21*as the â€ś*C26*â€ť.*Series*__Y__Value - Finally, press
.*OK*

**Step 16:**

- After that, press
in the*OK*dialogue box.*Select Data Source*

**Step 17:**

- After that, the scatter plot, including three variables will appear.
- Then, name the plot
**Earnings vs Savings vs Expenditure**. - Finally, change the style of the plot if you want it.

**Read More:** **How to Create a Scatter Plot with 4 variables in Excel (with Quick Steps)**

**Conclusion**

Thatâ€™s the end of this article. I hope you find this article helpful. After reading this article, you will be able to make a scatter plot in **Excel** with multiple data sets. Please share any further queries or recommendations with us in the comments section below.

**Related Articles**

**How to Add Vertical Line to Scatter Plot in Excel (2 Easy Methods)****Create a Scatter Plot in Excel with 3 Variables (with Easy Steps)****How to Add Data Labels to Scatter Plot in Excel (2 Easy Ways)****Add Line to Scatter Plot in Excel (3 Practical Examples)****How to Connect Dots in Scatter Plot in Excel (with Easy Steps)****Combine Two Scatter Plots in Excel (Step by Step Analysis)****Use Scatter Chart in Excel to Find Relationships between Two Data Series**