Excel Waterfall Chart Help: Build, Format, and Fix One

To create a waterfall chart in Excel for Microsoft 365 on Windows, place each step of your change in one column, select the category and value columns, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. After the chart appears, right-click the starting or ending bar and choose Set as Total; do the same for any subtotal bars that should begin at zero.

What a waterfall chart shows

A waterfall chart, sometimes called a bridge chart, explains how a starting value changes through a sequence of additions and deductions to reach an ending value. Floating bars show the contribution of each step, while total bars extend from the baseline. The connecting lines help the eye follow the running balance from one step to the next.

For example, a team might start with $100,000 in monthly revenue, add $25,000 from new customers, lose $8,000 through cancellations, and lose another $12,000 from discounts. The ending revenue is $105,000. A waterfall makes the movement from $100,000 to $105,000 visible instead of showing only the two endpoints or a list of changes.

The chart is useful when the order of changes matters: budget variances, profit bridges, inventory movements, head-count changes, project costs, and cash-flow explanations are common applications. It is less suitable when categories are unrelated or when the main goal is to compare many values side by side. In those cases, a bar or column chart is often easier to read.

Prepare a clear source table

Use one column for category names and a neighboring column for the amount each category contributes. The first row is the opening value, middle rows are increases or decreases, and the final row is the ending value. A small example could look like this:

Category	Amount
Starting revenue	100
New customers	25
Cancellations	-8
Discounts	-12
Ending revenue	105

These values are illustrative and can represent thousands of dollars, units, or another consistent measure. The arithmetic is 100 + 25 – 8 – 12 = 105. Enter decreases as negative numbers; do not type positive values and expect Excel to infer that they are deductions. Keep all values in the same unit, and avoid blank rows inside the selected range because blanks can create confusing gaps or categories.

If you want Excel to calculate the endpoint, with the opening value in B2 and the changes in B3:B5, enter =B2+SUM(B3:B5) in B6. For this example, the result is 105. Include that result as the ending category in the chart source, then mark its bar as a total. If your table contains several subtotals, keep each one as a distinct row so that it can be identified and formatted separately.

Insert the chart in Excel for Windows

Put category labels in column A and numeric values in column B, with headers in the first row if you have them.
Select the full range, including the labels and values. For the example above with headers, select A1:B6.
On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall.
Check that Excel has used the category names for the horizontal axis and the amounts as the single data series. If it has not, select the chart and use Chart Design > Select Data to adjust the source range.

Excel creates a chart with positive and negative changes represented as floating bars. If the selected range includes headings, Excel generally uses them to name the series and categories. If category labels appear as numbers, or the chart has an unexpected legend entry, inspect the selected range and the settings in Select Data rather than rebuilding the chart immediately.

Excel for Mac also includes waterfall charts in current Microsoft 365 versions. The Insert tab and chart gallery may be arranged differently from Windows, but look for the Waterfall chart type under Insert. In Excel for the web, chart availability and editing controls can differ by account and release; if the chart-type option is not available, open the workbook in the desktop app to create or change it.

Mark opening values, endpoints, and subtotals

A common source of confusion is that Excel does not automatically know which ordinary-looking values are intended to be full totals. It may initially treat the ending value as another change, causing it to float above or below the running balance. To correct it, click the bar once to select the series, then click the specific bar again to select just that data point. Right-click it and choose Set as Total. The bar should then extend from the horizontal baseline.

Set the opening value as a total as well if Excel has treated it as a change. Do the same for any intermediate subtotal that represents a checkpoint, such as a department total before later adjustments. A subtotal is not an additional change to the running balance; it restates the accumulated value at that point. Setting it as a total prevents Excel from adding the subtotal on top of the prior steps.

If you change the data or recreate the chart, check these total settings again. The chart’s data-point formatting is separate from the number in the worksheet: a row containing 105 does not tell Excel by itself that the bar is the final balance.

Format labels, colors, and scale

Formatting should make the story easier to interpret, not decorate every bar. Select the chart and use Chart Design or the chart’s plus-sign Chart Elements button to add a title, axis titles, data labels, or a legend as appropriate. A useful title states the subject and period, such as Monthly Revenue Change, rather than a generic label like Waterfall Chart.

