Excel Bubble Chart Different Colors: Set Each Series

Charts & pivot tables · Updated November 19, 2026

Yes. In Excel for Microsoft 365, bubble-chart colors are usually assigned by data series: put each group you want colored differently in its own series, then set the series color. To color selected bubbles within one series differently, format each data point individually.

What different bubble colors mean

A bubble chart plots three numeric values for each observation: one value controls the horizontal position, another controls the vertical position, and a third controls the bubble size. Color is a separate visual cue. Excel normally gives each series a color, so a chart with one series will generally show its bubbles in one color even if every row represents a different item.

A series is a set of points that share the same X-value range, Y-value range, and bubble-size range. For example, if you compare products by revenue, customer rating, and market size, you might place each product category in a separate series. Excel can then give categories distinct colors, and the legend can identify them.

There are two useful approaches:

  • Color by group: Create one series per group. This is the clearest option when colors represent meaningful categories and you want a useful legend.
  • Color individual bubbles: Keep one series, then format selected points one at a time. This suits a small number of highlights, but the colors may not appear as separate legend entries.

Excel does not generally treat bubble-chart colors like conditional formatting in cells. It will not automatically assign a chosen color to every bubble whose underlying value meets a rule. Use separate series for repeatable group colors, or format points manually for one-off emphasis.

Set different colors for separate series

Start with data arranged so each group has its own three value ranges. For instance, a table could have columns for North X, North Y, North size, South X, South Y, and South size. Each group needs its own X values, Y values, and bubble sizes. Keep headings in the first row so you can use meaningful series names.

  1. Select the data for the first group and insert a bubble chart using Insert > Insert Scatter (X, Y) or Bubble Chart > Bubble. If you are building a 3-D bubble chart, choose that option only when the additional perspective is useful; it can make comparisons harder.
  2. Select the chart. On the ribbon, choose Chart Design > Select Data.
  3. In the Select Data Source dialog, choose Add. Enter or select the group name for Series name, then set the X values, Y values, and Bubble size ranges in the Edit Series dialog.
  4. Repeat Add for each group. Check that each range contains the same number of observations and that X, Y, and size values align row by row.
  5. Choose OK to return to the chart. Excel assigns colors to the different series according to the chart style.

To choose exact colors, click one bubble in the series once so the full series is selected. Right-click and choose Format Data Series. In the formatting pane, open Fill & Line, then Fill, choose Solid fill, and select a color. Repeat for each series. The color controls may be displayed slightly differently across Excel updates, but the key is to format the selected series, not the chart area.

Series names are important: they identify the groups in the legend. If the legend is missing, select the chart and use Chart Design > Add Chart Element > Legend, then choose a position. Avoid relying on color alone; clear names make the chart understandable when printed in grayscale or viewed by someone with color-vision differences.

Color individual bubbles in one series

When only a few points need special emphasis, you can change their fills without restructuring the data. Click a bubble once to select its series. Click that same bubble again to select just the individual data point; the second click should select one point rather than the whole set. Right-click the selected point and choose Format Data Point. In the pane, open Fill & Line > Fill, choose Solid fill, and select the color.

Repeat for each point you want to highlight. A practical example is a chart of 20 projects where one point represents a project needing attention. You could leave the main series blue and make that point orange. Add a nearby text label or a clear note explaining what orange means, since a manually colored point may not have its own legend key.

Point-level formatting is convenient but has a maintenance cost. If the source data changes, a point may represent a different record while retaining its old formatting. Review the highlights after sorting, replacing, or updating the data. For charts that refresh regularly, assigning points to separate series by group is usually more dependable.

Arrange the source data and add a legend

Bubble charts need numeric ranges, not just a label and one value. Imagine a workbook with columns A through D for Region, X, Y, and Size. If all regions are included as one series, the Region labels do not automatically become different bubble colors. To make North and South different colors, arrange or reference their X, Y, and Size values as separate series. Each series then has its own three ranges and name.

After the chart exists, Chart Design > Select Data > Add is useful for adding a group without rebuilding the chart. In the Edit Series dialog, use the relevant cells for Series X values, Series Y values, and Series bubble size. Do not include the header cell in the numeric ranges. If a series appears in the wrong place, inspect its X and Y references; swapping those ranges changes the plotted positions.

A bubble chart legend identifies series, not necessarily every row or point. If your chart has one series but many product names, the legend will show one series name rather than a key for each product. For a small chart, data labels can identify selected bubbles. Use labels sparingly: text placed beside large or overlapping bubbles can make the chart difficult to read.

Choose colors that make the chart readable

Color should communicate grouping or emphasis, not merely decorate the plot. Choose colors that remain distinct at the size the chart will be viewed. Several similar blues can blur together, especially when bubbles overlap or have transparency. For a small number of groups, a restrained set of clearly different hues is easier to interpret than a rainbow palette.

  • Use the same color for the same group across related charts.
  • Use a strong accent for a genuinely important point, not for several unrelated observations.
  • Keep labels and outlines visible against both the bubble fill and the chart background.
  • Check the chart in grayscale or with a color-vision accessibility check if it will be widely shared.
  • Include a legend or direct labels so meaning does not depend on color alone.

Bubble size itself can also affect visibility. Large bubbles may cover smaller ones, and a solid fill can hide points behind them. If overlap is a problem, use a lighter fill or adjust transparency in the Fill controls when available. Keep size comparisons honest: Excel scales bubbles according to the size values, and changing a bubble’s formatting should not be mistaken for changing its underlying measurement.

Common color and chart problems

All bubbles have the same color. The chart may contain one series. Add separate series for the groups you want to distinguish, or format individual points manually. Merely adding a text category column does not necessarily create separate colored series.

The wrong bubbles change color. You may have selected the entire series rather than one point, or selected a different point than intended. Click once, pause, click the target bubble again, and check that the formatting pane says Format Data Point before changing the fill.

The legend has only one entry. A single series produces one series legend entry, even when it contains many bubbles. Split the data into multiple series if each group needs its own legend item. Manually recoloring individual points does not automatically create a separate legend entry for each color.

Colors change after choosing a chart style. Applying a different style or using Chart Design > Change Colors can alter the series palette. If exact colors matter, reapply them after changing the style. Save a copy or note the chosen colors if the chart is part of a recurring report.

Bubbles overlap or hide one another. Color cannot fix a crowded plot by itself. Try transparency, reduce the number of plotted points, label only key observations, or divide groups into separate charts. Also confirm that the size values are appropriate; one unusually large size can dominate the visual scale.

Desktop, Mac, and web differences

The steps above are for Excel for Microsoft 365 on Windows. In Excel for Microsoft 365 for Mac, the chart tabs and formatting pane provide comparable controls, though the pane layout and some labels can differ. The right-click or Control-click menu can be used to open formatting options on a Mac; the exact presentation depends on the selected chart element. The chart-design commands are still the place to manage data series and chart colors.

Excel for the web can handle common chart edits, but some detailed formatting controls may be limited or arranged differently from the desktop app. If you cannot find the point-level fill setting or need precise control over multiple series, open the workbook in the desktop version of Excel. When sharing the workbook, remember that colors are chart formatting and should travel with the chart, while the underlying series setup remains tied to its data ranges.

Frequently Asked Questions

Can Excel automatically give every bubble a different color?
Not as a general rule based on each bubble’s value. Excel assigns colors primarily by series. You can create one series per group for automatic series colors, or manually format individual points.

Can I use different colors without adding more series?
Yes. Select each bubble as an individual data point and set its fill. This works well for a few highlights, but it is manual and does not provide a separate legend entry for every point color.

Why does my bubble-chart legend show only one color?
The chart likely contains one series. A legend reflects series, not every observation in a series. Add separate series for the groups that should have distinct colors and names.

Can bubble colors change automatically when a value changes?
Bubble-chart formatting does not provide ordinary cell-style conditional formatting rules for point colors. For a chart that updates by group, organize the data into separate series. Manual point colors may need to be reviewed when the source data changes.

Does changing a bubble’s color change its size or value?
No. Formatting changes only its appearance. The bubble’s position and size continue to come from the series’ X, Y, and bubble-size ranges.

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.