Create a Balloon Chart in Excel: A Practical Guide

To create a balloon chart in Excel, 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. Excel calls this a bubble chart; it uses the first two measures to position each balloon and the third to set its size.

What a balloon chart shows

“Balloon chart” is a common informal name for a bubble chart. Excel does not list a separate chart type called a balloon chart. A standard bubble chart places each observation at a point on an X-Y coordinate plane, then adds a circle whose size represents another numeric value. This lets you compare three measures in one view.

For example, a sales team might plot each product’s profit margin on the horizontal axis and annual revenue on the vertical axis, with bubble size representing units sold. A large bubble high and to the right would indicate a product with many units sold, strong revenue, and a relatively high margin. The chart can help reveal clusters, outliers, and relationships, but it does not prove that one measure causes another.

Excel’s regular bubble chart is not the same as a packed-bubble diagram, where circles of different sizes are arranged tightly together without meaningful X and Y coordinates. In an Excel bubble chart, the horizontal and vertical positions carry data meaning. If you want circles packed like a treemap or infographic, you will need a different charting method or a manually arranged design.

Prepare the source data

Each bubble needs three numeric values: an X coordinate, a Y coordinate, and a size value. Put one observation per row and use a clear header for each column. A fourth column can hold names for labels.

Product: a text name such as “Northstar” or “Model B.”
Margin: the numeric X value, such as 12.5%.
Revenue: the numeric Y value, such as 480000.
Units sold: the numeric value used to size the bubble, such as 3200.

Keep the three plotted measures in separate columns, with their headers in the first row. Select the X, Y, and size columns for the chart; the product-name column can be used later for labels. Make sure Excel recognizes the measures as numbers rather than text. Imported numbers stored as text, blank cells, and inconsistent units can lead to missing or misleading points.

Use comparable, meaningful size values. A size column should represent a quantity for which larger values genuinely mean a larger bubble, such as units, population, or expenditure. Negative values are not suitable bubble sizes, and a zero-sized value may not be visible. If your source includes negative figures, consider whether another measure is appropriate for size or choose a chart that can show signed values more clearly.

Create the bubble chart in Excel

These steps apply to Excel for Microsoft 365 on Windows. For a straightforward chart, keep the X, Y, and size columns next to each other, including their header row.

Select the cells containing the three numeric columns and their headers. Do not include the text-name column unless you want Excel to interpret it as part of the plotted data.
Open the Insert tab. In the Charts group, choose Insert Scatter (X, Y) or Bubble Chart.
Choose Bubble for the standard chart. Choose 3-D Bubble only if a perspective-style display is genuinely useful; the extra visual depth can make comparisons harder.
Check that Excel has assigned the first numeric column to X, the second to Y, and the third to bubble size. Add a descriptive chart title and axis titles using Chart Design > Add Chart Element.

If Excel assigns the data incorrectly, click the chart and choose Chart Design > Select Data. In the Select Data Source dialog, add or edit a series and specify the ranges for Series X values, Series Y values, and Bubble size. The series name can refer to a header cell. Check that each range covers the same rows and does not include the header as a data point.

On Excel for Mac, the same basic chart type is available, though the ribbon layout and chart dialogs can differ by version. Look under Insert for the chart options and select a bubble chart. Excel for the web may present fewer chart-formatting controls than the desktop app, so use desktop Excel if you cannot find a needed series or label option.

Add names to the balloons

Without labels, a chart with several bubbles may show the pattern but not identify individual products or locations. You can add labels that show the underlying X value, Y value, or bubble size, but names are usually more useful when the points represent categories.

In Microsoft 365 for Windows, select the chart, then choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, look for Value From Cells under Label Options, select the cells containing the names, and confirm the range. Clear other label components, such as X Value or Y Value, if they make the labels too crowded. The exact controls can vary across Excel versions; if Value From Cells is unavailable, label the points manually or use a data-label method supported by your version.

Labels should be short enough to read and distinct enough to identify the observations. If many names overlap, do not shrink the text until it becomes unreadable. Instead, label only the most important points, increase the chart’s size, or divide the data into a few focused charts.

