Excel Bubble Chart Color Change: Steps and Options

Charts & pivot tables · Updated November 19, 2026

To change bubble colors in Excel for Microsoft 365 on Windows, select the chart, right-click a bubble, choose Format Data Series, then open Fill & Line and choose a fill color. To color just one bubble, select that point separately and use Format Data Point. You can also set colors by category by placing each category in its own chart series.

How bubble chart colors work

A bubble chart plots three numeric values: one for the horizontal position, one for the vertical position, and one for bubble size. Each plotted bubble belongs to a data series. Excel applies formatting to a series as a whole unless you select an individual data point, so changing a series fill usually changes every bubble in that series.

Color is a visual formatting choice; it does not change the chart’s X values, Y values, bubble sizes, or source data. That distinction matters when you want colors to communicate something meaningful. For example, a blue bubble does not automatically mean a high value, and Excel does not infer a color scale from the bubble’s data just because you change its fill.

Excel can assign different colors to points in a single series with its Vary colors by point setting, where available for the selected chart. Those colors are palette choices, not a rule that links a particular color to a particular cell value. For stable, purposeful colors—such as red for one region and green for another—separate series are generally the better approach.

Change the color of an entire series

Use this method when all bubbles in one series should share a color. If the chart contains several series, select a bubble belonging to the series you want to format; the whole series should become selected. Then use the formatting pane:

  1. Click the bubble chart once to display the chart tabs.
  2. Right-click a bubble in the series to change and select Format Data Series.
  3. In the pane, select Fill & Line, shown as a paint-bucket icon.
  4. Under Fill, choose Solid fill, then open Color and select a theme or standard color.
  5. Click outside the pane to finish, and check that the intended series changed.

If the right-click menu says Format Data Point, you have selected a single bubble rather than the full series. That is fine if you meant to format one point; otherwise, click another bubble in the same series or use the chart’s current selection controls to select the series. The pane’s heading is a useful confirmation of what Excel will format.

To choose a color not shown in the quick palette, open the color menu and look for More Colors. Depending on the Excel build and the color control, you can enter a custom RGB or hex value. Theme colors are usually preferable when the workbook may be restyled later, because they can follow the workbook’s theme.

Change the color of one bubble

To emphasize an outlier, a target customer, or one important observation without recoloring the entire series, select a single data point. Click the series once, then click the bubble you want to change again. The second selection targets that point; right-click it and choose Format Data Point. In Fill & Line, set a solid fill and choose the color.

Be deliberate with the selection. A single click on a bubble usually selects its series, while selecting the same bubble again targets the point. If the pane identifies the selection as a series, the change will affect all bubbles in it. You can also use the chart formatting controls’ Current Selection list to identify or select chart elements, though the available entries depend on the chart.

Individual point formatting is useful for a small number of exceptions, but it can be harder to maintain when the source data changes. If the chart is rebuilt, points are added, or the order changes, review the highlight. For repeated, data-driven categories, separate series are more dependable than manually coloring many individual bubbles.

Use different colors for categories

A common question is how to make Excel color bubbles according to a label in the worksheet—for example, give each product family its own color. A standard bubble chart does not automatically map an arbitrary text column to a persistent color assignment. Instead, organize the data so each category is a separate series, then set each series’ fill once.

A basic source table might have columns for category, X value, Y value, and bubble size. In the chart’s data arrangement, each series needs its own X values, Y values, and sizes. You can create separate blocks or use the chart’s Select Data controls to define each category as a series. Select the chart, then use Chart Design > Select Data to review or edit the series. Set each series’ X values, Y values, and bubble size range to the matching category’s rows.

For example, a market chart could use one series for North, one for South, and one for West. Give the regions distinct colors and keep those assignments consistent throughout the workbook. The legend will identify the series, so clear series names matter. If your source table is not arranged for separate series, reorganizing the data or building helper ranges may be necessary; simply adding a category-label column does not guarantee Excel will use it to color the bubbles.

Do not confuse categories with numeric values. If the goal is to color bubbles red above a threshold and blue below it, split the points into two series based on that rule, leaving nonmatching X, Y, or size entries out of each group as appropriate. This takes more setup, but it makes the rule explicit and easier to audit than coloring points by hand.

Use Excel’s palette or vary point colors

For a quick visual refresh, select the chart and open Chart Design > Change Colors. Excel offers coordinated palettes, and the choices can vary with the workbook theme and chart. This is a convenient way to change the chart’s overall color treatment, but it may recolor more than the one series you had in mind. Inspect the result, especially when the chart already uses deliberate category colors.

For a single series with several points, right-click the series and look in Format Data Series for Vary colors by point. When that option is available, enabling it gives individual points different colors from the chart palette. It is helpful when you want to distinguish points quickly, but the color-to-point mapping is not a dependable substitute for labeled categories. If categories have meaning, use separate series or label the points clearly.

Palette names and exact color choices can differ across Office versions, themes, and operating systems. Excel for Mac has comparable chart formatting controls, although the ribbon and pane layout may differ slightly. Excel for the web also supports chart formatting, but some detailed controls can be more limited or presented differently than in the Windows desktop app; use the desktop steps when a specific point-level option is not visible.

Adjust transparency, outlines, and bubble readability

Color alone may not be enough when bubbles overlap. In the formatting pane, use the fill transparency control to let underlying bubbles show through. A modest amount of transparency can reveal overlaps, though too much makes small bubbles difficult to see against the plot area. Check the chart at its normal on-screen or printed size rather than judging it only while zoomed in.

Under Line in Fill & Line, you can choose an outline color and adjust its appearance. A subtle outline can separate adjacent bubbles with similar fills. A very thick or dark border can dominate the chart, so use it sparingly. If several series overlap, vary both fill and outline only when doing so improves identification, and retain a legend or labels.

Bubble size communicates a third numeric variable, so avoid a color scheme that makes the largest bubbles look more important than the data warrants. Excel’s bubble-size scaling is separate from fill color. If a large bubble obscures smaller ones, consider transparency, a different chart layout, or a separate view rather than shrinking bubbles solely to make a color scheme work.

Common color problems and fixes

  • Every bubble changed: You formatted the series. Select the specific bubble again and confirm the pane says Format Data Point.
  • Only one bubble changed: You selected a point rather than the series. Select a different bubble in that series and format the series instead.
  • The chart colors changed unexpectedly: Change Colors applies a palette to the chart. Reapply the intended series fills individually afterward.
  • Colors reset after editing the data: Check whether the chart was rebuilt, new series were added, or formatting was replaced. Recheck series assignments and point formatting.
  • Colors look different on another computer: Theme colors can change when a workbook theme changes, and display settings affect appearance. Use fixed custom colors if exact consistency is required, and check the exported or printed result.
  • The selected bubble is hard to target: Click the series, then click the same bubble again. If points overlap, select the point through the chart’s selection controls where possible, or temporarily adjust transparency or chart size.

Also check whether the chart contains more than one series. Bubbles that appear to form one group may actually be split into several series, each with its own formatting. The legend and the Current Selection list can help identify the series before you make a change.

Keep colors consistent when sharing the workbook

When colors represent categories, document the meaning in the legend, a nearby key, or the chart title and notes. Do not rely on color alone to convey a critical distinction: use descriptive series names, data labels where useful, and enough contrast for readers with color-vision differences. A combination such as color plus a clear label is more robust than color by itself.

To reuse a chart’s appearance, you can copy and paste the chart within the workbook, then adjust its data source, or save a chart template through Excel’s chart template options. After changing the data, review the series colors and legend because the new chart may have a different number or order of series. A consistent palette is most valuable when it is applied deliberately across related charts, not just when each chart looks attractive on its own.

Frequently Asked Questions

Can I change the color of one bubble in Excel?

Yes. Select the series, select the same bubble again to target the individual point, then right-click and choose Format Data Point. Set its fill under Fill & Line. Confirm the pane says Data Point so you do not recolor the whole series by mistake.

Can Excel automatically color bubbles based on a cell value?

Not as a built-in conditional color rule for a standard bubble chart. To assign stable colors by category or by a threshold, divide the points into separate series and format each series. Excel’s vary-colors option can give points different palette colors, but it does not create a reliable rule tied to arbitrary cell values.

How do I change all bubble chart colors at once?

Select the chart and choose Chart Design > Change Colors to apply another chart palette. To set one exact color for every bubble in a series, format that series and choose a solid fill. A chart with multiple series may require changing each series separately.

Why does changing one bubble change the whole chart?

The bubble was probably selected as part of its data series, or the palette command changed chart-wide colors. Select the bubble a second time and check that the formatting pane identifies a data point before applying a fill.

Can I use different colors for positive and negative values?

Yes, but Excel does not automatically condition bubble fills on positive or negative values. Arrange positive and negative points as separate series, assign each series a fill, and verify that the X, Y, and size values remain matched to the correct points.

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.