Add Labels to a Bubble Chart in Excel: Steps and Tips

Charts & pivot tables · Updated November 19, 2026

To add labels to a bubble chart in Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Add Chart Element > Data Labels > More Data Label Options, then select Value From Cells and choose the cells containing the labels. You can also right-click the bubble series and choose Add Data Labels to display values such as X, Y, or bubble size.

How labels work on a bubble chart

A bubble chart plots each data point using three numeric values: one for its horizontal position (X), one for its vertical position (Y), and one for its bubble size. A label adds identifying or explanatory text beside the bubble. It does not change the point’s position or size, so readers can see what a bubble represents without having to match it back to the worksheet.

Excel’s built-in label choices can show values from the chart, including X value, Y value, and bubble size. These are useful when readers need to inspect the plotted numbers. For human-readable names—such as product names, cities, or project labels—use Value From Cells to link labels to a range on the worksheet. You can choose a single label type or combine cell text with one or more plotted values.

Bubble charts can contain more than one series. Each series has its own X values, Y values, and bubble sizes, so add or format labels for the series you intend to explain. A label that identifies a product is often more useful than three numbers; conversely, showing the numbers can help when the chart is being used for analysis rather than presentation.

Prepare the worksheet data first

Set up the chart data so each bubble has a clear row or position in a series. A simple layout might have product names in column A, X values in column B, Y values in column C, and bubble sizes in column D. For example, a product comparison could use price as X, customer rating as Y, and annual sales as bubble size. The names in column A can then be used as the point labels.

Before choosing a label range, check that the labels line up with the plotted points in the same order. If the chart contains several series, identify which rows or columns supply each series. Select the name cells for just the series you are labeling, rather than including headers or names belonging to a different series. If you later sort or rearrange the source data, check that each name still belongs to the corresponding X, Y, and size values.

  • Use short, distinctive names when many bubbles are close together.
  • Keep the label range to one cell per point in the selected series.
  • Use blank cells only when you intentionally want particular points to have no text label.
  • Keep the underlying chart data intact; labels are annotations, not replacements for the plotted values.

Add names from worksheet cells

To attach names or other text to bubbles, first click the chart, then click one bubble once to select the full series. If the chart has multiple series, make sure the selected bubbles belong to the series you want. Right-click a bubble in that series and choose Add Data Labels. Excel adds labels using its default value setting; the next step replaces or supplements those values with text from cells.

  1. Right-click one of the newly labeled bubbles and choose Format Data Labels. This opens the formatting pane.
  2. Under Label Options, select Value From Cells. If Excel asks for a range, select the worksheet cells containing the point names and confirm.
  3. In the same pane, clear options you do not want, such as X Value, Y Value, or Bubble Size. Leave the relevant options checked if you want the numeric values to appear alongside each name.
  4. Choose a label position that keeps the text close to its bubble without covering important chart details.

For example, if the chart’s points use rows 2 through 8 and the names for those points are in A2:A8, select those seven cells as the label range for that series. The first selected name is applied to the first point in the series, the second to the second point, and so on. If the labels appear on the wrong bubbles, compare the chart’s point order with the range order and correct the source data or selection.

To label another series, select that series and repeat the process with its own matching label range. Applying labels to one series does not automatically create custom labels for every other series.

Show X, Y, or bubble-size values

If you want the chart to show the numbers that determine each bubble, use the built-in label options. Select the series, add data labels if necessary, and open Format Data Labels. Under Label Options, choose the values you want displayed: X value, Y value, or bubble size. The exact combination depends on the story the chart is meant to tell. For example, a chart comparing product price and rating might show the product name and price, while leaving bubble size visible as a visual indicator of sales.

Showing every available value is not always helpful. A label containing a name and three numbers can become difficult to scan, particularly when bubbles are crowded. Consider using custom cell labels for identification and leaving the axes to communicate X and Y values. If a specific number is essential, include only that value with the name. You can also format the source cells to control the text used for custom labels—for example, shortening a long description or displaying a rounded figure—without changing the underlying chart data.

Format labels so they remain readable

After adding labels, use the Format Data Labels pane to adjust their position and appearance. Select the labels or a particular label, then use the available font and text formatting controls. The best placement depends on the bubble layout: labels above or beside a point may work in an open area, while a centered label may be suitable for a large bubble. Check the whole chart, since a position that works for one point may overlap another.

When labels collide, try these practical fixes before shrinking the text until it is hard to read:

  • Shorten labels in the source cells, using consistent abbreviations where necessary.
  • Make the chart larger or reduce the number of points shown at once.
  • Remove optional numeric label components and keep only the most useful information.
  • Move individual labels where Excel allows it, and check that the connection to the intended bubble remains clear.
  • Use a legend to identify series, and reserve point labels for details that cannot be conveyed by the legend.

Labels should add context, not obscure the relationship between the axes and bubble sizes. A chart with fewer, meaningful labels can communicate more effectively than one that prints every available field on every point.

Common problems and how to fix them

Value From Cells is missing. Confirm that you are using the desktop version of Excel and have selected data labels in the chart, not just the worksheet cells or chart area. Excel for the web may not expose the same full set of chart-label controls. If the option is unavailable, open the workbook in the desktop app and check the Format Data Labels pane.

The labels do not match the bubbles. The custom label range must follow the order of the points in the selected series. Check that the range has one cell per bubble and excludes header cells. With multiple series, make sure you selected the intended series before setting the label range.

Numbers appear when you wanted names. In Format Data Labels, select Value From Cells, choose the name range, and clear numeric options such as X Value, Y Value, or Bubble Size if they are not needed. Selecting cells does not necessarily turn off the chart’s default numeric labels by itself.

Some labels are blank or cut off. A blank source cell produces no custom text for that point. Text may also be hidden when the chart is too small or the label sits near its edge. Check the source cell, enlarge the chart, or reposition the label. If a label contains more text than will fit, shorten the text in the source cell or use a note or table alongside the chart.

The wrong bubble is selected. A single click on a bubble generally selects its series; clicking again can select an individual point. To apply one label setup across a series, confirm that the series—not just one point—is selected before formatting. If you have selected an individual point by mistake, click another part of the series or select the series through the chart’s selection controls, then try again.

Desktop, Mac, and web differences

The instructions above use the Microsoft 365 desktop ribbon on Windows. In Excel for Mac, the chart tools and formatting pane are similar, but some controls may be arranged differently. Select the chart and look under Chart Design for Add Chart Element, then open the data-label formatting options. If a command is not visible in the ribbon, try the chart’s context menu and the Format Data Labels pane.

Excel for the web can handle many routine chart edits, but the available chart-formatting options can differ from the desktop app and may change over time. For a custom range of cell-based labels, use desktop Excel if the Value From Cells control is not present in the web interface. After editing labels, save the workbook and confirm that the chart still displays as intended when opened in the version your audience will use.

Frequently Asked Questions

Can I put names on bubbles in Excel?
Yes. Add data labels, open Format Data Labels, select Value From Cells, and choose the worksheet cells containing the names. Clear numeric label options if you want names only.

Can Excel show a bubble’s X and Y values?
Yes. Select the data labels and turn on X Value and Y Value in the Format Data Labels pane. You can also show bubble size, though displaying all three numbers may make a crowded chart harder to read.

Can I label only one bubble?
Yes. Select the series, then select the individual point and add or format a label for that point. Selection can take more than one click; check that only the intended point is selected before changing its label.

Why are my custom labels in the wrong order?
Excel applies the selected cell labels in point order. Make sure the label range matches the chart series order, contains one cell per plotted point, and does not include a header or unrelated rows.

Can I use a legend instead of bubble labels?
A legend is useful for distinguishing series, such as product categories shown in different colors. It does not normally identify every individual bubble, so use cell-based data labels when readers need to know the name of each point.

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.