How to Create a 3D Bubble Chart in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

While working with Microsoft Excel, when we want to display demographic or regional capacity information, the bubble chart is quite helpful. A bubble chart is a tool for three-dimensional data visualization. In this article, we will demonstrate the procedures to create a 3D bubble chart in Excel.


Download Practice Workbook

You can download the workbook and practice with them.


What Is Bubble Chart?

Excel’s Bubble Chart is a fairly straightforward and user-friendly tool. With the Bubble Chart, we may plot three variables in addition to the two X and Y that are typically plotted in a regular chart. The word “bubble” implies that we use bubbles to depict the data points in the chart. A bubble will ultimately be larger and appear at the top of the chart for data points with higher values; in contrast, a smaller bubble will appear for data points with lower values towards the bottom Y-axis.


Step-by-Step Procedures to Create a 3D Bubble Chart in Excel

We already know that the bubble chart uses value instead of using the category axis. To visualize three-dimensional datasets we use the 3D bubble chart. Let’s follow the procedures to create a 3D bubble chart in Excel.


Step 1: Create Data for Bubble Chart

First, we need to create a dataset. As we know, the datasets are the continuous cell range holding data for analysis.

  • To begin with, we insert some company items in column B.
  • Then, we put the Quantity of each item in column C.
  • Further, the Cost in column D and that cost is for those items.
  • Finally, in column E, we insert the total Sales of each item.

Read More: 3 Suitable Examples of Bubble Chart in Excel


Step 2: Insert Chart

A chart can provide a sharper view of a set of data values. And, to create a 3D bubble chart we must insert the chart into our spreadsheet.

  • Firstly, we select the Quantity, Cost, and Sales columns.

Step-by-Step Procedures to Create a 3D Bubble Chart in Excel

  • Secondly, go to the Insert tab from the ribbon.
  • Thirdly, click on Insert Scatter (X, Y) or Bubble Chart drop-down menu under the Charts group.
  • Consequently, choose the 3D Bubble from the Bubble option.

Step-by-Step Procedures to Create a 3D Bubble Chart in Excel

  • Thus, you can see the Cost VS Sales 3D bubble chart in your spreadsheet.

Step-by-Step Procedures to Create a 3D Bubble Chart in Excel

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


Similar Readings


Step 3: Organize 3D Bubble Chart

Organizing the chart will make the chart easier to understand.

  • First of all, right-click on any bubble on the bubble chart and a context menu will pop up.
  • Then, select the Format Data Series from there.

  • This will display the Format Data Series window on the right side of the workbook.
  • Subsequently, go to the Series Options.
  • Further, click on Fill from the Series Options.
  •  Checkmark the Vary colors by points. This will change all the bubble colors automatically.

  • Alternatively, you can change the color or add colors to the bubbles manually.
  • For this, select the bubble in which you want to put color.
  • Then, click on the Colors drop-down menu. And, choose your desired color.

  • Now, suppose, we want to see the cost of each bubble. For this, click on the Chart Elements which is the plus (+) sign, and the sign will be visible after clicking on the chart.
  • After that, checkmark the Data Labels.

Read More: How to Color Excel Bubble Chart Based on Value (2 Easy Methods)


Final Output of 3D Bubble Chart

This is the final 3D Bubble Chart after organizing the chart properly.

How to Create a 3D Bubble Chart in Excel


Things to Keep in Mind

  • Consistently structure your X and Y axes to the lowest quality of the data for the simplicity of use.
  • Select the Bubble’s colors in accordance with the data. Selecting colors that are very vivid or garish might ruin the chart’s overall aesthetic.
  • The chart will be simple to understand if the data labels, axis title, and data points are formatted correctly.
  • The size of the bubble will increase as the value rises.

Conclusion

The above procedures will assist you to Create a 3D Bubble Chart in Excel. Hope this will help you! Please let us know in the comment section if you have any questions, suggestions, or feedback. Or you can glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Team Leader. I'm a graduate in BSc in Computer Science and Engineering from United International University. I love working with computers and solving problems. I’ve always been interested in research and development. Here I post articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo