How to Add Multiple Series Labels in Scatter Plot in Excel

In many cases, we might need to create a scatter plot with multiple series of data. The next thing we need to do after creating such a type of scatter plot is add labels to make the chart more understandable. In Microsoft Excel, we can add multiple series labels by following some easy steps. This article demonstrates how to add multiple series labels in a scatter plot in Excel.


Download Practice Workbook

You can download the practice workbook from the link below.


Why Do We Need to Add Multiple Series Labels in Scatter Plots?

A Scatter Plot is a special kind of graph in Excel that helps us understand the relationship between two or more than two variables in Excel. Now, to show relationships between more than two variables, we use multiple series in Excel. In this case, if we don’t add labels to these series, any other person viewing the chart might find it difficult to understand. So, to make your chart or graph more readable or understandable, you can add multiple series labels in the Scatter Plot.


5 Steps to Add Multiple Series Labels in Scatter Plot in Excel

Adding Multiple Series Labels in a Scatter Plot includes some easy steps. In the following stages of this article, I will show you how to add Multiple Series Labels in a Scatter Plot in Excel with an easy example.

Let’s assume you are the owner of a laptop shop. In your shop, you have two models of laptops that you sell. One is a Macbook Air M1 and the other one is a Dell XPS 13. Now, you want to plot the sales quantity of these models in different weeks in a Scatter Plot. Also, you want to add Multiple Series Labels in the chart to make it more understandable for future reference. At this point, follow the steps below to do so.

Add Multiple Series Labels in Scatter Plot in Excel


⭐ Step 01: Create a Single Series Scatter Plot from Dataset

In the first step, we will create a Scatter Plot for the laptop model Macbook Air M1.

  • First, select the range B6:C12.

In this case, B6 is the first cell of the column Week and cell C12 is the first cell of the column Sales Quantity for the model Macbook Air M1.

  • Then, go to the Insert tab.
  • Next, from Charts select Insert Scatter (X,Y) or Bubble Chart.
  • Now, select the Scatter chart.

⭐ Step 01: Create a Single Series Scatter Plot from Dataset


⭐ Step 02: Add Multiple Series to the Scatter Plot

Consequently, in the second step, we will add the data series for the model Dell XPS 13 to the Scatter Chart.

  • First, select the range  E6:F12.

In this case, E6 is the first cell of the column Week and cell F12 is the first cell of the column Sales Quantity for the model Dell XPS 13.

  • Then, copy the range.
  • Next, click on the chart.
  • After that, from just below the top left of your window, click on Paste.
  • Now, select Paste Special.

Add Multiple Series to the Scatter Plot

  • At this point, a new box will appear named as Paste Special.
  • Subsequently, check the circles for New Series from Add cells as and Columns from Values (Y) in.
  • Then, click OK.

Add Multiple Series to the Scatter Plot

Note: Similarly, you can add more data series if you wish using this step.

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


Similar Readings


⭐ Step 03: Edit Multiple Series Labels in Scatter Plot in Excel

Eventually, in this step, we will edit the series name for each of the data series. Generally, Excel assigns Series 1, Series 2, etc. names to different data series.

  • First, Right-Click on the chart.
  • Next, click on Select Data.

Edit Multiple Series Labels in Scatter Plot in Excel

  • At this point, from Legend Entries (Series) select Series1 and click on Edit.

Edit Multiple Series Labels in Scatter Plot in Excel

  • Then, from the Series name, click on the Select Range button.

Edit Multiple Series Labels in Scatter Plot in Excel

  • Now, select cell B4 which indicates the model Macbook Air M1.
  • Next, press ENTER.

Edit Multiple Series Labels in Scatter Plot in Excel

  • After that, click on OK.

Edit Name

  • Similarly, change the Series Name of Series2 to Dell XPS 13.
  • Consequently, click on OK.

Edit Multiple Series Labels in Scatter Plot in Excel

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


⭐ Step 04: Add Legend to the Scatter Plot

In this step, we will add a legend to the chart, which will work as a label for different data series.

  • First, select the chart.
  • Then, click on the Chart Elements button.
  • After that, check the box beside the Legend and then go to the Legend Options.
  • Now, from those options, select according to your preference. In this case, we choose Top.

Add Legend


⭐Step 05: Add Data Labels to Multiple Series in Scatter Plot

Now, in this step, we will add labels to each of the data points.

  • First, select the chart.
  • Next, click on the Chart Elements button.
  • Then, check the Data Labels box.
  • After that, from the Data Labels Options, select the position of the labels. In this case, we choose Right.

Add Data Labels to Multiple Series in Scatter Plot 

  • At this point, if you want other data in your labels, go to More Options or simply double-click on the labels.

Go to More Options

  • Now, from the Label Options, go to Label Contains and choose the data you want to add to your label.

Format

Finally, after following all the steps above, you will get your output as shown in the below screenshot.

excel scatter plot multiple series labels

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


Conclusion

In this article, I showed five easy steps to add labels to multiple series in a scatter plot in Microsoft Excel. Moreover, you can use these steps for as many data series as you want.

Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo