Excel Waterfall Chart: Change Colors and Format Bars

To change colors in an Excel waterfall chart, select the chart and choose Chart Design > Change Colors to apply a different palette. To set a custom color on a particular bar, select that data point, open Format Data Point, then use Fill & Line > Fill > Solid fill and choose a color.

Excel uses distinct colors for increases, decreases, and totals, so you can either change the chart’s overall palette or format individual bars for emphasis. The important distinction is that coloring a bar changes its appearance, while marking it as a total changes how the waterfall calculates and displays it.

What colors mean in a waterfall chart

A waterfall chart explains how a starting amount changes through a series of additions and subtractions before reaching an ending amount. For example, a chart might begin with monthly revenue, add sales from several regions, subtract refunds and expenses, and finish with net revenue. The floating bars show the size and direction of each change; the connecting lines help readers follow the running total.

Excel normally distinguishes three kinds of points:

Increase: a positive change that raises the running total.
Decrease: a negative change that lowers the running total.
Total: a bar anchored to the chart’s baseline, such as an opening balance, subtotal, or final result.

These colors are visual cues, not a replacement for reading the category labels or values. A company might use green for increases, red for decreases, and dark blue for totals, but another organization may use a different palette. Choose colors that remain understandable in your report and consistent with its other charts.

Change the chart’s color palette

Changing the palette is the quickest way to alter the chart’s overall color treatment. In Excel for Microsoft 365 on Windows:

Click the waterfall chart to show the chart tabs on the ribbon.
Open Chart Design.
Select Change Colors.
Choose a color palette from the available options.

The palette applies a coordinated set of colors to the chart. Depending on the palette, it can change the appearance of the increase, decrease, and total categories together. This is convenient when the default colors clash with a presentation theme or when you want a more muted or more vivid chart without formatting bars one by one.

Palette options are not the same as a promise that every positive bar will receive one exact custom color in every theme. Check the result after choosing a palette, especially if the chart has several data-point types or your workbook uses a custom theme. If the palette does not produce the precise colors you need, use point formatting for individual bars.

Set a custom color on one bar

To emphasize one category—for example, a large one-time expense—format that data point directly. In a waterfall chart, the first click can select the chart’s data points as a group; click the specific bar again to select only that point. The selection handles should appear around the individual bar rather than around all the bars.

Click the bar you want to recolor. If the whole set of bars is selected, click the same bar once more.
Right-click the selected bar and choose Format Data Point.
In the formatting pane, open Fill & Line (the paint-bucket icon).
Expand Fill, select Solid fill, and choose the color.
Close the pane and check that the intended point—not another bar—changed.

For instance, in a chart of quarterly operating profit, you could make a one-off restructuring cost orange so readers notice it. Keep the usual decrease color for routine expenses, though; otherwise, readers may mistake the highlighted point for a different kind of value. A label or annotation can explain why the bar is exceptional.

Formatting a single data point is useful for exceptions, but it can take time if you need to recolor many bars individually. For a chart where every bar needs to follow a different rule, consider whether the standard waterfall chart is the right presentation or whether a carefully designed custom chart is warranted.

Format increases, decreases, and totals consistently

Excel’s waterfall chart distinguishes increases, decreases, and totals, but it does not automatically interpret a color choice as a new business rule. A positive bar remains an increase even if you color it gray, and a negative bar remains a decrease if you make it blue. For a quick report, use Chart Design > Change Colors first; then inspect the visual distinction between all three kinds of bars.

If you need precise colors for many points, you may have to select and format the relevant bars individually. Take care to confirm each selection: choosing the chart area or the entire set of data points can open a different formatting pane or apply a change more broadly than intended. After editing a point, click elsewhere in the chart and verify the result against its category and value.

For a reusable report, document the meaning of any nonstandard color in a subtitle, data label, or nearby note. Do not rely on color alone to distinguish increases from decreases. Bar direction, category labels, and visible values should still make the story clear if someone prints the chart in grayscale or has difficulty distinguishing colors.

Make sure subtotal bars are actually totals

A common source of confusion is a subtotal that looks like an ordinary increase or decrease. In a waterfall chart, a subtotal should usually be marked as a total so Excel anchors it to the baseline instead of treating it as another change in the running calculation. Coloring a bar to look like a total does not set this behavior.

To mark a point as a total, right-click the bar and choose Set as Total. The bar should then begin at the chart’s baseline and represent the subtotal value. Use the same command for an opening or ending balance when that point is meant to show a complete amount rather than a change. If the menu offers Unset as Total, that point is already set as a total.

Consider a sequence with a starting cash balance of 100, a collection of receipts, several payments, and an ending balance of 125. The receipts and payments are changes; the starting and ending balances are totals. If the ending balance is mistakenly left as a change, it may float from the preceding balance and visually imply that 125 was added rather than that 125 is the final balance. Fix the point’s total status first, then format its color.

Common color and selection problems

The whole chart changes instead of one bar. Click the target point a second time before opening the formatting pane. Confirm that the pane says Format Data Point, not Format Data Series or Format Chart Area.
The selected color does not appear. Check that Solid fill is selected and that transparency is not making the fill nearly invisible. Also check whether you selected a point or the chart background.
A subtotal floats in the wrong position. Use Set as Total; changing its fill color will not correct its calculation or position.
Colors change after choosing a chart style. A chart style or palette can alter the chart’s appearance. Apply broad style choices first, then recheck any manually formatted points.
The chart is hard to read when printed. Use adequate contrast and retain labels or values. Avoid relying on red-versus-green alone to convey direction.

If the chart is based on a table or regularly refreshed data, review its colors after adding categories or changing the source range. New points may not carry the custom formatting you intended, and a visual check can catch a missing highlight or an incorrectly formatted subtotal.

Choose colors for clear communication

Color should help a reader understand the movement, not compete with the data. A straightforward scheme often uses one color for increases, a contrasting color for decreases, and a neutral or strong accent for totals. Keep the same meaning across related charts in the same report. If your organization has brand colors, use them where they preserve contrast and do not make increases and decreases difficult to tell apart.

Also consider how the chart will be viewed. A chart on a large screen may remain legible with lighter fills, while a small printed chart needs clear contrast. Avoid very pale colors against a white background, and keep text labels readable. If the chart uses data labels, test whether the label color remains visible over both the increase and decrease bars.

Color conventions are not universal: red may mean a decrease in one report and a warning or brand color in another. Add a legend or a short explanation when your choices could be ambiguous. A useful test is to ask whether someone who has not seen the workbook can identify the opening amount, the changes, and the final amount without needing to guess what the colors mean.

Waterfall chart colors versus other chart types

A waterfall chart is designed to show a running total, so its increases, decreases, and totals have distinct roles. In a regular column chart, bars usually compare separate values from a shared baseline; selecting a palette there does not create waterfall-style running calculations. Switching chart type just to gain more color control can therefore change the meaning of the visual.

If the main purpose is to compare categories rather than explain how a value accumulates, a clustered column chart may be clearer. If the purpose is to show composition at a single point, a stacked chart may suit the data better. Use a waterfall when the sequence of changes matters, and customize its colors without altering the underlying chart type unless the question your chart answers has changed.

Frequently Asked Questions

Can I change all the colors in an Excel waterfall chart at once?

Yes. Select the chart, go to Chart Design > Change Colors, and choose a palette. This is the fastest way to change the chart’s overall color scheme. For a specific custom color on one point, use Format Data Point instead.

Can I make every increase bar green and every decrease bar red?

Start with Chart Design > Change Colors and choose a palette that gives increases and decreases the distinction you want. If you need exact colors and the palette does not provide them, format the relevant data points individually and check new or refreshed points afterward.

Why does my waterfall subtotal not start at zero?

It may be treated as a change rather than a total. Right-click the subtotal bar and choose Set as Total. A total is anchored to the baseline; changing its color alone does not change its status.

Can I change a waterfall bar’s color without changing its value?

Yes. Formatting a data point changes its appearance, not the number in the worksheet or its increase, decrease, or total status. Use Format Data Point > Fill & Line > Fill to set the fill color.

Do these steps work in Excel for Mac?

The same general approach applies in current desktop Excel for Mac: select the chart, use its chart-design color controls, or open the data-point formatting pane for a custom fill. Ribbon placement and pane presentation can differ slightly from Windows, so look for the chart design and formatting controls after selecting the chart or point.

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.