How to Create a 3D Bubble Chart in Excel

A bubble chart is one of the best ways to visualize three different dimensions of data at once without overwhelming your audience. If you're trying to quickly see the relationship between different variables - like which marketing campaigns have a high cost and low return - a bubble chart makes those relationships instantly pop. This tutorial will walk you through exactly how to prepare your data and create a 3D bubble chart in Excel with easy, step-by-step instructions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Is a Bubble Chart?

Think of a bubble chart as a souped-up scatter plot. A standard scatter plot uses two axes (X and Y) to show the relationship between two variables. A bubble chart adds a third dimension into the mix by changing the size of each data point, or "bubble."

Here's how the three data dimensions are typically represented:

• X-Axis (Horizontal): Represents the first numerical value.
• Y-Axis (Vertical): Represents the second numerical value.
• Bubble Size: Represents the third numerical value. A larger bubble signifies a greater value.

For example, a marketing analyst could use a bubble chart to analyze campaign performance:

• X-axis: Cost Per Click (CPC)
• Y-axis: Click-Through Rate (CTR)
• Bubble Size: Total Conversions

Just by looking at the chart, you could instantly spot the campaigns with a low CPC, high CTR, and a large number of conversions (a large bubble in the ideal top-left corner). You'd also see the expensive, low-performing campaigns right away (small bubbles in the bottom-right).

A Quick Note on "3D" Bubble Charts in Excel

Let's clear one thing up right away. When people search for a "3D Bubble Chart," they usually mean one of two things:

1. A chart that visualizes 3 dimensions of data (X position, Y position, and bubble size).
2. A chart that has a 3D visual style (shadows, bevels, etc.) to look more like a sphere than a flat circle.

Excel's bubble chart is perfect for the first goal - that's a bubble chart's entire purpose. It also allows you to easily apply 3D visual effects for the second goal. However, Excel does not have a native chart type that plots bubbles on three different axes (X, Y, and Z). This guide will show you how to accomplish both common goals: creating a chart to represent 3 data dimensions and giving it a polished 3D look.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Preparing Your Data for a Bubble Chart

Proper data setup is the most important step. Without a well-structured table, Excel won't know how to create the chart you want. Your data needs to be arranged in columns, with each row representing a unique data point (or bubble).

You need three numerical columns for the chart, plus an optional column for labels. Here’s the ideal structure:

• Column A: Category Labels (e.g., product names, campaign IDs). These will be the names of your bubbles.
• Column B: X-Axis Values (e.g., Sales Count, Units Sold).
• Column C: Y-Axis Values (e.g., Price Per Unit, Profit Margin).
• Column D: Bubble Size Values (e.g., Total Revenue, Market Share).

Important: The values in your "Bubble Size" column must be numerical and positive numbers. You can't have a bubble with a negative size.

Sample Data Table

Let's use a social media marketing example. We want to see the relationship between advertising spend, clicks, and the resulting website sessions for different campaigns. Here’s what our data looks like:

A: Campaign B: Ad Spend ($) C: Clicks D: Sessions

Using this data, we can create a chart where the X-axis is Ad Spend, the Y-axis is Clicks, and the bubble size represents the number of Sessions generated. This will quickly show us which campaigns are most efficient at turning spend into website traffic.

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

Once your data is organized, creating the chart takes less than a minute. Follow these steps.

Step 1: Select Your Data

Click and drag your mouse to highlight the numerical data you want to plot. In our example, this would be the cells containing Ad Spend, Clicks, and Sessions, including the headers.

Pro Tip: You don't need to select the category labels column (Campaign) just yet. We'll add those labels to the chart later for better readability. Simply select the three columns of number values.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Insert the Bubble Chart

With your data selected, navigate to the Insert tab on Excel's ribbon. In the Charts section, find and click the icon that looks like a scatter plot. It is officially named Insert Scatter (X, Y) or Bubble Chart.

Step 3: Choose Your Chart Type

A dropdown menu will appear with several Scatter and Bubble Chart options. Hover over the Bubble section. You will see two choices:

• Bubble: A standard 2D bubble chart with flat circles.
• 3-D Bubble: A bubble chart with pre-applied shadows and gradients to give it a 3D appearance.

You can choose the "3-D Bubble" option right away or select the standard "Bubble" and add custom 3D formatting later. For this tutorial, let’s start with the standard Bubble option.

Excel will then automatically insert a basic bubble chart into your worksheet. It won't look great yet, but the foundation is there.

Customizing Your Bubble Chart for Clarity and Impact

A default Excel chart is rarely ready for a presentation. The next step is to format it so it clearly tells the story in your data. Here’s how to handle the most important customizations.

1. Add Chart Title and Axis Labels

A chart without labels is meaningless. Click anywhere on your chart to make the Chart Design tab appear in the ribbon.

Go to Chart Design > Add Chart Element. From here, you can add:

• Chart Title: Add a descriptive title above the chart, like "Social Media Campaign Performance."
• Axis Titles: Add a title for both the Primary Horizontal (X-axis) and Primary Vertical (Y-axis). In our example, these would be "Ad Spend ($)" and "Clicks," respectively.

2. Adjust Your Axes for a Better View

Sometimes, Excel's default axes start at zero even when your data points are all clustered much higher. This can result in a lot of empty white space. You can fix this by adjusting the axis bounds:

1. Right-click on the horizontal (X) axis and select Format Axis...
2. In the Format Axis pane that opens on the right, look under Axis Options.
3. Change the Bounds (Minimum and Maximum) to values that are closer to your data range.
4. Repeat the process for the vertical (Y) axis.

This will effectively "zoom in" on your data points, making the chart easier to read.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Manage Bubble Size

You can also control how bubble sizes are represented. Do you want the differences to be subtle or dramatic?

1. Right-click on any of the bubbles in your chart and choose Format Data Series...
2. In the pane on the right, you'll see options to Scale bubble size to. A smaller percentage will make the bubble sizes more similar, while a larger percentage will exaggerate the differences. You can also pick whether the size represents the bubble's area or its width (diameter). Area is generally the more accurate way to represent magnitude visually.

4. Add Data Labels to Identify Bubbles

A group of anonymous bubbles isn't very helpful. You need to know which bubble corresponds to which campaign. To add labels:

1. Click on a bubble to select the data series, then head back to Chart Design > Add Chart Element > Data Labels. You'll see several placement options like Center, Above, Below, etc.
2. Initially, Excel will probably label the bubbles with their Y-axis value (Clicks). That’s not what we want.
3. To fix this, right-click on one of the new data labels and choose Format Data Labels...
4. In the Format Data Labels pane, under Label Options, check the box for Value From Cells.
5. A small window will prompt you to select the data label range. Go back to your data table and highlight the column with your category names (the 'Campaign' column in our example). Click OK.
6. Now, uncheck the 'Y Value' and 'Show Leader Lines' boxes to neaten things up. Your bubbles should now be displaying the campaign names.

Creating the "3D Effect" Look

If you didn't choose the 3-D Bubble option from the start, you can easily apply visual styles to make your flat circles look like spheres. This is purely for aesthetics and doesn't change the data representation.

1. Right-click on any bubble and select Format Data Series...
2. In the pane on the right, click the icon for Effects (it looks like a pentagon).
3. Here, you can experiment with:

By tweaking these settings, you can transform your simple 2D circles into polished, 3D-looking spheres that make your chart look much more professional.

Final Thoughts

Mastering the bubble chart in Excel gives you a powerful tool to tell a multi-dimensional story with your data. By representing three variables in a single, intuitive visualization, you can move beyond simple bar graphs and tables to uncover more meaningful insights about relationships, clusters, and unusual outliers.

While Excel is fantastic for one-off analyses, creating and constantly updating reports with live data from different marketing or sales platforms can turn into a repetitive chore. We built Graphed to automate that entire process. You simply connect your platforms like Google Analytics, Shopify, or Facebook Ads, and then ask for the exact chart you need in plain English. Graphed builds a real-time dashboard for you in seconds, so you're always looking at fresh data and no longer spending your mornings manually wrestling with spreadsheets.