In Excel, you can change bubble chart colours for the whole chart, a data series, or an individual bubble. Select the chart and use Chart Design > Change Colors for a palette, or right-click a series or bubble and choose Format Data Series or Format Data Point to set a specific fill.
What colour represents in a bubble chart
A standard Excel bubble chart plots three values: one determines each bubble’s horizontal position, another determines its vertical position, and a third determines its size. Colour is a visual formatting choice; Excel does not automatically use a fourth column as a colour scale in a basic bubble chart. That distinction matters when you want the colours to communicate information rather than simply make the chart look attractive.
For example, a sales chart could use advertising spend on the horizontal axis, sales on the vertical axis, and market size for bubble size. You might colour the bubbles by region. In Excel, that usually means creating a separate data series for each region, or assigning colours to points manually. A fourth column containing region names does not, by itself, make Excel colour the bubbles by region.
Colours can therefore serve several different purposes:
- Separate categories, such as regions, product types, or project stages.
- Emphasise a particular bubble, such as an outlier or a priority item.
- Apply a consistent visual style across a chart or report.
Decide which purpose matters before choosing a palette. A colour scheme that looks lively but gives categories no consistent meaning may make the chart harder to interpret.
Change the palette for the whole chart
Excel’s built-in chart palettes are the quickest way to adjust the overall appearance. Select the chart so the chart tabs appear on the ribbon, then choose Chart Design > Change Colors and select a colour set. The available choices depend on the workbook’s Office theme and Excel version. This is a convenient starting point when you want the chart to match a report or presentation without formatting every bubble separately.
A palette change applies colours according to the chart’s series and point formatting. Depending on how the chart is set up, it may change the appearance of multiple series or of points within a series. If the result is not what you intended, undo the change or format the relevant series or point directly. Palette commands are not a way to say, for example, make every value above 100 blue and every value below 100 orange.
Workbook theme colours also affect the choices presented in Office. On Windows, you can change the workbook theme colours from Page Layout > Colors. This can help keep charts, shapes, and other workbook elements coordinated. If the workbook will be shared, remember that a theme change can affect other objects that use theme colours, not only the bubble chart.
Set a colour for a series or one bubble
To give every bubble in a series the same colour, select the chart and right-click one of the series’ bubbles. Choose Format Data Series. In the formatting pane, open Fill & Line, expand Fill, choose Solid fill, and select a colour. The series-level setting is useful when all the bubbles represent one category and should have a consistent appearance.
To format just one bubble, first click a bubble once to select its series, then click the target bubble again to select that individual data point. Right-click it and choose Format Data Point. In the pane, use Fill & Line > Fill > Solid fill and choose the colour. Take care to select the point rather than the full series: the pane’s heading indicates whether you are formatting a data point or a data series.
Excel may also show a Vary colors by point option under the series’ fill settings. When available, it gives points in a series different colours from the chart palette. It is a quick way to distinguish bubbles, but the colours are not calculated from a fourth variable and may not express a meaningful order or category. If you need a particular bubble to retain a particular colour, formatting that point directly gives you more control.
For a custom shade, use the colour controls in the formatting pane. Depending on the dialog and version, you can choose a standard or theme colour or open the additional colour controls. If a precise brand colour matters, check the available custom-colour inputs in your version rather than assuming every Excel colour dialog accepts the same format.
Colour categories with separate data series
If colour should consistently identify categories, separate series are usually more reliable than colouring points one at a time. For example, to compare North, South, and West regions, arrange the chart data so each region has its own X values, Y values, and bubble-size values. Add each region as a series, then format each series with a distinct colour. This makes the category-to-colour relationship explicit and easier to maintain.
In Excel for Microsoft 365 on Windows, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, use Add to define a series. Give it a series name and specify the ranges for its X values, Y values, and bubble size. Repeat for the other categories. The exact range layout depends on how the source data is organised; check that each series’ three ranges contain corresponding rows so that every bubble’s position and size belong to the same record.
Once the series are in place, right-click a bubble in each series, choose Format Data Series, and assign its fill. For instance, you could use blue for North, orange for South, and green for West, then include a legend that identifies those regions. Avoid assigning similar colours to categories that readers need to distinguish quickly.
This approach is especially useful when data is refreshed or new rows are added, although the chart’s source ranges may need updating depending on how the data is set up. Individual point formatting can be less predictable when points are reordered or series are rebuilt. For a chart that changes regularly, organise the data and series deliberately and check the colours after updating the source.
Fill, transparency, and bubble outlines
The Format Data Series and Format Data Point panes provide more than a colour picker. Solid fills are generally the clearest choice for comparing categories. Depending on the selected chart element and Excel version, fill options may also include transparency, gradients, patterns, or picture and texture fills. Those effects can be useful for a specific design, but they can also make small bubbles difficult to read.
Transparency is particularly helpful when bubbles overlap. In the fill controls, adjust the transparency setting so that a bubble behind another one remains partly visible. There is no single ideal percentage: a small change may be enough for a chart with a few overlaps, while a dense chart may need a stronger adjustment or a different layout. Check the chart at its intended display size, because transparency that looks clear on a large monitor may be hard to interpret when the chart is reduced.
You can also adjust the outline from the pane’s Line controls. A thin outline can make adjacent bubbles easier to distinguish, especially when their fills are similar. A heavy outline can overwhelm small bubbles, so use it sparingly. If bubbles overlap heavily, remember that colour and transparency cannot reveal every hidden point; consider labelling selected points or simplifying the data shown.
Choose colours readers can interpret
Use colour consistently. If blue means one region in one chart, changing blue to a different region in a related chart can confuse readers. A legend helps, but a clear, repeated mapping is easier to learn. For categories without a natural order, use distinct hues. For values that have a meaningful low-to-high order, a colour progression may be appropriate only if you deliberately create and explain that mapping; Excel does not automatically turn the fourth column of a bubble chart into such a scale.
Keep accessibility and printing in mind. Red and green alone can be difficult for some readers to distinguish, and colours that are vivid on screen may become similar in grayscale. Use labels, a legend, or other visual cues alongside colour when the distinction matters. Test the chart against a light background and at the size where it will be read.
Bubble size already carries information, so avoid using a complicated colour scheme that competes with it. If colour marks categories and size represents magnitude, make those roles clear in the legend or a nearby note. Also check that small bubbles remain visible: a pale fill, high transparency, and no outline can make them disappear against the plot area.
Common colour problems and fixes
- Every bubble looks the same. Check whether the chart has one series with a solid series fill. Use Vary colors by point if it is available, format selected points individually, or split meaningful categories into separate series.
- The wrong thing changes colour. Check the formatting pane heading. If it says Format Data Series, you have selected the series; select a single bubble and open Format Data Point to change only that point.
- Colours change after using Change Colors. That command applies a chart palette, so it can replace or rearrange chart colours. Reapply specific point or series fills after choosing a palette if exact colours matter.
- Bubbles hide one another. Try some fill transparency and a subtle outline. If the overlap remains confusing, label key bubbles or reduce the number of plotted points.
- A category colour is difficult to maintain. Put each category in its own series rather than relying on a series of individually coloured points, then verify the series after refreshing the source data.
Excel for Microsoft 365 on Mac has comparable chart-formatting controls, though ribbon names, pane layout, and available options can differ slightly. Excel for the web supports common chart edits, but some detailed formatting controls may be limited or presented differently. If you cannot find a per-point fill control in the web version, open the workbook in the desktop app and select the bubble there.
Frequently Asked Questions
Can I make every bubble a different colour in Excel?
Yes. Use Vary colors by point if Excel offers it for the selected series, or format bubbles individually with Format Data Point. For categories that need stable colours, separate series are usually easier to manage.
Can Excel colour bubbles from a fourth column automatically?
Not as a direct colour mapping in a standard bubble chart. The chart uses X position, Y position, and bubble size. To represent a fourth variable, create category series or apply point colours manually, and explain the mapping to readers.
How do I change just one bubble’s colour?
Click the series once, click the chosen bubble again, right-click, and choose Format Data Point. Set its fill under Fill & Line. Confirm that the pane refers to a data point before changing the colour.
Can I make overlapping bubbles transparent?
Yes. Select the series or a point, open Fill & Line, and adjust fill transparency if the control is available. Test the result at the chart’s final size; transparency improves visibility but cannot reveal every point in a dense overlap.
Why does Change Colors not give each category the colour I expect?
Change Colors applies a chart palette; it does not assign colours based on category values in your worksheet. For exact category colours, create separate series and format each one, or set individual point fills.
Related
- Count Numbers vs Count in Excel PivotTables
- Copy Paste in Excel: Keep Column Widths When Pasting
- Copy an Entire Excel Spreadsheet to a New File
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Gantt Chart Tutorial: Build a Project TimelineTo make a Gantt chart in Google Sheets, put each task and its start and end dates in…
- Excel Pie Chart: Rotate Slices and Set the First AngleTo rotate an Excel pie chart, select the chart, right-click a slice, choose Format Data Series, then change…
- Excel Pivot Table: Filter and Sort AlphabeticallyYes. In Excel for Microsoft 365 on Windows, click a PivotTable row or column label, open its drop-down…
- Gantt Chart Planned vs Actual Excel Template: How It WorksA planned-versus-actual Gantt chart in Excel compares each task’s scheduled dates with the dates it really started and…
- Excel Pivot Table Blank? Causes, Checks, and Fixes That WorkIf an Excel PivotTable is blank, first check its filters and source data, then refresh it and confirm…
- Automatically Create an Org Chart in Excel: What WorksExcel can quickly create an org-chart graphic with SmartArt, but it cannot automatically turn a regular employee table…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.