Bubble Chart in Excel: Create, Format, and Troubleshoot

Charts & pivot tables · Updated November 19, 2026

To make a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three numeric columns for X values, Y values, and bubble sizes, select the range, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Excel plots each row as a bubble: its position shows the first two values, while its size represents the third.

What a bubble chart shows

A bubble chart is a variation of an XY scatter chart. Each point is drawn as a circle, and the chart encodes three quantitative measures at once: horizontal position, vertical position, and bubble size. That makes it useful when you want to compare entities across three measures, such as products by profit and sales volume, with units sold represented by bubble size.

Unlike a column chart, a bubble chart does not use a separate category axis. Both axes are numeric, so a point at X = 20 and Y = 50 is positioned according to those values. Bubble charts work best when the reader can interpret the two axes and the size measure without needing to decode too many additional visual cues. They are not a way to display three unrelated lists of categories.

Prepare the data before inserting the chart

Use one row per item and give each measured value its own column. For example, a small product comparison might use columns named Product, Advertising spend, Orders, and Revenue. Advertising spend can supply the X coordinate, orders the Y coordinate, and revenue the bubble size. Keep the three measures numeric; put text labels in a separate column.

  • Put clear headings in the first row, such as Advertising spend, Orders, and Revenue.
  • Use consistent units within each column. Do not mix dollars and thousands of dollars in one series.
  • Check that the X, Y, and size values belong to the same item on each row.
  • Use positive bubble-size values. Zero or negative values cannot be represented as ordinary positive-sized bubbles and may not appear as expected.
  • Keep labels in a neighboring column so they can be added to the points later.

For instance, a worksheet could have Product in A1:A5, Advertising spend in B1:B5, Orders in C1:C5, and Revenue in D1:D5. Select B1:D5 to create the chart. The selected numeric columns should be in X, Y, size order. Including the text Product column in that selection can make Excel interpret the series differently than intended, so add product names as labels after the chart is created.

Create a bubble chart in Excel

  1. Select the columns containing the headings and three numeric measures. If the columns are not next to each other, insert the chart with the numeric data first and adjust the series afterward.
  2. Choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose 3-D Bubble only if a three-dimensional appearance is essential; perspective can make relative sizes and positions harder to compare.
  3. Excel inserts a chart on the worksheet. Add a chart title that explains the comparison, then give both axes meaningful titles and include the unit where it matters.
  4. Check a few points against the source data. A product with a higher X value should appear farther right, a higher Y value farther up, and a larger size value should generally have a larger bubble.

If the chart is blank or the bubbles do not match the data, use Chart Design > Select Data to inspect the series. Select the series and choose Edit. In the Edit Series dialog, confirm that Series X values point to the intended X range, Series Y values point to the Y range, and Bubble size points to the size range. The ranges should cover the same rows and should normally exclude the heading cells.

Set series and add useful labels

Excel may create one series from the selected three numeric columns, but checking the series settings is worthwhile when the source layout is unusual. A bubble chart series consists of matched X values, Y values, and bubble sizes. If you have multiple groups, each group can be a separate series with its own values and color. Keep the series definitions consistent: do not accidentally use one group’s X values with another group’s Y values.

To show item names beside the bubbles, 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 X Value, Y Value, or Bubble Size if you want names without numeric coordinates. This is usually more informative than labeling every bubble with three numbers, which can clutter the plot.

Labels are especially helpful when the chart has only a few points. With dozens of bubbles, labels may overlap; label only important points or use a separate data table alongside the chart. If your Excel build does not show Value From Cells in the label options, update or use the desktop version of Excel, or add a smaller number of labels manually.

Format bubbles, axes, and the chart area

Good formatting helps readers compare values without mistaking decoration for data. Select a chart element to open its formatting pane, or use the Chart Design and Format tabs when the chart is selected. A descriptive title, axis titles, and a restrained color palette are often more useful than shadows, gradients, or a 3-D effect.

  • Choose axis bounds: Right-click an axis and choose Format Axis to set appropriate minimum and maximum bounds. Do not crop the range in a way that hides meaningful differences or makes the distribution misleading.
  • Clarify units: Put units in axis titles, for example, Revenue (thousands of dollars). A number such as 25 is ambiguous without context.
  • Distinguish groups: Use separate series and clear colors when comparing categories. Include a legend if color carries meaning.
  • Reduce overlap: Make the chart larger, use fewer points, or make bubbles less visually dominant. A crowded chart can conceal smaller values behind larger bubbles.
  • Use color thoughtfully: Do not rely on color alone to convey a critical distinction; add labels or a legend and choose colors with adequate contrast.

Bubble size encodes magnitude, but people compare circle areas less accurately than lengths or positions. Avoid implying exact precision from a quick visual estimate. If a size value is important, show it in a label, tooltip where available, or adjacent data table. Also avoid assigning bubble size to a measure that readers could confuse with the axes—for example, labeling a chart simply “performance” when its axes and bubble sizes represent distinct metrics.

Read and interpret a bubble chart carefully

Consider a chart comparing retail locations. Let the horizontal axis represent monthly visitors, the vertical axis represent average sale value, and bubble size represent monthly sales. A location toward the upper right has both more visitors and a higher average sale value; a large bubble indicates higher monthly sales according to the size field. These are related but not interchangeable conclusions. A large bubble does not, by itself, explain why sales are high.

Look for clusters, outliers, and trade-offs, then check the underlying values before drawing a conclusion. A point far from the others may reflect a genuine exception, a data-entry error, or a different scale. If bubble sizes vary widely, small bubbles can become difficult to see. In that case, consider a second chart or a table to make smaller observations readable rather than removing them silently.

A common misconception is that the bubble’s diameter represents the size value directly. The chart communicates the size measure through the area of the circle, not simply its width. This is why doubling a size value should not be interpreted as doubling the bubble’s diameter. Because people can still misread circles, explain what the size measure represents and include numeric values where precise comparison matters.

Common problems and how to fix them

  • Excel makes a scatter chart instead: Reopen the chart-type menu and select Bubble. A scatter chart has X and Y coordinates but no third size measure.
  • Bubbles appear in the wrong places: Go to Chart Design > Select Data > Edit and verify the X and Y ranges. Excel may have assigned columns in an unintended order.
  • Some bubbles are missing: Check for blank, text, zero, or negative size values, and verify that the bubble-size range includes the intended rows.
  • Only one bubble appears: Inspect the selected data range and series ranges. They may include only one row of values, or the data may not be numeric.
  • Labels show numbers instead of names: Open the Format Data Labels pane and use Value From Cells to select the label range. Clear numeric value options that are not needed.
  • Large circles hide small ones: Reduce overlap by changing the chart’s size, simplifying the data, or using an alternative visualization. Avoid removing points without stating that the chart is filtered.

When the chart is meant to be updated, keep the source data in a well-organized Excel table. Tables can expand as rows are added, which can help keep chart data connected to a growing list. Still, verify the chart ranges after structural changes, especially if you move columns, rename headings, or create multiple series.

When to choose another chart type

A bubble chart is appropriate when all three measures are meaningful and the data points have useful numeric X and Y positions. If the primary task is comparing exact values across a short list of categories, a bar or column chart is usually easier to read. If you only need two numeric measures, a standard scatter chart avoids the extra size encoding. If the third measure is difficult to interpret as bubble area, put it in a separate chart or a table instead.

For geographic locations, a bubble chart does not automatically map points to real-world coordinates or boundaries; it simply plots numeric X and Y values. Use a map chart or a geographic mapping tool when location itself is central and the data structure supports it. For many time-based observations, a line chart may better show change over time, while a bubble chart can become crowded and make sequences hard to follow.

Excel on Mac and Excel for the web

These instructions are for Excel for Microsoft 365 on Windows. Excel for Mac also supports bubble charts, and the basic process is similar: select the numeric data and use the Insert tab’s chart options to choose a bubble chart. Ribbon wording and the location of formatting controls can vary by Mac release. If the options are not where expected, select the chart and look for the chart design and format controls in the ribbon.

Excel for the web supports many common chart tasks, but some formatting and data-label controls may differ from the Windows desktop app or may be unavailable in a given build. For detailed series editing or cell-based data labels, open the workbook in desktop Excel if the web interface does not show the required control. The source-data arrangement—X, Y, and size values in aligned rows—remains the same.

Frequently Asked Questions

How many variables can a bubble chart show?
A standard bubble chart shows three numeric measures: X position, Y position, and bubble size. Labels or color can add context, but they should not be treated as substitutes for clearly defined data.

Can I use text categories for the X-axis?
Bubble charts use numeric X and Y coordinates, not a typical text category axis. If the horizontal dimension is a set of categories such as regions, a bar chart may be clearer; numeric codes for categories can suggest distances that do not really exist.

How do I make bubble sizes show names instead of numbers?
Add data labels, open More Data Label Options, select Value From Cells, and choose the cells containing the names. Clear other value options if you want only the names displayed.

Why are zero or negative bubbles not showing?
A bubble must have a visible, nonnegative area to appear as a circle. Check the size column for zero or negative entries and decide whether those records should be corrected, excluded with an explanation, or represented in another way.

Can a bubble chart have more than one series?
Yes. Each series can have its own aligned X, Y, and size ranges. Use separate series when comparing meaningful groups, and give each one a distinct name and color so the legend remains understandable.

Related

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.