Use clear colors. Excel distinguishes increases, decreases, and totals with separate default colors. Keep those roles distinct and choose shades with enough contrast against the chart background.
Format the vertical axis. Right-click the axis and choose Format Axis to set number formatting and, if helpful, sensible bounds. Currency symbols, thousands separators, and percentage formats should match the units in the source data.
Add labels selectively. Data labels can show the size of each change, but many long categories or small bars can make labels overlap. Widen the chart, shorten category names in the source, or remove labels from minor steps if readability suffers.
Explain special cases. If a bar represents a subtotal, a forecast, or a one-off adjustment, make that meaning clear in the category name or a nearby note.

Do not use a misleading axis scale to exaggerate small differences. Waterfalls communicate cumulative movement, so readers should be able to see whether the baseline is zero and understand the scale. If you choose to set a nonzero minimum to focus on a narrow range, label that choice clearly and consider whether the floating bars remain easy to interpret.

Read the chart and check the arithmetic

Read the chart from left to right. The opening total sets the initial level. Each positive bar raises the running balance, and each negative bar lowers it. The endpoint should match the arithmetic sum of the start and all intermediate changes. In the revenue example, the sequence is 100, then 125 after new customers, 117 after cancellations, and 105 after discounts. The ending total therefore agrees with the source table.

This running-balance logic is the important distinction between a waterfall and a regular column chart. The value -8 is a decrease of eight from the current level; it is not a final balance of negative eight. A standalone column chart would draw each change from the same baseline, which is helpful for comparing change sizes but does not show how each step carries forward.

Before sharing a chart, verify both the arithmetic and the interpretation of every total. A chart can be visually polished and still be wrong if a subtotal is counted twice, a negative sign is missing, or the endpoint was entered as a change rather than set as a total.

Common problems and practical fixes

The ending bar floats instead of starting at zero: select that individual bar, right-click, and choose Set as Total. Confirm that the value itself is the intended endpoint.
The chart adds the final balance to the previous steps: Excel is treating the endpoint as a change. Set it as a total; do not alter a correct endpoint merely to make the picture look right.
Every bar starts from the baseline: check that you inserted a Waterfall chart, not a clustered column chart. Also confirm that the data are one sequence of changes rather than multiple series.
Changes move in the wrong direction: inspect signs in the source data. Deductions need negative values, and increases need positive values.
Category names or values are missing: select the chart and open Chart Design > Select Data. Check that both the label and value columns are included and that the header row is not being interpreted as a data point.
The chart looks cluttered: reduce the number of categories, group small related movements where that grouping is meaningful, widen the chart, or use data labels only where they help.

When a chart still seems inconsistent, compare the running arithmetic in a separate worksheet column. This is especially useful when the source includes several subtotal rows. Each subtotal should equal the opening amount plus the changes before it, not a new amount to add to the total.

Waterfall charts versus other chart options

Choose a waterfall when the message is how a total changes from a starting point to an ending point. Use a clustered bar or column chart when the reader should compare independent values, such as sales by region. A line chart is usually more appropriate for a continuous time trend with many dates. A stacked chart can show composition, but it is not a substitute for a bridge when the sequence of increases and decreases is the main point.

For a report that needs to show both the bridge and the exact calculation, pair the chart with a compact table. The table makes individual values easy to audit, while the chart makes the direction and cumulative effect easier to grasp. If the data change frequently, keep the source table tidy and update the chart’s source range when adding categories; a chart does not necessarily include new rows entered outside its current range.

Frequently Asked Questions

How do I make the last bar a total in Excel?
Select the chart, click the endpoint bar again to select only that data point, right-click it, and choose Set as Total. The bar should extend from the baseline rather than continue the running sequence.

Why is my Excel waterfall chart showing the wrong ending value?
Check the source arithmetic, negative signs, and any subtotal rows. Then confirm that the final value is marked as a total. A subtotal treated as a change, or an endpoint treated as a change, can make the displayed running balance look incorrect.

Can a waterfall chart show subtotals?
Yes. Include each subtotal as a row in the source data, then select its bar and choose Set as Total. This tells Excel to display that checkpoint from the baseline rather than add it again to the prior running balance.

Can I use negative numbers in a waterfall chart?
Yes. Negative values represent decreases and positive values represent increases. Use the correct sign in the worksheet, and check that the chart’s colors and labels make the direction of each change clear.

Can I create a waterfall chart in Excel for Mac?
Current Excel for Mac versions include the chart type, though the chart gallery and ribbon layout may differ from Windows. Look under the Insert tab for Waterfall; if you are using Excel for the web and cannot find the option, use the desktop app.

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.