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.
- First of all, select the entire data set.
- 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.
- Finally, a scatter chart will appear.
- Then, we will title the chart as “Earnings vs Savings”.
- 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.
- From that option, select the style as per your choice.
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.
- Let’s take the following data set for making the scatter plot.
- Here more than one chart of data is present.
- First of all, select the first data chart.
- 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.
- Then, after selecting Scatter, you will see a scatter plot with one variable, which is “Monthly Earnings”.
- Now, we will include the second data chart in the scatter plot.
- Then, right-click on the plot and press the Select Data.
- After that, a dialogue box named “Select Data Source” will appear.
- From that box, click on Add.
- 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.
- Now, the dialogue box from step 5 will appear again.
- From that box, press OK.
- Now you can see a scatter plot with two variables.
- We will name the scatter plot “Earning vs Savings”.
- From the Chart Elements option besides our scatter plot, mark the Legend option.
- After that, you will be able to see which color indicates which variable in the plot.
- 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.
- Now, select the style as per your choice.
- 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.
- Now, right-click on the chart with two variables from previous method and select “Select Data”.
- Like the previous method, a dialogue box will appear.
- In the box, click on Add.
- 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.
- After that, press OK in the Select Data Source dialogue box.
- 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.
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.
- 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