Format the chart for clear comparisons

Start by adding axis titles that state both the measure and its unit. “Revenue ($)” is more informative than “Y axis,” and “Profit margin (%)” makes clear whether values are percentages or decimal fractions. If the measures use very different ranges, check the axis bounds and tick marks so the data are not visually compressed or exaggerated.

Bubble size needs particular care. A circle’s visible area can be difficult to compare precisely, especially when the values are close. Excel provides bubble-size scaling in the series formatting options; select a bubble, open Format Data Series, and inspect Series Options for the size scale. Adjust it only to improve visibility, not to imply that the underlying values changed. Keep the scale consistent when comparing charts side by side.

Use a restrained color palette. One color is often enough when all bubbles belong to one group. If color represents a category, explain that mapping with a legend and use colors that remain distinguishable. Avoid using color, size, and labels to encode too many different ideas at once. A chart with a clear title, readable axes, and a small number of meaningful encodings is easier to interpret than one decorated with unnecessary effects.

Common problems and how to fix them

The chart has one bubble or the wrong number of points: Open Chart Design > Select Data and inspect the series ranges. Each X, Y, and size range should contain the matching observations.
Bubbles are missing: Check for blank, zero, negative, or text-formatted size values. Also confirm that the chart’s series includes the intended rows.
All bubbles look almost the same: The size values may be similar, or the chart’s size scale may need adjustment. Verify the source values before changing formatting.
Points appear in the wrong places: Confirm that X and Y have not been reversed and that the data use consistent units. For instance, mixing whole-number percentages with decimal percentages distorts the axis.
Labels overlap: Reduce the number of labels, shorten category names, enlarge the chart, or show labels only for selected points.
The chart looks misleading: Review axis bounds and bubble sizes. A truncated axis can make small differences seem large, while oversized bubbles can obscure nearby observations.

One easy-to-miss issue is changing the source data without noticing that the plotted ranges do not include new rows. Converting the source into an Excel table can make it easier to manage expanding data, but verify that the chart series updates as intended after adding observations.

Bubble charts versus other Excel charts

A bubble chart is useful when each observation has two meaningful coordinates and a third numeric measure. It is less suitable when readers need to compare exact values quickly. People generally find precise lengths or positions easier to compare than circle areas, so a bar chart may be clearer for ranking values such as sales by product.

A scatter chart is the better choice when you want to show the relationship between two numeric measures and do not need a third size variable. A line chart is often more appropriate when the horizontal axis is time and the order of observations matters. A packed-bubble display is better suited to showing relative size among categories without implying X-Y relationships, but Excel does not provide that as a standard bubble chart type.

Do not add a third measure as bubble size simply because the option is available. If the added dimension makes the chart harder to understand, use two separate charts or a table with conditional formatting instead. The best choice depends on the question: relationship, trend, ranking, or relative magnitude.

Frequently Asked Questions

Does Excel have a balloon chart?
Excel’s chart type is called a bubble chart, not a balloon chart. It is commonly described as a balloon chart because its data points appear as circles of different sizes.

What data do I need for a balloon chart?
You need a numeric X value, a numeric Y value, and a numeric bubble-size value for every observation. A separate text column is optional and can provide category names for labels.

Can I use text labels instead of numbers for the axes?
A standard Excel bubble chart uses numeric X and Y coordinates. You can add text labels to identify points, but it is not a substitute for a category axis. For categories without meaningful numeric coordinates, consider a different chart type.

How do I make the bubbles show names?
Add data labels and, where your Excel version offers it, use the Value From Cells option in the Format Data Labels pane to select the name cells. If that option is not present, use the labeling controls available in your version or add labels manually.

Why are some bubbles invisible?
Check whether their size values are zero, blank, negative, or stored as text. A very small positive value may also be difficult to see at the chosen size scale.

Can Excel create a packed-bubble chart?
Not as a standard built-in bubble chart. Excel’s bubble chart positions points according to X and Y values, while a packed-bubble chart arranges circles without using those coordinates as axes. Choose another charting tool or create a custom visual if a packed layout is essential.

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.