Format Waterfall Charts in Excel: A Practical Guide

To format a waterfall chart in Excel for Microsoft 365 on Windows, select the chart and use the Chart Design and Format tabs to change its colors, labels, axes, and layout. To make a starting balance, ending balance, or subtotal behave as a fixed total, right-click that bar and choose Set as Total.

What a waterfall chart shows

A waterfall chart explains how a starting amount changes through a sequence of increases and decreases to reach an ending amount. Each change appears as a floating bar: positive changes move the running total up, and negative changes move it down. Connector lines help show how one step leads to the next. Excel typically distinguishes increases, decreases, and totals with different colors, which you can adjust to match your reporting style.

This chart is useful when the path matters as much as the final result. Examples include explaining a change in monthly cash, showing how revenue and costs contribute to profit, or reconciling a beginning balance with adjustments and an ending balance. It is less suitable when the goal is to compare many unrelated values; a bar chart is usually clearer for that task.

Prepare the source data

Put the category names in one column and the amounts in the next, with one row per step. Enter increases as positive values and decreases as negative values. For example, a simple cash reconciliation could be:

Starting cash: 100
Sales received: 40
Supplier payments: -25
Tax paid: -10
Ending cash: 105

The arithmetic is 100 + 40 – 25 – 10 = 105. The starting and ending rows are balance points, not changes to add on top of the running total. Excel initially treats chart entries as steps in the sequence, so you must mark those balance rows as totals after creating the chart. Use clear category labels and keep the data in a contiguous range; blank rows and unnecessary extra columns can make the chart harder to interpret.

Insert a waterfall chart

On Windows, select both columns of source data, including the headers, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Excel creates a chart with the categories along the horizontal axis and the values represented by floating columns. If you include a header row, Excel may use the column headings for the legend or chart series; for a basic waterfall with one series, a legend is often unnecessary.

On Mac, the waterfall chart is also available from the Insert tab, although the chart-gallery wording and the format pane can vary slightly by Excel release. Select the chart to reveal its chart-design controls. If the source data is already in an Excel table, adding rows to the table can help keep the chart’s source range in step with the data, but check the chart after adding categories and mark any new balance rows as totals where appropriate.

Set starting balances, ending balances, and subtotals

After inserting the chart, identify every row that represents a complete balance rather than a change. In the example, the first bar should start at zero and reach 100, while the final bar should show 105 as the ending balance. To set one:

Click a bar once to select the data series, then click the same bar again to select that individual data point.
Right-click the selected bar and choose Set as Total.
Repeat for the other total rows, then check that the floating increase and decrease bars connect to the intended balance.

A common mistake is to mark only the last bar. If the opening balance remains an ordinary increase, Excel adds it to the running total from the chart baseline, which can distort the story. A subtotal in the middle of a chart also needs to be marked as a total. For instance, if a report shows revenue increases and expense decreases followed by an operating-profit subtotal, set that subtotal as a total before showing later adjustments. A subtotal does not automatically change how later rows are interpreted; the next changes continue from the running value represented by the chart.

Format colors and connector lines

For a quick coordinated color change, select the chart and choose Chart Design > Change Colors, then select a palette. This is convenient when the default increase, decrease, and total colors need to fit a presentation or workbook theme. To format one bar individually, select that data point and open the formatting pane by right-clicking it and choosing Format Data Point. In the pane, use Fill & Line to choose a fill and, if needed, adjust the border.

Use color consistently: for example, one color for increases, a contrasting color for decreases, and a neutral or brand color for totals. Avoid relying on color alone to explain the result; labels and category names should make the meaning understandable in a printed or color-impaired view too. If the connector lines are distracting, select the series and inspect Format Data Series for the connector-line option. Connector lines are useful when readers need to follow the running total, but they can look busy when there are many closely spaced categories.

Add labels and format the value axis

Labels can make exact amounts easier to read, especially when the chart will be viewed without its source table. Select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a placement. Check that labels do not overlap bars or one another. With many steps, labeling every small change may add clutter; consider simplifying category names or enlarging the chart before removing information readers need.

