How to Change Bubble Size in an Excel Bubble Chart

Charts & pivot tables · Updated November 19, 2026

To change bubble sizes in an Excel bubble chart, right-click a bubble, choose Format Data Series, open Series Options, and adjust Scale bubble size to. To change the size of one bubble relative to the others, edit that point’s size value in the chart’s source data instead.

Two ways to control bubble size

Excel uses the third value in a bubble chart’s data to determine the relative size of each plotted bubble. That gives you two different controls, which solve different problems:

  • Scale bubble size to changes the display scale for the series. Use it when all the bubbles look too small or too large.
  • The size values in the worksheet determine how the bubbles compare with one another. Change a value in the source data to make that observation larger or smaller relative to the rest.

For example, a chart might plot advertising spend on the horizontal axis, sales on the vertical axis, and number of customers as bubble size. The scale setting can make the whole series easier to see, but it does not change which campaign has the most customers. Editing a customer count does change that comparison.

These are separate from changing a bubble’s color, outline, or transparency. Those are formatting choices; they do not change the size value represented by the chart.

Adjust the size scale in Excel for Windows

In Excel for Microsoft 365 on Windows, use these steps to make every bubble in a series appear larger or smaller:

  1. Click a bubble once to select the data series. If the chart has more than one series, check that you selected the one you intend to format.
  2. Right-click a bubble in that series and choose Format Data Series. The Format Data Series pane opens.
  3. In the pane, select Series Options, usually represented by a small column-chart icon.
  4. Find Scale bubble size to and enter a larger or smaller percentage. For example, try 150% if the bubbles need to stand out more, or a lower percentage if they obscure one another.
  5. Close the pane or click elsewhere in the chart to review the result. Adjust the percentage again if needed.

The setting applies to the selected series as a whole. It is not a field for assigning a precise diameter in pixels to one bubble. Because a bubble chart is meant to show relative sizes, compare the chart before and after the change and make sure the differences between values are still readable.

If the right-click menu says Format Data Point, you may have selected a single bubble rather than the series. Click a blank part of the chart and then click a bubble once to select the series, or use the chart’s selection controls to choose the series. A chart with multiple series may require a little care: formatting one series does not necessarily change the others.

Check the chart’s source data

A typical bubble chart uses three numeric columns: one for the horizontal position, one for the vertical position, and one for bubble size. For example, a table could contain a product name, monthly revenue, customer satisfaction, and units sold. Revenue and satisfaction supply the two coordinates; units sold supplies bubble size. The product names can be used as labels, but they are not the size values.

To see which data Excel is using, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, choose a series and select Edit to inspect its X values, Y values, and bubble size range. Check that the three ranges refer to corresponding rows. If the X range contains five observations but the size range contains a different set of cells, the bubbles may not represent the intended items.

If you are building a chart, select the relevant data and choose Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. The exact appearance of the Insert menu can vary with window width, but choose a bubble chart rather than a basic scatter chart. After insertion, use Chart Design > Select Data to correct the series ranges if Excel did not interpret the columns as intended.

Values in the size range should be numeric and meaningful for comparison. A blank, a number stored as text, or an unexpected zero can lead to a missing or very small bubble. Check the worksheet cells and the selected size range before changing formatting; a scale adjustment cannot repair a chart that is reading the wrong data.

Change one bubble relative to the others

To change one observation’s bubble size, edit its value in the worksheet column used for bubble size. Suppose the size column records the number of customers for each campaign. If the value for one campaign is incorrect, correct that source cell. Excel updates the bubble automatically when the chart is linked to that range.

If the source value is correct but the chart still hides an important point, consider whether changing its plotted size would misrepresent the data. A bubble chart communicates the size variable visually. Increasing one bubble merely for emphasis can suggest a larger quantity than the underlying value supports. Instead, use a data label, a contrasting fill, or a callout to direct attention while preserving the data.

You can format an individual point separately—for example, to give it a distinct color—but that does not provide a separate manual diameter control that replaces its source size. If you truly need a different size, change the corresponding size value or restructure the data into separate series. Splitting points into separate series can make formatting more controllable, but it adds setup work and may complicate the legend and comparisons. Use it only when the chart’s design justifies the extra complexity.

Choose a useful size scale

There is no single ideal percentage. The right setting depends on the number of bubbles, how closely their coordinates cluster, and the size of the chart. Increase the scale in small increments and check the chart at the size readers will actually see it. A setting that looks clear on a large monitor may cause overlap when the chart is placed in a report or printed on a page.

Keep these practical checks in mind:

  • Look for overlap. Larger bubbles can cover smaller ones, hide axis positions, or make a dense chart difficult to interpret.
  • Preserve meaningful differences. If every bubble looks nearly identical, verify the underlying size values as well as the scale setting.
  • Use labels selectively. Labeling every point in a crowded chart can make it harder to read. Label key bubbles or use a legend and a separate data table where appropriate.
  • Consider the audience. A chart used in a presentation may need more visible bubbles than one embedded in a worksheet with nearby data.
  • Keep the scale consistent when comparing charts. If two charts use different size scales, the same value may look different in each, making visual comparisons misleading.

Bubble size is a visual encoding, not a direct ruler measurement. Do not assume that a bubble twice as wide represents twice the size value: width and overall visible area are different ways of judging a circle. Include a clear size legend or explain the size variable when readers need to interpret the values precisely.

Fix common bubble-chart problems

All bubbles look too small. Select the correct series and increase Scale bubble size to. Also check whether the chart itself is very small; resizing the chart may help without making the bubbles dominate the plot.

One bubble is missing. Check its size value and the corresponding X and Y values. A zero or blank size value may produce no visible bubble, while a point with coordinates outside the visible axis range can also appear to be absent. Confirm that the chart’s series ranges include the row.

The bubbles overlap after resizing. Lower the series scale, enlarge the chart area, or adjust the axis bounds if doing so still represents the data honestly. You can also label only important points or use a different chart type when too many observations occupy the same region.

The size change has no effect. Make sure the Format Data Series pane is open for the intended series, not a data label, chart area, or single point. Then inspect the size range in Chart Design > Select Data. If the chart is a scatter chart rather than a bubble chart, it will not use a third bubble-size range.

The bubbles look different from one another, but the ranking seems wrong. Review the source size values, their units, and their row alignment. For example, a range containing percentages mixed with whole-number counts will not provide a useful comparison. Make sure the size column measures the same kind of thing for every observation.

Excel on Mac and Excel for the web

In Excel for Mac, select or Control-click a bubble and open Format Data Series; the formatting pane provides the series options when supported by that version. Ribbon layout and the way a context menu opens can differ from Windows, but the essential task is the same: select the series, find its bubble-size scale setting, and change the percentage. If the option is hard to locate, use desktop Excel’s chart formatting pane rather than trying to resize a bubble by dragging it.

Excel for the web can display and edit many chart properties, but some chart-formatting controls may be limited or arranged differently from the Windows desktop app. If you cannot find the bubble scale control, open the workbook in Excel for Microsoft 365 on Windows or Mac and make the adjustment there. Editing the source size values in the worksheet is another option, provided you understand how that changes the data being represented.

When another chart type may be clearer

A bubble chart is useful when three numeric variables matter: two determine position and a third determines size. It is less useful when bubble overlap makes individual observations impossible to identify, or when readers need to compare exact values quickly. In those cases, consider a scatter chart with labels or color for the additional category, a column chart for direct size comparisons, or a table alongside the chart.

Do not add bubble size simply because the chart type is available. If the third variable is not important, a scatter chart is usually easier to read. If it is important, explain what size means and keep the scale consistent wherever the chart is compared with another one.

Frequently Asked Questions

How do I make all bubbles bigger in Excel?

Right-click a bubble in the series, choose Format Data Series, open Series Options, and increase Scale bubble size to. This changes the display scale for that series without changing the underlying worksheet values.

Can I resize just one bubble in an Excel chart?

Not with the series-wide scale setting. To change one bubble’s relative size, edit its value in the source data’s bubble-size column. If you only want to emphasize the point without changing what its size represents, use a label or distinct formatting instead.

Why are some bubbles not showing?

Check for blank, zero, or text values in the bubble-size range, and confirm the point’s X and Y values are included in the chart and within the visible axes. Also verify that the series is using the intended worksheet ranges.

Does changing bubble scale change the data?

No. The scale setting changes how the selected series is displayed. Editing a value in the size column does change the chart’s represented data, so do that only when the source value needs correction or the intended measure is genuinely different.

Can I set an exact bubble diameter in pixels?

The bubble-size scale is a percentage setting for the series, not an exact per-point pixel measurement. Excel sizes bubbles from the chart’s size values and applies the display scale; the result can also depend on the chart’s dimensions.

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.