Balloon Chart in Excel: A Step-by-Step Tutorial

To make a balloon chart in Excel for Microsoft 365 on Windows, arrange your data in columns for X values, Y values, and bubble size, select those columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Add labels and axis titles afterward so readers can understand what each bubble represents.

What a balloon chart means in Excel

“Balloon chart” is a common informal name for a bubble chart: a scatter chart that uses the position and size of each circle to show three numeric variables. Excel’s chart gallery calls it a Bubble chart, so that is the option to look for. The horizontal position represents one measure, the vertical position represents a second, and the bubble size represents a third.

For example, a business could plot products by sales growth on the X-axis and profit margin on the Y-axis, with bubble size representing annual sales. A product toward the upper right has both higher growth and a higher margin; a larger bubble indicates more sales. The chart can reveal patterns that a simple two-variable scatter plot would not show.

A bubble chart is not the same as a packed-bubble chart. In a standard Excel bubble chart, points are placed according to numeric X and Y coordinates. A packed-bubble chart instead arranges circles to fit together, without using two numeric axes. Excel’s built-in Bubble chart is the scatter-based type.

Arrange the data before inserting the chart

Give every bubble a row, and place the three required numeric measures in adjacent columns. Use clear headers; they help Excel identify the series and make the chart easier to edit. A fourth column of names is useful for labeling the bubbles, although it is not needed to plot them.

Product	Growth (%)	Margin (%)	Annual sales ($000)
North	8	12	90
South	15	18	180
East	4	22	120
West	11	9	60

In this example, Growth supplies X, Margin supplies Y, and Annual sales supplies bubble size. Product names are the point labels. Keep the units and scale consistent: if one size value is in dollars and another is in thousands of dollars, the bubbles will not represent a meaningful comparison. Avoid blank rows inside the data and make sure the three plotted columns contain numbers rather than numbers stored as text.

Create the bubble chart step by step

Put the headers and records in one continuous range, with X, Y, and size in adjacent columns. Keep the names column next to them if you plan to use it for labels.
Select the three numeric columns, including their headers. For the example above, select the Growth, Margin, and Annual sales columns. You can select the name column too, but check the chart’s series afterward because Excel may interpret the selection differently than intended.
On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose the regular Bubble option for a flat chart. The 3-D Bubble option adds a perspective effect and can make sizes harder to compare.
Check that Excel has assigned the first numeric column to X, the second to Y, and the third to bubble size. If the chart looks wrong, select it and open Chart Design > Select Data to review the series. Edit the series so its X values, Y values, and bubble size range each point to the intended data column, excluding the header cells.
Click the chart title and replace it with a descriptive title. Use Chart Design > Add Chart Element to add axis titles or data labels where they will help explain the display.

If Excel creates several series when you expected one, do not immediately delete the chart. In Chart Design > Select Data, inspect how the data is grouped and edit the series ranges. A single series with several rows is often simplest when each row is one item and all bubbles use the same X, Y, and size measures.

Add product or category names to the bubbles

By default, Excel may show no labels or may label points with values that are less useful than their names. To use the names in the first column, select the chart and choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Value From Cells, choose the cells containing the names, and confirm. Clear other label options, such as X Value or Y Value, if they make the labels crowded.

Labels are especially helpful when the chart has only a few points. With many bubbles, names can overlap or cover the data. You can click a label and move it to a clearer position, remove labels from less important points, or label only the unusual points and explain the rest in a nearby table. Do not rely on color alone to identify categories; labels or a clear legend make the chart more accessible.

For multiple series, a legend can identify each series, but it does not automatically name every bubble. If each point needs a distinct name, use cell-based data labels. A legend describes groups; data labels describe individual points.

Format bubble sizes, axes, and appearance

Bubble sizes can dominate the chart if the largest size value is much greater than the rest. Select a bubble, open Format Data Series, and look under Series Options for the bubble-size scale control. Adjusting the scale changes how large the bubbles appear on the chart; it does not change the underlying size values. Use a moderate adjustment rather than shrinking bubbles until small values disappear.

When explaining the chart, remember that the size variable is represented by circle area, not by a bar height. A bubble with twice the size value should not be casually described as twice the diameter. The visual comparison can also be imprecise when circles overlap or vary greatly in size, so include the size measure in a label, note, or supporting table if exact values matter.

Set useful axis bounds: Click an axis, open Format Axis, and adjust the minimum and maximum when the automatic range leaves too much empty space. Do not crop the scale in a way that exaggerates differences.
Use clear titles and units: Name both axes and state whether values are percentages, units, or currency. A title such as “Growth vs. margin; bubble size = annual sales” explains the three encodings directly.
Keep colors purposeful: Use one color for one series, or use a restrained set of colors to distinguish meaningful groups. Decorative gradients and shadows can compete with the data.
Check contrast and overlap: Add transparency or adjust fills if bubbles hide one another. Keep outlines visible against the chart background, particularly for small circles.

How to read the chart without misreading it

Read a bubble chart in layers. First compare horizontal and vertical position, then compare bubble size, and finally use labels or a legend to identify the observations. A bubble in the upper-right region is high on both plotted measures, but whether that is desirable depends on what the axes mean. High cost and high risk, for instance, may be a warning rather than a success.

Overlapping circles can conceal points, especially when several records have similar X and Y values. A hidden point is not necessarily missing from the data; it may be covered by another bubble. You can reduce overlap with transparency, change the plotting order, or use a table alongside the chart. If many values coincide exactly, a bubble chart may not be the clearest way to show them.

Bubble size is useful for showing relative magnitude, not for making exact comparisons by eye. If readers need precise values, add data labels selectively or provide a companion table. If the size measure includes zero or negative values, review the chart carefully: zero-size points cannot be seen, and negative bubble values can behave differently from positive sizes. Consider whether a bubble chart is suitable for those values before presenting it.

Common problems and how to fix them

The chart has the wrong axes: Open Chart Design > Select Data and check the series’ X and Y ranges. A mistaken range can put labels or the size column on an axis.
Every bubble looks the same: Confirm that Excel is using the intended third numeric column for bubble size, and check whether the values vary enough to be visible. A very narrow spread or a wrong range can make sizes look nearly uniform.
The chart has no useful labels: Add labels using Value From Cells and select the name range. The chart’s default labels may show numbers rather than category names.
Some bubbles seem missing: Check for blank, zero, or nonnumeric size values, and look for points hidden underneath larger bubbles. Also verify that the source range includes every data row.
The bubbles are too large or overlap heavily: Reduce the bubble-size scale, use transparency, or simplify the data shown. Do not remove important records solely to make the chart look tidy without explaining the selection.
The chart is difficult to interpret: Add axis titles, units, a clear title, and a note identifying the size variable. If the chart still requires a long explanation, a different chart type may communicate the result better.

When to use another chart type

Choose a bubble chart when each observation has meaningful X, Y, and size values, and the position of each point matters. It is useful for comparing three numeric measures across a limited number of items, such as products, regions, or projects. It is less suitable when the main purpose is to show exact values, compare many categories, or display a trend over time.

A standard scatter chart is usually clearer when you only need two numeric measures. A bar chart is easier for comparing exact values across named categories. A line chart is generally better for a time sequence where order matters. A table may be best when readers need to look up precise values for many items. Excel’s Bubble chart is not a packed-bubble chart; if your goal is to show category totals as circles without meaningful X and Y coordinates, look for a different visualization or use a clearly labeled alternative.

Frequently Asked Questions

Is a balloon chart the same as a bubble chart in Excel?
Usually, yes. “Balloon chart” is an informal name for a bubble chart. In Excel’s Insert chart menu, choose Bubble.

How many variables can a bubble chart show?
It can encode three numeric variables through horizontal position, vertical position, and bubble size. Color or labels can add categories, but they should not make the chart confusing.

Can I put names inside the bubbles?
Yes. Add data labels, choose Value From Cells in the Format Data Labels pane, and select the cells containing the names. If the bubbles are small or crowded, labels may be easier to read beside them.

Why are all my bubbles the same size?
Check that the third series range points to the intended size values and contains numeric values with enough variation. Also inspect the bubble-size scale and make sure the size values were not accidentally included as X or Y values.

Can I make a bubble chart in Excel for Mac or the web?
Excel for Mac also supports bubble charts, though ribbon labels and chart dialogs can differ by release; use the Insert tab’s chart options and select Bubble. Excel for the web has a more limited editing interface, so some detailed formatting or data-label controls may be easier to access in the desktop app.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.