How to Make a Scatter Plot in Excel with Multiple Data Sets

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.

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

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, select the entire data set.

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

Step 2:

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

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

Step 3:

  • Finally, a scatter chart will appear.
  • Then, we will title the chart as “Earnings vs Savings”.

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

Step 4:

  • At last, if you want to change the style of your plot, then select the “Style” icon, which is on the right-side of your plot.

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

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

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

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.

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

Step 2:

  • First of all, select the first data chart.

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

Step 3:

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

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

Step 4:

  • Then, after selecting Scatter, you will see a scatter plot with one variable, which is “Monthly Earnings”.

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

Step 5:

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

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

Step 6:

  • After that, a dialogue box named “Select Data Source” will appear.
  • From that box, click on Add.

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

Step 7:

  • After pressing, a new dialogue box named “Edit Series” will appear.
  • There are three blank spaces in that box.
  • In the “Series name” type box, type “Monthly Savings”.
  • Select cell range B13 to B18 of the second chart from the data table in the “Series X values” dropdown.
  • Thirdly, in the “Series Y values” type box, select cell range C13 to C18.
  • Finally, press OK.

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

Step 8:

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

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

Step 9:

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

Step 10:

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

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

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

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

Step 11:

  • Again, if you want to change the style of your plot, then select the “Style” icon, which is on the right-side of your plot.

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

  • Now, select the style as per your choice.

Sample Data Set

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.

Sample Data Set

Step 13:

  • Now, right-click on the chart with two variables from previous method and select “Select Data”.

Sample Data Set

Step 14:

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

Sample Data Set

Step 15:

  • In the Edit Series dialogue box, give “Monthly Expenditure” as the Series Name.
  • Then, select the cell range from B21 to B26 as “Series X Value.
  • Thirdly, give the cell range from C21 to C26 as the “Series Y Value”.
  • Finally, press OK.

Sample Data Set

Step 16:

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

Sample Data Set

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.

Sample Data Set

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

Araf

Araf

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo