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

Looking for ways to know how to create a bubble chart in Excel with labels? Usually, we use bubble charts to graphically visualize multiple numerical variables. Here, you will find step-by-step explained ways to create a bubble chart in Excel with labels.


Download Practice Workbook


4 Ways to Create a Bubble Chart in Excel with Labels

Here, we have a dataset containing the data of State, Amount of Product, Sales, and Market Share of a shop. Now, we will use this dataset to show you how to create a bubble chart in Excel with labels.

Ways to Create a Bubble Chart in Excel with Labels


1. Use of Chart Elements to Create a Bubble Chart with Labels

In the first method, we will show you how to create a bubble chart with labels in Excel using Chart Elements. Go through the steps given below to do it on your own dataset.

Steps:

  • First, select Cell range C5:E9.
  • Then, go to the Insert tab >> click on Scatter or Bubble Chart.

Use of Chart Elements to Create a Bubble Chart with Labels

  • After that, select the Bubble chart.

  • Now, you will see a Bubble Chart with the Amount of Product as X-axis, Sales as Y-axis, and Market Share as the size of the Bubble.
  • Next, click on the “+” sign to open Chart Elements.
  • Then, turn on Axis Titles and turn off Gridlines.

Use of Chart Elements to Create a Bubble Chart with Labels

  • Afterward, click on the Chart Title to change it.

  • Now, type Sales Analysis as Chart Title.

Use of Chart Elements to Create a Bubble Chart with Labels

  • After that, click on the Axis Title of the X-axis.

  • Then, type Amount of Product as Axis Title.

Use of Chart Elements to Create a Bubble Chart with Labels

  • Next, click on the Axis Title of Y-axis.

  • Afterward, type Sales as Axis Title.

Use of Chart Elements to Create a Bubble Chart with Labels

  • Now, double-click on the X-axis.

  • After that, the Format Axis toolbar will open.
  • Then, change the Minimum bounds as 10.

Use of Chart Elements to Create a Bubble Chart with Labels

  • Finally, you will get your Bubble Chart with Chart Title and Axis Titles.

  • Then, click on the “+” sign to open Chart Elements.
  • After that, turn on Data Labels >> click on More Options.

Use of Chart Elements to Create a Bubble Chart with Labels

  • Now, the Format Data Labels toolbar will appear.
  • Next, from Label Options select Above as Label Position.
  • Then, select Value From Cells in Label Contains.

  • After that, the Data Label Range box will open.
  • Next, select Cell range B5:B9 in the Select Data Label Range box.
  • Now, press OK.

Use of Chart Elements to Create a Bubble Chart with Labels

  • Again, from the Label Options turn off Y Value.

  • Thus, you will create a Bubble Chart with labels using Chart Elements.

Use of Chart Elements to Create a Bubble Chart with Labels

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


2. Using Chart Design Feature to Create a Bubble Chart with Labels

We can also use Chart Design Feature to create a bubble chart with labels in Excel. Follow the steps given below to do it on your own.

Steps:

  • In the beginning, create a Bubble Chart by following the same steps given in Method1.
  • Then, select the Bubble Chart.
  • After that, go to the Chart Design tab >> click on Add Chart Element.

Using Chart Design Feature to Create a Bubble Chart with Labels

  • Next, click on Data Labels >> select More Data Label Options.

  • Now, the Format Data Labels toolbox will appear.
  • Next, from Label Options select Above as Label Position.
  • Then, select Value From Cells in Label Contains.

Using Chart Design Feature to Create a Bubble Chart with Labels

  • After that, the Data Label Range box will open.
  • Next, select Cell range B5:B9 in the Select Data Label Range box.
  • Now, press OK.

  • Again, from the Label Options turn off Y Value.

Using Chart Design Feature to Create a Bubble Chart with Labels

  • Thus, you will create a Bubble Chart with labels using Chart Design Feature.

Using Chart Design Feature to Create a Bubble Chart with Labels

Read More: How to Create Bubble Chart in Excel with 3 Variables


Similar Readings


3. Manually Changing Labels to Create a Bubble Chart with Labels in Excel

Now, we will show you how to create a bubble chart with labels by Manually Changing Labels. Go through the steps given below to do it on your own dataset.

Steps:

  • First, create a Bubble Chart by following the same steps given in Method1.

Manually Changing Labels to Create a Bubble Chart with Labels

  • Then, click on the “+” sign to open Chart Elements.
  • After that, turn on Data Labels >> select Above.

  • Next, select any Data Label by clicking on it. Here, we selected $120.
  • Then, insert the following formula in the Formula Bar to select Cell B9 as Data Label.
='Manually Changing Labels'!$B$9

Manually Changing Labels to Create a Bubble Chart with Labels

  • Now, press ENTER.

  • Similarly, insert the corresponding Cell value for all the Data Labels.
  • Finally, you will get your desired Bubble Chart with labels by Manually Changing Labels.

Manually Changing Labels to Create a Bubble Chart with Labels

Read More: 3 Suitable Examples of Bubble Chart in Excel


4. Using Text Box Feature to Create a Bubble Chart with Labels in Excel

In the final method, we will use the Text Box feature to create a bubble chart with labels in Excel. You can use the Text Box to add text anywhere in the chart.

Follow the steps given below to do it on your own.

Steps:

  • In the beginning, create a Bubble Chart by following the same steps given in Method1.

Using Text Box Feature to Create a Bubble Chart with Labels in Excel

  • Then, select the Bubble Chart.
  • After that, go to the Insert tab >> click on Text >> select Text Box.

  • After that, insert a Text Box anywhere in the chart and type your desired value. Here, we will add a Text Box and will type New York.

  • Now, press ENTER.

Using Text Box Feature to Create a Bubble Chart with Labels in Excel

  • Similarly, insert the corresponding Cell value for all the Data Labels using Text Box.
  • Finally, you will get your desired Bubble Chart with labels using Text Box Feature.

Using Text Box Feature to Create a Bubble Chart with Labels in Excel

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


Things to Remember

  • To use Chart Elements, make sure you have selected the bubble chart. Otherwise, the Chart Element tab will not appear.
  • Moreover, In the case of using Text Box, select the bubble chart first to move the text with the chart.

Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Conclusion

So, in this article, you will find a step-by-step way to create a bubble chart in Excel with labels. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo