Bubble Chart in Excel

Updated on December 26, 2023
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Bubble Chart in Excel

A bubble chart in Excel is a type of scatter plot. We have data points on the chart in a scatter plot to show the values and comparison. We have bubbles replacing those points in bubble charts to lead the comparison. Like the scatter plots, bubble charts have data comparisons on the horizontal and vertical axis.

For example, suppose you have a scatter chart that indicates the relationship between the production of a product and the costs of the product and want to add the value of the production costs (the third variable). Again, a bubble chart can help you here. 

A Bubble Chart in Excel is used when we want to represent three sets of data graphically. Out of those three data sets used to make the bubble chart, it shows two-axis of the chart in a series of XY coordinates, and a third set shows the data points. With the help of an Excel Bubble Chart, we can offer the relationship between different datasets.

  • This chart is an advanced scatter chart. It is a type of data visualization that tells the story of 3-dimensional data.
  • Every Bubble Chart in Excel consists of three data sets. X-axis coordinate, Y-axis coordinate, and the bubble size data set. So, with the help of the X and Y axis, you can visualize a third data set through the image of bubbles.

How to Create a Bubble Chart in Excel?

We can create a bubble where we want to use multiple bar charts to share results. For example, use an Excel bubble chart to show three types of quantitative data sets.

This chart is straightforward to use. Let us understand the work with some examples.

You can download this Bubble Chart Excel Template here – Bubble Chart Excel Template

Example 1

Below are the steps to create a bubble chart in excel:-

  1. Initially, we must create a dataset and select the data range.


    bubble chart 2

  2. Then, we must go to “Insert” and “Recommended Charts” and select the bubble chart, as shown below.


    bubble chart 1

  3. Next, we must create an Excel Bubble Chart with the below formatting.

  4. Format X-axis


    bubble chart 2

  5. Format Y-axis


    bubble chart 3

  6. Format bubble colors.


    bubble chart 4

  7. Now, we need to add data labels manually. Right-click on bubbles and select add data labels. Select one by one data label and enter the region names manually.


    (In Excel 2013 or more, we can select the range, no need to enter it manually).

    bubble chart 5

    So finally, our chart should look like the one below.

    bubble chart 6

    The additional point is that when we move the cursor on the bubble. It must show the complete information related to that particular bubble.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Interpretation

Example 2

Step 1: Arrange the data and insert a bubble chart from the insert section.

https://www.wallstreetmojo.com/wp-content/uploads/2018/10/Bubble-chart-example-2.jpg

Step 2: We need to follow the steps shown in example 1. The chart should look like the one shown below. (For formatting, we can do our numbers).

Bubble chart example 2-1

Interpretation

  • The chart shows that EFG Co. has been in the market for 35 years, its market value is 1575, and its revenue is 350.
  • MNO Co. has been in the market for 20 years. Its last year’s revenue was 200, and the market value was 988. But IJK has been in the market for ten years and achieved 195 in revenue. But in the graph company, the MNO Co.’s bubble size is immense compared to the company. So since we are showing the market value in bubble size, we see a massive change in the size of the bubble even though the revenue difference is only 5%.

Advantages

  • The Excel bubble chart was better when applied to more than 3-dimension data sets.
  • Eye-catching bubble sizes will attract the reader’s attention.
  • It visually appears better than the table format.

Disadvantages

  • It may be difficult for a first-time user to understand very quickly.
  • Sometimes, we may get confused with the bubble size.
  • If one is a first-time user of this chart, one may need someone’s assistance to understand the visualization.
  • In Excel 2010 and earlier versions adding data labels for large bubble graphs is tedious. (In 2013 and later versions, this limitation is not there).
  • The overlapping of bubbles is the biggest problem if two or more data points have similar X and Y values. The bubble may overlap, or we may hide one behind another.

Things to Consider When Creating a Bubble Chart in Excel

  • We must instantly arrange the data to apply the bubble chart in Excel.
  • Always decide which data set to show as a bubble. First, one must identify the targeted audience for this to happen.
  • Always format the dataset’s X and Y-axis to a minimum extent.
  • We must avoid fancy colors that may look ugly at times.
  • We must play with the chart’s background color to make it look nice and professional.

Bubble Chart in Excel Video

 

Recommended Articles

This article is a guide to Bubble Chart in Excel. We discuss its uses, how to create a bubble chart in Excel, examples, and downloadable Excel templates. You may also look at these useful functions in Excel: –