How to Compare Three Variables with a Bubble Chart in Excel

What you will build

In this example, each product has three variables:

• Revenue controls the horizontal position.
• Margin % controls the vertical position.
• Customers controls the bubble size.

The exact sample data stays consistent throughout the guide:

Bubble charts are useful when the reader needs to see relationships, not just compare one list of values. If you later want to turn a chart into a report control, you can continue with this guide to creating a dynamic chart with a drop-down list. For a chart that ranks contribution across categories, see the Excel Pareto chart tutorial.

Step 1: Prepare the source data

Start with a clean rectangular table. Put one product or category on each row, and put each variable in its own column. Do not combine revenue, margin, and customers into one text field; Excel needs numeric columns to position and size the bubbles.

1. Enter the headers Product, Revenue, Margin %, and Customers.
2. Enter the three product rows exactly as shown in the table above.
3. Format Revenue and Customers as numbers with thousands separators.
4. Format Margin % as a percentage.
5. Check that every product row has one value in all three numeric columns.

Step 2: Insert a Bubble chart

Select the source range, including the headers, then insert the chart from Excel’s chart menu.

1. Select the full range from Product through Customers.
2. Open the Insert tab.
3. Choose Insert Scatter (X, Y) or Bubble Chart.
4. Select Bubble, not a plain Scatter chart.

Excel may place the first chart in a default position and may not map the columns correctly on the first attempt. That is normal. The next step is where you make the variable mapping explicit.

Step 3: Map revenue, margin, and customers to the chart

Now tell Excel which column controls each chart dimension. This is the step that turns an ambiguous chart into a useful three-variable view.

1. Right-click the chart and choose Select Data.
2. Select the series and choose Edit.
3. Set the Series X values to the Revenue cells, excluding the header.
4. Set the Series Y values to the Margin % cells, excluding the header.
5. Set the Bubble size values to the Customers cells, excluding the header.
6. Use the Product labels for the series name or data labels so each point can be identified later.

For the sample table, the mapping is equivalent to:

• X values: =Sheet1!$B$2:$B$4
• Y values: =Sheet1!$C$2:$C$4
• Bubble sizes: =Sheet1!$D$2:$D$4

Your worksheet name may differ from Sheet1. The important part is the column role: Revenue, Margin %, and Customers must each point to the correct three-row range.

Step 4: Format the axes and bubble scale

Formatting is not decoration here. It prevents the chart from exaggerating small differences or hiding the relationship between the products.

1. Click the horizontal axis and choose Format Axis.
2. Set the horizontal minimum to 0 and maximum to 300,000 for this example.
3. Click the vertical axis and set the minimum to 0% and maximum to 40%.
4. Choose sensible major units so the labels are easy to read.
5. Right-click the bubble series, choose Format Data Series, and adjust the bubble scale if one bubble overwhelms the others.

These bounds make the sample easier to read because all three products sit comfortably inside the plotting area. In your workbook, choose bounds that fit the actual range without clipping a point or creating so much empty space that the differences disappear.

If you are preparing a visual report with multiple chart types, the progress bar chart tutorial is a useful next example of choosing a scale that communicates the result clearly.

Step 5: Add labels and a bubble-size legend

A reader should not have to guess which bubble represents which product. Add labels and explain what size means.

1. Right-click the bubble series.
2. Choose Add Data Labels.
3. Right-click one of the new labels and choose Format Data Labels.
4. Keep the Product name selected, and remove values that add clutter unless the audience needs them.
5. Add or retain a small legend explaining that bubble size represents Customers.
6. Move labels slightly when they overlap a bubble or another label.

For this example, Product B should appear near 180,000 revenue and 28% margin, with the largest bubble because it has 2,800 customers. Product C should be farthest right because it has the highest revenue, while Product A should be the smallest bubble because it has the fewest customers.

Step 6: Verify the chart before you share it

Do not stop when the chart looks attractive. Compare it back to the table. A chart can render without an error even when the wrong ranges or units were selected.

1. Verify position: Revenue is on the horizontal axis and Margin % is on the vertical axis.
2. Verify size: Product B is the largest bubble because 2,800 is the largest customer count.
3. Verify labels: Product A, Product B, and Product C match the source rows.
4. Verify the ranges: each X, Y, and bubble-size range contains exactly three product values.
5. Verify the units: the vertical axis is percentage-formatted and the horizontal axis is numeric.
6. Verify the story: Product C is farthest right, Product B is highest, and Product A is smallest.

Common mistakes and how to fix them

Frequently asked questions

Can a Bubble chart compare more than three variables?

One bubble series naturally communicates two position variables plus one size variable. You can add color or labels as another cue, but too many encodings reduce readability. If you need more dimensions, split the view or use a small-multiple design.

Why does Excel call this a Scatter or Bubble chart?

Bubble charts use the same X/Y coordinate model as scatter charts, then add a third numeric dimension through bubble size. That is why both chart types appear in the same Insert menu.

Should I use percentages as the Y values?

Yes, when the percentage is the business measure you want to compare. Format the source cells and vertical axis consistently so 12%, 18%, and 28% are not displayed as confusing decimal values.

Why is my largest bubble not the highest point?

Bubble position and bubble size represent different columns. A product can have the most customers without having the highest margin or revenue. Check each mapping separately.

How do I make the chart refresh when the data changes?

Build the source range as an Excel Table before inserting the chart, or update the chart’s ranges when the data grows. A Table is usually the easier starting point for a repeatable report.

Final checklist

• Each variable has its own column.
• Revenue maps to X, Margin % maps to Y, and Customers maps to bubble size.
• Axis bounds and number formats match the data.
• Every bubble has a readable label.
• The legend explains bubble size.
• The chart has been reconciled against the source table.