How to Combine Two Scatter Plots in Excel (Step by Step Analysis)

In Excel, the combination of scatter plots allows you to show and analyze two separate data sets that are connected to each other. A standard chart in Excel typically contains simply one X-axis and one Y-axis. A combination of scatter plots, on the other hand, allow you to have two Y-axes, allowing you to have two distinct sorts of sample points in the same plots. In this tutorial, we will explain to you how to combine two scatter plots in Excel to get better and comparable visualization.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


7 Easy Steps to Combine Two Scatter Plots in Excel

The fundamental strategy of combining two scatter plots will be discussed in the section below. To complete the task, we will use Excel’s built-in features. Later on, we’ll go through ways to make scatter plots seem more visually appealing when displaying data. A sample data set is represented in the image below to accomplish the task.

Steps to Combine Two Scatter Plots in Excel

Step 1: Use the Charts Ribbon to Select Scatter Option

  • Firstly, from the Ribbon, click on Insert.

Steps to Combine Two Scatter Plots in Excel

  • Secondly, click on the Charts Ribbon.

Steps to Combine Two Scatter Plots in Excel

  • Select the Scatter option and choose any layout you prefer to display.

Steps to Combine Two Scatter Plots in Excel

  • Double-click the Chart Area to display the Chart Tools.

Steps to Combine Two Scatter Plots in Excel

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


Step 2: Select Data to Create the First Scatter Plot

  • Then, click on the Select Data.

Steps to Combine Two Scatter Plots in Excel

  • Click on the Add from the Select Data Source Box.

Steps to Combine Two Scatter Plots in Excel

  • Take the cursor to the Series name box.
  • Select the merged cell ‘2021’ to enter it as the Series name.

Steps to Combine Two Scatter Plots in Excel

  • Take the cursor to the Series X values.
  • Select the range C5:C10 as the X values.

Steps to Combine Two Scatter Plots in Excel

  • After that, take the cursor to the Series Y value.
  • Select the range D5:D10 as the Y values.
  • Press Enter.

Steps to Combine Two Scatter Plots in Excel

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


Step 3: Add Another Series to Combine Two Scatter Plots

  • Click on the Add again, and select the cell for the new Series name.

Steps to Combine Two Scatter Plots in Excel

  • Like previously, select the range C13:C18 as the X values.

Steps to Combine Two Scatter Plots in Excel

  • To select the Y values, select the range D13:D18.

Steps to Combine Two Scatter Plots in Excel

  • Therefore, the two series names of scatter plots will appear as the image shown below.
  • Press Enter to continue.

Steps to Combine Two Scatter Plots in Excel

  • As a result, you will get the two scatter plots combined in a single frame.

Steps to Combine Two Scatter Plots in Excel

Read More: How to Add Multiple Series Labels in Scatter Plot in Excel


Similar Readings


Step 4: Change the Layout of Two Combined Scatter Plots

  • To get better visualization, you can choose any layout.
  • Go to the Quick Layout option, and choose a Layout. In our example, we have chosen Layout 8.

Steps to Combine Two Scatter Plots in Excel


Step 5: Add Secondary Horizontal/Vertical Axis to Combined Scatter Plots

  • To add an extra horizontal axis for the second scatter plot, click on the Add Chart Element.
  • Then, select the Axis.
  • Finally, select the Secondary Horizontal.

Steps to Combine Two Scatter Plots in Excel

  • Therefore, a Secondary Horizontal Axis will be added to the graph.

Sample Data

  • Similar to adding the Horizontal Axis, you can add a Vertical Axis Simply select the Secondary Vertical option from the Axis option.
  • As a result, you will get an extra Vertical Axis to the right side of the chart.

Sample Data

  • To change the Horizontal Axis title, double-click the box.
  • Type the name you prefer (e.g., Months).

Sample Data

  • For changing the Vertical Axis title, double-click the box.
  • Write the name you want to show (e.g., Revenue (%)).

Sample Data


Step 6: Insert Chart Title to Combined Scatter Plots

  • To add or change the Chart Title, click on the Add Chart Element.
  • Select the Chart Title.
  • Finally, select an option for where you want to display the Chart Title (e.g., Above Chart).

Sample Data

  • After double-clicking, type the Chart Title in the box (e.g., Revenue (%) Vs Months).

Sample Data

Read More: Use Scatter Chart in Excel to Find Relationships between Two Data Series


Step 7: Display the Data Labels to the Combined Scatter Plots in Excel

  • To display the value, click on the Data Labels.
  • Select how you want to display the Labels (e.g., Below).

Sample Data

  • Finally, you will get the combination of the two Scatter Plots with a great display of visualization.

Sample Data

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


Conclusion

Finally, I hope you now have a better understanding of how to combine two scatter plots in Excel. You should employ all of these strategies while teaching and practicing with your data. Examine the practice book and apply what you’ve learned. We are motivated to continue delivering programs like this because of your valued support.

If you have any questions, please do not hesitate to get in contact with us. Please share your thoughts in the comments section below.

The Exceldemy staff will get back to you as soon as possible.

Stay with us and continue to learn.


Similar Readings

Bhubon Costa

Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo