Excel Bubble Chart Color Options: How to Customize Them

Charts & pivot tables · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select a bubble series and use Format Data Series > Fill & Line to choose a solid or gradient fill, transparency, and an outline color. To color just one bubble, select the series, select that bubble again, and format the resulting data point; for dependable category colors, put each category in its own series.

What bubble chart colors control

A bubble chart plots each record by its X and Y values and uses bubble size to represent a third value. Color can help readers distinguish groups, call attention to a particular observation, or make overlapping bubbles easier to interpret. Excel does not automatically use a fourth numeric column as a continuous color scale in a standard bubble chart. If color represents a value, you need to define meaningful groups or apply point formatting yourself.

Color also has separate parts. The bubble’s interior is its fill; the edge is its outline or border. You can format them independently. For instance, a pale blue fill with a darker blue outline can make a bubble visible without making a dense chart look too heavy. Transparency changes how much of the chart beneath a bubble can be seen. It can help when bubbles overlap, though excessive transparency can make small bubbles difficult to notice.

In a chart with multiple series, Excel generally assigns a color to each series. A series is a set of plotted points that share a name and data ranges, not necessarily a business category unless you organize the data that way. A legend identifies series colors, so structuring the chart into useful series is often the simplest way to make color meaningful.

Excel bubble chart color options

Excel provides several practical ways to set color. Some affect the whole chart or a series; others affect a single bubble. The options you see can depend on which chart element is selected and how the chart is structured.

  • Chart color palettes: On the chart, open Chart Design > Change Colors and choose a Colorful or Monochromatic palette. These are quick theme-based choices for chart series. Depending on the chart and its series structure, a palette may not give every bubble in one series a distinct color.
  • Series fill: Select a bubble in the series, open Format Data Series > Fill & Line, and choose a fill such as Solid fill or Gradient fill. A series-level change applies to the series rather than just the selected bubble.
  • Point fill: Select the series, then select the individual bubble a second time. Right-click and choose Format Data Point, or open the formatting pane, then change its fill or outline. This is useful for highlighting a small number of important observations.
  • Outline and transparency: In the formatting pane, adjust the series or point’s line color and width, and the fill transparency where available. A visible outline can separate neighboring bubbles even when their fills are similar.
  • Custom colors: Use the color picker’s custom-color option to specify a color rather than choosing only from the theme swatches. Excel’s dialog and available input fields can vary by platform and update; on Windows, the custom color dialog lets you define a color using RGB values.

Chart styles can change more than color: they may alter borders, backgrounds, or other visual details. If you have carefully formatted individual bubbles, avoid changing styles repeatedly without checking the result, since a new style or palette can override or alter some existing formatting.

How to color individual bubbles

For a one-off highlight, format a point directly. First click a bubble once; this selects the whole series. Click the same bubble again, taking care not to double-click so quickly that Excel opens another command. The selected point should now be highlighted separately. Right-click it and choose Format Data Point, then use the pane’s fill and line controls.

  1. Select the chart, then click the bubble you want to change once to select its series.
  2. Click that bubble again to select only the data point. Check that the selection is a single point rather than the whole series.
  3. Right-click the point and choose Format Data Point.
  4. In Fill & Line, set the fill and, if useful, the outline. Choose a color that remains distinct from nearby bubbles and the chart background.

This direct formatting is convenient for a few exceptions, such as marking a particular product or an outlier. It is less convenient when the chart changes often: if the data is sorted, replaced, or refreshed, a manually colored point may no longer represent the intended record. In that case, use separate series for groups or review the point formatting whenever the underlying data changes.

You can also add a data label to explain a highlight. Select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a placement. Labels can make a highlighted bubble’s meaning clearer, but adding labels to every point may clutter a chart with many observations.

Use series to color categories consistently

If color should indicate categories such as regions, product lines, or customer types, arrange each category as its own series. A bubble series needs X values, Y values, and bubble sizes. With the chart selected, use Chart Design > Select Data, then add a series and specify its name and the relevant ranges. Repeat for each category. Excel can then assign or accept a distinct series color, and the legend can explain the mapping.

For example, imagine a chart comparing products by profit margin on the horizontal axis, sales growth on the vertical axis, and annual revenue by bubble size. If each product belongs to one of three regions, create a series for each region. Give each region a distinct color and keep the axes and bubble-size meaning the same across all three. A viewer can then compare both position and size while using the legend to identify region.

When preparing the source data, make sure each series contains only the records for its category and that X, Y, and size ranges line up row by row. A common mistake is to use one category’s X values with another category’s Y values or sizes; the chart may still appear, but its bubbles will represent mismatched records. Keep clear headers and check a few plotted points against the source rows after adding series.

Splitting categories into series is more robust than relying on an option that recolors every point in a single series. If your Excel build presents a Vary colors by point control, its availability and effect depend on the chart type and context. For bubble charts, use separate series when consistent category coloring and a useful legend matter.

Choose colors that make the data easier to read

Start by deciding what color means. If it identifies a category, use the same color for that category everywhere in the workbook and preserve a clear legend. If it highlights an exception, keep most bubbles neutral and use one accent color sparingly. If colors have no defined meaning, extra variety may distract rather than help.

  • Use distinguishable hues: Choose colors that remain easy to tell apart when bubbles are close together. Avoid relying on subtle differences between two similar blues or greens.
  • Check contrast: Make bubble fills visible against the plot area. A darker outline can help light fills show up, especially when the chart will be printed or viewed at a small size.
  • Account for overlap: Use some transparency or a clear outline when large bubbles overlap. Transparency is a visual aid, not a fix for every crowded chart; if the chart remains hard to read, reduce the number of plotted points or separate groups.
  • Support readers who distinguish colors differently: Pair color with a legend, labels, or another cue such as series names. Do not make color the only way to identify a critical result.
  • Keep size and color meanings separate: State what bubble size represents and what color represents. A chart with a clear key is easier to interpret than one that expects readers to infer both.

For a presentation, check the chart at the size and background where it will appear. A fill that looks distinct on a large monitor can become hard to distinguish in a small slide, a printout, or a screenshot. If the chart will be printed in grayscale, use labels, outlines, or separate panels as additional identifiers rather than assuming the color differences will survive.

Common color problems and fixes

Every bubble changes when you wanted one. You probably selected the series rather than an individual point. Click the desired bubble a second time and confirm the formatting pane says Format Data Point before changing its fill.

Change Colors does not give each bubble a different color. The palette is principally a chart-series coloring tool, and a single bubble series may remain one color. Split the data into category-based series for consistent automatic series colors, or format a few individual points manually.

The legend does not explain the colors you chose. A manually recolored point may not create a separate legend entry. Add a data label, use a separate series for a meaningful group, or explain the highlight in a nearby note. A legend is most useful when each legend item corresponds to a real plotted series.

A color changes after applying a theme or style. Theme-based palettes and chart styles can update chart appearance. Recheck the series and points after applying them, then restore any custom colors that were changed. For a stable chart, make final palette choices before fine-tuning individual points.

Bubbles are hard to distinguish despite different fills. Check whether the chart has too many overlapping points, whether the fills have enough contrast, and whether outlines would help. You can also use transparency, but do not reduce opacity so far that small bubbles disappear. For repeated observations in the same area, consider showing fewer categories or creating separate charts.

Windows, Mac, and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. In Excel for Mac, chart design and formatting controls are available when the chart or data series is selected, but the ribbon layout and custom-color dialog can differ. Look for the chart’s Chart Design and Format tabs and the formatting pane; do not expect every Windows color-picker control to appear in exactly the same place. Mac keyboard shortcuts also differ for many commands, but the point-selection approach is the same.

Excel for the web supports chart editing, but some detailed formatting controls may be more limited or arranged differently from the desktop app. If you cannot find an individual-point fill or a specific custom-color field in the browser, open the workbook in the desktop version of Excel to apply the formatting. The chart should still be checked after editing so its legend, fills, and series remain correct.

Frequently Asked Questions

Can I give every bubble in one Excel series a different color?
Yes, you can format individual data points one at a time. For many points or categories that need consistent colors, separate the data into multiple series instead; this is easier to maintain and gives the chart a clearer legend.

How do I change the color of just one bubble?
Click a bubble once to select its series, then click that same bubble again to select the point. Right-click, choose Format Data Point, and change its fill or outline in the formatting pane.

Can bubble color show a fourth variable automatically?
Not as a continuous numeric color scale in a standard Excel bubble chart. The chart uses X position, Y position, and bubble size for its three plotted measures. You can represent another measure by defining categories and coloring separate series, or by manually formatting points, but you must make the meaning clear.

Why does Excel apply one color to all my bubbles?
The bubbles may all belong to one series, so a series-level fill applies to every point. To use category colors, create a series for each category, or select and format individual points when only a few need different colors.

Can I use a custom RGB color for a bubble?
Yes. Open the series or point’s fill-color picker and choose its custom-color option, then enter the desired RGB values where the dialog allows it. The exact dialog can differ between Windows, Mac, and the web version.

Bottom line

For quick styling, use Chart Design > Change Colors or set a series fill in Format Data Series. For a single exception, select and format an individual data point. For repeatable category colors and a meaningful legend, organize the bubble chart into separate series. Choosing a clear color purpose, checking overlap and contrast, and keeping a legend or label will make the chart easier to interpret than color variety alone.

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.