How to Build a Bubble Chart in Excel: A Step-by-Step Guide

Charts & pivot tables · Updated November 20, 2026

To build a bubble chart in Excel, arrange each observation’s X value, Y value, and bubble-size value in separate numeric columns, select the data, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. The chart plots the first two measures as coordinates and represents the third with bubble size. Before you start, decide what each measure means and make sure the size values are positive numbers.

What You’ll Need

  • Excel for Microsoft 365 on Windows. Excel for Mac has similar chart tools, though ribbon placement and some pane labels can differ. In Excel for the web, use the available Insert chart options; switch to the desktop app if a formatting option described here is missing.
  • A small, tidy data table with one row per item and three numeric measures: an X value, a Y value, and a bubble size.
  • Optional item names, such as product names or countries, if you want readable labels next to the bubbles.

Step-by-Step

  1. Plan what the chart will show. Choose two measures that make sense as horizontal and vertical positions, then choose a third measure that is meaningful when represented by bubble size. For example, a product comparison might use customer satisfaction for X, growth rate for Y, and annual sales for bubble size. The bubble chart is most useful when viewers need to compare all three measures at once. Write down the units and the intended meaning of each measure before arranging the data; this makes it easier to title and explain the finished chart.
  2. Arrange the data in columns. Put descriptive headers in row 1 and one observation per row below them. For example, use columns A through D for Product, Satisfaction (X), Growth (Y), and Sales (size). Put the numeric X values in B, numeric Y values in C, and positive numeric size values in D. Product names in A can be used later for labels. Do not include totals, blank separator rows, or explanatory notes inside the data range. Make sure numbers are stored as numbers rather than text: a value aligned oddly or flagged as text may not plot correctly.
  3. Check the values and units. Confirm that each row’s X, Y, and size values belong to the same item. Keep units consistent within each measure; do not mix thousands of dollars with dollars in one size column. Bubble size values should be greater than zero for a clear, meaningful bubble. A size of zero may not appear, and negative sizes do not represent a meaningful bubble size. If a measure includes zeros or negatives, consider whether a different size measure or a different chart type better represents the data. Also check for blank cells and extreme outliers, which can make most bubbles difficult to compare.
  4. Insert the bubble chart. Select the three numeric columns, including their headers, such as B1:D6 in a small example. On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose the standard 2-D Bubble option for most comparisons. Excel creates a chart from the selected range. If it plots the wrong values or treats columns as separate series, do not rebuild the table immediately: use the series-editing method in the next step to set the X, Y, and size ranges explicitly. If you have several groups to compare, add them as separate series rather than placing unrelated measures in the same three columns.
  5. Verify or edit the series ranges. Click the chart, then choose Chart Design > Select Data. In the Select Data Source window, select a series and choose Edit. In the Edit Series window, set Series name to the appropriate header cell or a descriptive name, Series X values to the X-number cells, Series Y values to the Y-number cells, and Bubble size to the size-number cells. For example, for rows 2 through 6, those ranges would be B2:B6, C2:C6, and D2:D6. Select the range picker button beside each field if it is easier to select cells directly, then confirm each selection. If you need another group, choose Add in Select Data and enter that group’s name and three corresponding ranges. Make sure each range has the same number of data rows and does not include the header row.
  6. Add a useful chart title and axis titles. Select the chart, then choose Chart Design > Add Chart Element. Use Chart Title to add a title, and Axis Titles to add horizontal and vertical axis titles. Replace generic text with clear descriptions and units, such as Satisfaction score or Growth rate (%). A title should explain the comparison, not just repeat the chart type. If the size measure is not obvious, add a subtitle or a short note near the chart that says what larger bubbles mean.
  7. Label bubbles if names matter. Select the chart, choose Chart Design > Add Chart Element > Data Labels > More Data Label Options, and open the label options in the Format Data Labels pane. Select Value From Cells, choose the cells containing the item names, and confirm. If labels show extra numbers as well, clear options such as X Value, Y Value, or Bubble Size in the same pane, leaving the name labels you need. Cell-based labels are especially helpful when the audience must identify particular products or locations. For a crowded chart, label only the most important bubbles or use a legend and a nearby data table instead.
  8. Format the chart for easy comparison. Click an axis and choose Format Axis to adjust its minimum and maximum bounds, number format, or display units. Set bounds only when they preserve an honest view of the data; starting an axis above zero can exaggerate apparent differences in position. To change bubble appearance, click a bubble series and use the formatting controls for fill, outline, and transparency. A little transparency can reveal overlapping bubbles. Keep the palette simple and use a different color for each meaningful group, not for every individual point unless the colors encode a clear category. Resize the chart so labels do not collide, then check it at the size at which people will view or print it.

On Excel for Mac, look for the same Insert, Chart Design, and Format controls on the ribbon or in the chart formatting pane; the arrangement can vary by release. Keyboard navigation and some dialog names may differ from Windows. If a command is not visible, select the chart first and check the contextual chart tabs.

Common Mistakes

Mixing up the three measures: Excel can create a chart even when the wrong column is assigned as X, Y, or size. Confirm the series ranges in Select Data and make sure each one matches the intended header.

Using text or inconsistent units: Text-formatted numbers, currency mixed with counts, or percentages recorded sometimes as 5 and sometimes as 5% can produce confusing results. Standardize values before charting and make the units clear in headers or axis titles.

Assuming bubble area is an exact visual ruler: Bubble size is a visual comparison, not a replacement for the underlying values. Avoid asking readers to estimate precise numbers from circle areas. Include labels for key points or show the source values in a table when exact comparisons matter.

Overloading the chart: Too many bubbles, labels, or colors can make the picture unreadable. Use a focused set of observations, split distinct groups into separate charts when appropriate, or label only selected points.

Using a 3-D bubble option for decoration: Perspective and depth can make bubble sizes harder to compare. Use the standard 2-D bubble chart unless a specific requirement calls for the 3-D style.

Tips

  • Sort the source table by a useful field before charting, such as category or size, to make the data easier to check. Sorting does not change the meaning of the plotted coordinates.
  • Use bubble size for a measure with a clear positive scale, such as units sold or population. Explain whether a larger bubble means more or less of that measure.
  • When items overlap, try a smaller chart marker size or some transparency in the series formatting. Do not shrink bubbles so far that size differences become invisible.
  • Use a consistent number format on both axes, particularly for percentages, dates represented numerically, or currency measures. A well-formatted axis helps readers understand the scale.
  • Keep a copy of the source data in the workbook and use clear headers. If the data changes, check that the chart’s series ranges still include the new rows.

Troubleshooting

The chart is blank or some bubbles are missing: Check that the X and Y ranges contain numeric values and that the bubble-size range contains positive numbers. Look for blanks, numbers stored as text, or ranges that stop before the last data row. In Chart Design > Select Data, confirm that all three ranges have matching row counts.

The bubbles appear in the wrong places: Open Chart Design > Select Data, edit the series, and verify the X values and Y values fields. A common cause is accidentally swapping the two ranges or including the header row as a plotted value. Confirm the axes’ titles and units after correcting the series.

One bubble dominates the chart: Check for a data-entry error or a genuinely large outlier in the size column. Confirm that every value uses the same unit and scale. If the outlier is valid, keep it but consider a separate view or a note; changing or removing a valid point just to make the chart look balanced can mislead readers.

Names do not appear as labels: In the Format Data Labels pane, make sure Value From Cells is selected and that the chosen range contains the item names, not the numeric measures. Check that the range contains one label per plotted point. If the option is unavailable in your Excel version, add labels manually to selected points or open the workbook in the desktop version of Microsoft 365.

The chart is too crowded: Remove nonessential labels, increase the chart area, or filter the source to a relevant subset. If labels overlap, click a label and move it where possible, or label only the points that readers must identify. If several groups obscure one another, use separate charts or distinguish groups with restrained colors and a clear legend.

Frequently Asked Questions

What is the difference between a bubble chart and a scatter chart?
A scatter chart plots two numeric measures as X and Y coordinates. A bubble chart does the same and adds a third numeric measure, represented by the size of each bubble.

Can a bubble chart show more than one data series?
Yes. Add a separate series for each group in Chart Design > Select Data. Assign an X range, Y range, and bubble-size range to every series, and ensure the ranges in each series correspond to the same observations.

Can I show names instead of numbers on the bubbles?
Yes. Use data labels with Value From Cells and select the worksheet cells containing the names. You can clear numeric label options so the chart displays names without X, Y, or size values.

Can bubble sizes be negative?
Negative values do not make meaningful bubble sizes. Use positive values for the size measure. If the measure can be zero or negative, choose a different size field or a chart type that can represent those values clearly.

When should I use a bubble chart instead of a regular chart?
Use one when you need to compare three numeric measures for a set of items and the audience can interpret bubble size. If the exact third measure is more important than a visual comparison, a table or a different chart may communicate it more precisely.

Does Excel for the web support bubble charts?
Excel for the web may offer bubble charts through its Insert chart controls, but available formatting options can differ from the desktop app. If you cannot edit series ranges or apply cell-based labels, open the workbook in Excel for Microsoft 365 on Windows or Mac.

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.