To change the vertical scale or number display, right-click the value axis and choose Format Axis. The pane provides axis options and number formatting. For money, use a currency or accounting-style number format that matches the source data; for quantities, use a suitable number of decimal places. If you change the axis minimum or maximum, make sure the scale still gives an honest visual impression. A tightly cropped scale can exaggerate small changes, while an unnecessarily large scale can make meaningful differences difficult to see.

You can add a descriptive title using Chart Design > Add Chart Element > Chart Title. A title such as “Change in Cash Balance, January” tells readers what the values represent and the period covered. Axis titles are useful when units are not obvious from the chart title or labels. Remove a legend if there is only one series and it adds no information; select it and press Delete, or use the chart-element controls.

Improve readability and choose the right level of detail

Good formatting makes the sequence understandable without changing its underlying meaning. Keep category labels concise, use a consistent number format, and make the total bars visually distinct. If the chart has many categories, group minor changes only when the grouping remains faithful to the underlying report. For example, combining several small operating costs into “Other operating costs” can reduce label clutter, but retain the detailed figures in the source data so the summary can be checked.

Check the chart at the size at which it will be presented. Long labels may be cut off or crowded on a narrow chart, and small data labels can become unreadable in a slide or printout. To resize, select the chart and drag a corner handle; dragging a corner generally preserves its proportions better than dragging a side handle. If you need a particular chart size, use the size controls on the Format tab. Avoid 3-D effects or decorative fills that make bar lengths and connections harder to compare.

Common formatting problems and fixes

The ending balance looks wrong: Check that the opening balance and ending balance are both set as totals. Confirm that decreases were entered as negative numbers and that no category was omitted.
A subtotal floats instead of starting at the baseline: Select that individual bar and use Set as Total. Excel does not infer every subtotal from its label.
The chart has the wrong categories or values: Select the chart and use Chart Design > Select Data to inspect its source range. Make sure the category labels and amounts align row by row.
One bar has the wrong color: Check whether you selected the full series or a single data point. Select the individual bar before opening Format Data Point.
Labels overlap or disappear: Try another data-label placement, widen the chart, shorten category names, or show labels only where they add value.

Another frequent misconception is that formatting a bar as a total changes the source value. It does not rewrite the worksheet amount; it changes how Excel plots that category in the waterfall. Keep the source numbers and the chart’s total settings aligned, especially when the data is updated or categories are inserted.

When another chart type may be clearer

A waterfall chart is designed for a running sequence of contributions and balances. Use a regular column or bar chart when you need to compare independent categories, such as sales by region, because those values are not necessarily parts of one cumulative path. A line chart is often better for a measurement changing over time, such as daily temperature, where the order is chronological and the trend is the main point. A stacked chart may be more appropriate when the question is how components make up a whole at each time period.

These alternatives are not interchangeable just because they can display similar numbers. Choose the chart that matches the relationship in the data: cumulative steps for a waterfall, independent comparisons for bars, and continuous trends for lines. A clear title and labels should also state whether the chart shows amounts, percentages, or another unit.

Frequently Asked Questions

How do I make the first bar start at zero?
Select the first bar as an individual data point, right-click it, and choose Set as Total. This displays the opening balance from the chart baseline rather than treating it as another change.

How do I add a subtotal to an Excel waterfall chart?
Click the subtotal bar, right-click it, and choose Set as Total. Do this for each intermediate balance that should begin at the baseline and represent the running result at that point.

Can I change the increase and decrease colors?
Yes. Select the chart and try Chart Design > Change Colors for a palette. To customize one bar, select that point, open Format Data Point, and change its fill under Fill & Line.

Why does my waterfall chart show the wrong final value?
Check the arithmetic in the source data, confirm decreases use negative values, and verify that the beginning balance and any subtotals are marked as totals. Also use Chart Design > Select Data to confirm the chart includes the intended rows.

Can I create a waterfall chart in Excel for the web?
Chart support and editing options can differ between Excel for the web and desktop Excel. If a chart-formatting control is unavailable in your browser, open the workbook in the desktop app, where the Windows steps above are available; confirm the chart after returning to the web version.

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.