Bubble Chart in Excel: How to Create and Read One

Charts & pivot tables · Updated November 19, 2026

To create a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three columns—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 and its size represents the third.

What a bubble chart shows

A bubble chart is a variation of an XY scatter chart. Each data point is positioned by two numeric values on horizontal and vertical axes, while a third numeric value controls the size of its bubble. This makes it useful when you want to compare three measures for a set of items without creating a separate chart for each measure.

For example, a product team might plot profit margin on the horizontal axis, customer satisfaction on the vertical axis, and annual sales as bubble size. A product with a high margin and high satisfaction would appear toward the upper right; a larger bubble would indicate greater sales. The chart can reveal clusters and unusual points, but it does not explain why those patterns occur.

Bubble charts work best when readers can compare positions and approximate sizes. They are less suitable when values need to be read precisely, when many points overlap, or when the data has no meaningful pair of numeric coordinates. A bubble chart is not simply a pie chart with floating slices: position is meaningful, and the bubbles do not add up to a whole.

Prepare the worksheet data

Put one observation on each row, with a header above each of the three fields. Keep the columns together and avoid blank rows inside the data range. For instance, a small sales comparison could use these fields:

  • Product: the item name, such as Cedar, Maple, or Birch.
  • Profit margin: the numeric X value, such as 12, 18, or 25.
  • Customer rating: the numeric Y value, such as 3.6, 4.1, or 4.5.
  • Annual sales: a positive numeric value used to size each bubble, such as 40, 90, or 160.

The category name is useful for labeling, but it is not one of the three plotted measures. A convenient layout is Product in column A, Profit margin in B, Customer rating in C, and Annual sales in D. When creating the chart, select the two numeric coordinate columns and the size column; Excel may also recognize the headers. If it assigns the wrong fields, you can correct the series in the chart’s data settings.

Use numeric values rather than numbers stored as text. Make sure every row refers to the same observation across all columns: a product’s margin, rating, and sales must stay on the same row. Bubble sizes should be positive and measured consistently. If sales are in thousands of dollars, use that unit for every product and state it clearly in a title, axis title, or note.

Create the bubble chart in Excel

  1. Select the X, Y, and size data, including headers if present. If the category names are in a separate column, you can add them later as labels.
  2. On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. Choose the standard Bubble option for a flat chart. Excel also offers a 3-D Bubble option, but perspective can make sizes and positions harder to compare.
  3. Check that the horizontal axis uses your intended X values, the vertical axis uses your intended Y values, and the bubble sizes come from the third numeric field. Excel’s automatic interpretation can be wrong when the selected range has extra columns or an unusual layout.
  4. Click the chart title and replace it with a specific description. For example, use Products by Margin and Customer Rating, with Bubble Size Showing Annual Sales.

If the chart is empty or the points look unrelated to the data, select the chart and open Chart Design > Select Data. In the Select Data Source window, choose the series and click Edit. Set Series X values to the cells containing the horizontal measure, Series Y values to the vertical measure, and Bubble size to the size cells. Exclude header cells from these value ranges. The exact cell references depend on your worksheet.

Format bubbles, axes, and labels

Formatting should make the chart easier to interpret, not decorate it at the expense of clarity. Click a bubble to select the series, right-click, and choose Format Data Series. In the formatting pane, adjust the fill and border, and use the bubble-size scale option if the bubbles appear too small or too large. A scale change alters the visual display, not the underlying values; it does not change the ordering of the data.

Add axis titles so readers know what the position means. Select the chart, then choose Chart Design > Add Chart Element > Axis Titles and add horizontal and vertical titles. Include units where needed: Margin (%) is more informative than Margin, and Customer rating (out of 5) gives useful context. If the axis ranges waste space or hide differences, right-click an axis, select Format Axis, and set suitable minimum and maximum bounds. Avoid cropping values in a way that exaggerates the apparent separation between points.

To show product names, select the chart and choose Chart Design > Add Chart Element > Data Labels, then open the data-label formatting options. In Format Data Labels, enable Value From Cells and select the cells containing the names. Clear X Value, Y Value, or Bubble Size if those numbers would clutter the chart. If your Excel build does not show Value From Cells, add labels manually or use the series name and numeric values available in the label options.

Labels often collide when points are close together. Make the chart larger, reduce the font size modestly, or label only the most important points. Use a consistent color for one series; multiple colors are meaningful only if color represents another category and that category is explained in a legend. A gradient or a variety of unrelated colors can make it seem as if there is a fourth variable when there is not.

Choose useful bubble sizes and scales

Bubble size is an area-based visual encoding: a bubble with twice the area is not twice the diameter. This is why very large values can dominate a chart and why readers may misjudge differences by looking only at width. Excel lets you adjust the overall bubble scale for readability, but the scale should not be used to disguise extreme values or imply precision the chart cannot provide.

Before charting, consider whether the third measure needs transformation or a different presentation. If one value is vastly larger than all others, small bubbles may become almost invisible. You might use a separate chart, explain the distribution, or choose a logarithmic approach only if that treatment is suitable and clearly labeled. Do not silently remove an outlier just to make the remaining bubbles look more alike.

Zero and negative values are not good bubble-size inputs: they cannot be represented as ordinary positive-sized circles in a meaningful way. If negative values matter, use a scatter chart for the two coordinates and show the third measure through a different method, such as a separate data label or another chart. Keep the underlying data intact and make the change in visual encoding explicit.

Read the chart without overclaiming

Start by reading each axis, then compare the approximate bubble sizes. Look for groups, gaps, and points far from the main cluster. In the product example, items in the upper-right area have both stronger margins and higher ratings; larger circles among them indicate more sales. A high sales figure alone does not mean a product has a high margin or rating—the chart keeps those measures separate.

A bubble chart is not a statistical test and does not establish cause and effect. An apparent relationship between margin and rating may be influenced by product type, season, sample size, or other factors. It is also difficult to compare two circles precisely, especially when their sizes are similar. If exact values matter, add labels, provide a data table, or use a chart with a more precise scale.

For a crowded chart, consider whether all observations need to appear at once. Use a focused subset only when the selection rule is defensible, or split the data into smaller charts with consistent axes. If the points represent dates, a line chart may better show change over time; bubble charts are most useful when the points are categories or observations whose two coordinates are meaningful.

Common problems and fixes

  • Excel plots the wrong columns: Open Chart Design > Select Data and edit the series so X values, Y values, and bubble sizes each refer to the intended cells.
  • One bubble covers the others: Check for a very large size value or mixed units. Confirm the data, adjust the bubble scale for legibility, and consider splitting the chart if overlap remains.
  • Names appear as numbers: Configure labels with Value From Cells and select the category-name range. Avoid including the names in the numeric X, Y, or size ranges.
  • The chart has no visible bubbles: Check that the values are numeric, the size range contains usable positive values, and the series ranges cover matching rows. Also confirm that the axis bounds include the coordinates.
  • Axes start at inconvenient values: Right-click the axis, choose Format Axis, and review its bounds and number format. Choose limits that preserve an honest view of the differences.

For a chart that needs to update as rows are added, consider converting the source range to an Excel table with Insert > Table before building the chart. Charts based on tables can expand with the table as new data is entered, though it is still wise to check the series ranges after changing the layout.

Bubble charts compared with alternatives

Use a regular scatter chart when you need to compare only two numeric variables. It is often easier to read because every point has the same marker size. Use a column or bar chart when the main task is comparing exact values across named categories, and a line chart when the order of observations—often time—is central. A bubble chart adds a third numeric dimension, but that extra encoding is worthwhile only if readers can distinguish the sizes and understand what they represent.

If a third measure is important but bubble sizes overlap too much, small multiples or a scatter chart paired with a table may work better. Excel does not turn a bubble chart into a map or a timeline automatically; the axes still represent numeric coordinates. Choose the form that supports the question rather than choosing a bubble chart simply because three columns are available.

Frequently Asked Questions

Can an Excel bubble chart show category names?
Yes. Add data labels, open Format Data Labels, enable Value From Cells, and select the cells containing the names. Turn off numeric label components that are not needed to keep the chart readable.

How many variables can a bubble chart show?
It directly encodes three numeric variables: X position, Y position, and bubble size. Color or labels can add categories or context, but they should be used consistently and explained rather than treated as self-evident extra measures.

Why are some bubbles missing?
Check that the size values are numeric and positive, that the X and Y values are numeric, and that the series ranges line up row by row. Also check axis limits and whether a very small bubble is hidden behind a larger one.

Can I make a bubble chart in Excel for Mac or the web?
Excel for Mac includes chart insertion and formatting options, but ribbon wording and the location of some settings can vary by release. Excel for the web supports many chart tasks, though some detailed formatting controls may be more limited than in the Windows desktop app. The underlying setup is the same: numeric X, Y, and size ranges.

Should I use a 3-D bubble chart?
Usually not for comparisons that readers must judge accurately. Perspective can make apparent bubble sizes and positions harder to compare. The standard two-dimensional Bubble chart is generally clearer; use 3-D only when its appearance serves a specific purpose and does not obscure the data.

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.