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.


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.


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

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: Excel Bubble Chart Examples


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. In this case, the C5:E10 range of cells.

📄 Note: Make sure to exclude the column headers when selecting the data source for the chart, otherwise Excel considers horizontal axis values as text and shows incorrect values.

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 Quantity 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


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 option and select More Options.

  • Choose the Label Options, then check the Bubble size and Show Leader Lines.
  • Next, tick the Values From Cells option and in the Data Label Range dialog box select the Items in the B5:B10 range. 
  • Lastly, click on OK.

Read More: How to Create Bubble Chart in Excel


Final Output of 3D Bubble Chart

  • Lastly, I’ve unchecked the Gridlines option to give the chart a cleaner look.
  • Also, select the Data Labels and drag them outside the bubbles for ease of readability.
  • After organizing the chart properly, the 3D Bubble Chart should look like the image shown below.

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 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 titles, and data points are formatted correctly.
  • The size of the bubble will increase as the value rises.

Download Practice Workbook


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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