Create Bubble Chart in Excel with Multiple Series (with Easy Steps)

This article shows how to insert a Bubble Chart with multiple series in Excel. In many cases, we might need to handle 3 variables in a single dataset. In this type of situation, Bubble Chart comes with a great advantage. Here, we will take you to step by step guide on how to insert a Bubble Chart in Excel with multiple series.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.


What Is a Bubble Chart with Multiple Series in Excel?

The Bubble Chart is a tool for three-dimensional data visualization. With the Bubble Chart, you may plot the third variable in addition to the standard two variables (x and y). The first two variables are represented by coordinates, whereas the third is by the bubble’s size.

For example,  you may have represented the interrelation between the week number and corresponding sales quantity in a scatter plot. Now, you want to add the consecutive profit percentage to it. Then, a Bubble Chart can help you get there.

To understand the multiple series phenomena easily, go over the example below.

In the example above, if you have the sales report of 2 states and want to plot them in a single chart as different streaks. Then, it’s called a multiple series Bubble Chart.


Bubble Chart with Single Series:

Bubble Chart in Excel with Multiple Series


Bubble Chart with Multiple Series:

Bubble Chart in Excel with Multiple Series


Benefits and Drawbacks of Multiple Series Bubble Chart in Excel

Before proceeding on how to plot a Bubble Chart with multiple series, you may want to know the pros and cons of using it.


Benefits:

  • It enables you to expand the data set by a third dimension.
  • Hence, you can communicate a lot of information simultaneously using it.
  • Besides, lucrative bubble sizes draw the attention of readers easily.
  • In terms of appearance, it beats the tabular format.

Drawbacks:

  • A novice user could find it challenging to comprehend everything right away.
  • A graph that has too many bubbles may become unreadable.
  • Occasionally, we could be perplexed by the size of the bubbles.
  • Overlapping bubbles could generate a barrier.

Read More: Excel Bubble Chart Size Based on Value (2 Suitable Examples)


7 Steps to Create a Bubble Chart in Excel with Multiple Series

Suppose, we have a Region-wise Sales Report of 2 states: Texas and Florida. This report includes the Sales Quantity and Profit percentages for corresponding Weeks.

Bubble Chart in Excel with Multiple Series

Now, we want to plot a Bubble Chart with multiple series from this dataset. At this point, follow the steps below to do so.


Step 1: Insert Bubble Chart with Multiple Series in Excel

In our first step, we’ll insert the Bubble Chart into our worksheet.

  • Firstly, select any cell.
  • Secondly, go to the Insert tab.
  • Thirdly, select Insert Scatter (X, Y) or Bubble Chart > Bubble.

Bubble Chart in Excel with Multiple Series Inserting It

It inserts a Bubble Chart in our worksheet.

Bubble Chart in Excel with Multiple Series Inserting It

The chart looks like this because we haven’t selected any relevant data. Now we will input significant data into this chart.

  • Firstly, right-click anywhere on the chart.
  • Then, select the Select Data option.

Bubble Chart in Excel with Multiple Series Inserting It

  • At this moment, the Select Data Source dialog box opens.
  • Now, click on Series 1.
  • After that, select the Remove button.
  • Similarly, remove Series 2.
  • Finally, click OK.

Bubble Chart in Excel with Multiple Series Inserting It

Therefore, our chart is entirely blank now. As we deleted all data from it.

Bubble Chart in Excel with Multiple Series Inserting It


Step 2: Add Multiple Series to the Chart

In our second step, we’ve to add our series manually.

  • Again, open the Select Data Source dialog box just like before.
  • Now, click on Add in the Legend Entries (Series) section.

Bubble Chart in Excel with Multiple Series Adding Multiple Series

  • Eventually, it opens the Edit Series dialog box.
  • Then, select the relevant cells for the text boxes as in the image below.
  • After that, click OK.

Bubble Chart in Excel with Multiple Series Adding Multiple Series

  • Thus, we added Series 1 to our Bubble Chart. We can also notice the Weeks are in the Horizontal (Category) Axis Labels.
  • Again, click on the Add button to add our 2nd series.

Bubble Chart in Excel with Multiple Series Adding Multiple Series

  • Similarly, add the 2nd series in the Legend Entries (Series) section.

Bubble Chart in Excel with Multiple Series Adding Multiple Series

  • Hereafter, we also added Series 2.
  • Finally, click on the OK button.

Bubble Chart in Excel with Multiple Series Adding Multiple Series

At this point, the Bubble Chart looks like the one below.

Bubble Chart in Excel with Multiple Series Adding Multiple Series


Step 3: Edit Multiple Series Labels

In this step, we’ll define the multiple series labels. Here, we have to edit the series labels and give them suitable names.

  • Again, open the Select Data Source dialog box like before.
  • Then, select Series 1 from the list.
  • Later, click on the Edit button.

Bubble Chart in Excel with Multiple Series Editing Labels

  • As a result, it opens the Edit Series dialog box again.
  • Next, click on the Series Name box.
  • Then, select cell B4 as a cell reference.
  • Now, click OK.

Bubble Chart in Excel with Multiple Series Editing Labels

  • Similarly, edit the Series Name of Series 2 also.

Bubble Chart in Excel with Multiple Series Editing Labels

  • Through our previous actions, we successfully changed the series names. We changed them in Legend Entries (Series) from Series 1 and Series 2 to Texas and Florida, the name of the two states.
  • Finally, click on OK.

Bubble Chart in Excel with Multiple Series Editing Labels

At this moment, our Bar Chart just looks like the one below.

Bubble Chart in Excel with Multiple Series Editing Labels

The series names also get changed in the chart above. Before, they were Series 1 and Series 2.


Step 4: Add Legend to the Bubble Chart

Additionally, if the chart Legend isn’t visible already, we’ll add it to the Bubble Chart.

  • At first, go to the Chart Design tab.
  • Secondly, select Add Chart Element from the ribbon.
  • From the drop-down list, select Legend > Top.

Bubble Chart in Excel with Multiple Series Adding Legends

As a result, the chart Legend will get visible at top of the chart just below the Chart Title. We can notice that in the image above.


Step 5: Add Axis Title to Bubble Chart with Multiple Series in Excel

Axis Titles in a chart are also important. Because Axis Titles link specific data categories to the visual information. In this step, we’ll add this title to the chart.

  • Firstly, go to the Chart Design tab.
  • Secondly, select Add Chart Element from the ribbon.
  • From the drop-down list, select Axis Titles > Primary Horizontal.

Adding Axis Titles

We can see the Axis Title of the X-axis is visible in the image above.

  • Similarly, add the Primary Vertical type Axis Title in the chart also.

Adding Axis Titles

  • After that, click on those titles.
  • Then, edit them and give suitable titles related to the dataset.

Adding Axis Titles


Step 6: Add Data Labels

As they provide information on a data series or its individual data points, Data Labels help a chart’s viewers better understand its contents. In this step of our method, we’ll add the Data Labels to the chart.

  • Firstly, go to the Chart Design tab.
  • Secondly, select Add Chart Element from the ribbon.
  • From the drop-down list, select Data Labels > More Data Label Options.

Adding Data Labels

  • At this point, it opens the Format Data Label task pane.
  • Firstly, click on the Label Options icon.
  • Secondly, expand the Label options menu.
  • Then, check the boxes of Y Value and Bubble Size.

Adding Data Labels

Now, the Bubble Chart looks like the one below.

Adding Data Labels

Read More: How to Create a Bubble Chart in Excel with Labels (4 Easy Ways)


Step 7: Add Chart Title

Chart Titles give us a brief summary of the displayed information. In this section, we’ll add it to our chart.

  • Firstly, go to the Chart Design tab.
  • Secondly, select Add Chart Element from the ribbon.
  • From the drop-down list, select Chart Title > Above Chart.

Adding Title of the Graph

  • Now, edit the title and give a suitable title according to our relevant dataset.

Adding Title of the Graph

Explanation of Final Output

If we concentrate on the sales of Florida from the chart. Though we can notice that the Sales Quantity of Week 2 is highest, which is represented by the 2nd orange circle from the left, the Profit percentage of it is lower than Week 3. We can easily understand it by seeing the size of the circle for Week 2 and Week 3. Obviously, the circle of Week 3 is bigger. As a result, we can clearly understand from the chart that though Week 2 has more Sales Quantity, Week 3 has more Profit percentage.


💡Things to Remember

  • To use the Bubble Chart, we must arrange the data immediately.
  • We must stay away from ornate colors that occasionally appear unattractive.
  • We can alter the backdrop color of the chart to give it a good, polished appearance.
  • We shouldn’t add too many data points to a Bubble Chart as it gets messy then.

Conclusion

Thank you for reading this article, we hope this was helpful. Please let us know in the comment section if you have any queries or suggestions. Please visit our website ExcelDemy to explore more.


Related Articles

Shahriar

Shahriar

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc in Engineering from the Bangladesh University of Engineering & Technology. I am a Naval Architecture and Marine Engineering graduate with a great interest in research and development. I love reading books & traveling. Always try to gather knowledge from various sources and implement them effectively in my work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo