Excel Waterfall Chart Setup: A Practical Step-by-Step Guide

To set up a waterfall chart in Excel for Microsoft 365 on Windows, put each step and its change in adjacent columns, select the data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. After Excel creates the chart, mark any ending balance or subtotal as a total so it starts from the horizontal axis rather than continuing the running change.

What a waterfall chart shows

A waterfall chart explains how a starting value changes through a series of positive and negative amounts to reach an ending value. Its floating columns show the running balance after each change. For example, a business can use one to show how opening cash, customer receipts, refunds, operating costs, and other movements produce a closing cash balance.

Unlike a standard column chart, the bars do not all begin at zero. A positive change rises from the current running balance; a negative change drops from it. Totals are different: they begin at the axis and represent the complete balance at that point. The connecting lines between bars help readers follow the sequence.

Waterfall charts are useful when the order and contribution of changes matter. They are common for explaining revenue bridges, budget variances, inventory movements, project costs, and headcount changes. They are less suitable when the goal is to compare many unrelated categories, because floating bars are harder to compare than columns that share a zero baseline.

Prepare the data before inserting the chart

Arrange the source data as a simple two-column list. Put a label for each stage in the first column and the amount added or subtracted in the second. Include a starting balance, the intervening changes, and an ending balance if you want the chart to show both endpoints.

Opening balance: 100
New sales: 35
Returns: -8
Operating costs: -42
Other adjustment: 5
Closing balance: 90

The arithmetic is 100 + 35 – 8 – 42 + 5 = 90, so the closing value reconciles to the movements. Enter decreases as negative numbers, not positive amounts with a minus sign in the label. Keep the values numeric, avoid blank rows within the range, and use clear labels. If the source data contains many transactions, summarize them into meaningful steps first; a bar for every transaction can make the chart too crowded to interpret.

For this example, the opening and closing values are balances, while the four middle entries are changes. That distinction matters because the two balances should be displayed as totals, not as movements to add on top of the running balance. Check the arithmetic before charting: Excel draws the values you supply but does not know whether your business logic is correct.

Create the chart in Excel for Windows

Enter the stage names in one column and their values in the next, with headers if useful.
Select the full range, including labels and values. Do not include unrelated notes or blank rows.
On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall.
Review the first chart. If labels or amounts appear incorrectly, use Chart Design > Select Data to check the chart’s data range and category labels.
Mark the opening, closing, and any intermediate balance that should stand alone as a total. Select the relevant column, right-click it, and choose Set as Total.
Add a descriptive chart title and, where needed, data labels or axis formatting.

To select one column rather than the whole series, click the series once and then click the individual bar. Right-clicking the selected data point provides the Set as Total command. The column should then extend from the horizontal axis, and Excel treats it as a balance rather than another increment in the running calculation. If the command is unavailable, confirm that an individual data point is selected in a supported waterfall chart.

Excel may apply default colors and layout choices when it inserts the chart. Do not assume that every balance has been classified the way your presentation requires. Inspect the opening and final bars, then explicitly set the endpoint and any subtotal bars that should be shown as totals. This also makes the intended logic clearer to someone who later edits the chart.

Set totals, subtotals, and category order

A total marks a checkpoint in the bridge. Common examples include opening and closing cash, gross profit between revenue and expenses, or a quarterly subtotal within a year-to-date explanation. A subtotal should be a genuine balance at that point in the sequence, not a repeated copy of movements already counted.

For the sample values, set Opening balance and Closing balance as totals. The other four values remain changes. If you add a Gross profit row after sales and returns, decide whether it is a subtotal that replaces the preceding detail for subsequent steps or merely a label. Including both detailed movements and a subtotal as ordinary changes would count the same amounts twice. A chart can display a subtotal and then continue with later movements, but the underlying numbers must be arranged so the running balance remains meaningful.

Use the category order to tell the story in the intended sequence. If Excel reverses or misreads the labels, open Chart Design > Select Data and check the category label range. Sorting the source rows alphabetically is usually inappropriate for a waterfall: chronology or calculation order often carries meaning. Keep the source list in the order the reader should follow.

Format colors, labels, and axes

Formatting should make the distinction between increases, decreases, and totals obvious without making the chart noisy. Excel’s built-in waterfall chart uses separate formatting for increases, decreases, and totals. Select the chart and use the Chart Design and Format tabs to adjust the chart style and appearance. To format a single bar, select that point and use the formatting options for the data point.

Consider these practical choices:

Use contrasting but readable colors for increases and decreases, and a distinct color for totals.
Add data labels when readers need exact amounts; retain an axis when readers need to judge relative size.
Use a title that states what the bridge measures and the period it covers.
Reduce unnecessary gridlines and avoid labels that overlap or run into one another.
Keep units consistent, such as dollars throughout, and format the vertical axis to show the same unit.

Data labels can be added from the chart’s Chart Elements button or through the chart ribbon options, depending on the displayed ribbon layout. Labels may show individual changes, but they do not automatically explain every business definition. If a negative amount represents a refund, for instance, the category label should say so. If the chart spans a wide range, check that the axis scale and number format remain legible; a misleadingly truncated axis can exaggerate small differences.

Common setup problems and how to fix them

The ending balance does not match expectations. Check the arithmetic and the sign of each change. A cost or refund that should reduce the balance needs a negative value. Also verify that a subtotal or endpoint has been set as a total; leaving a balance as an ordinary change can make the later bars appear to accumulate incorrectly.

A total floats instead of starting at zero. Select that individual bar, right-click, and choose Set as Total. If the option is missing, select the bar itself rather than the entire series, and make sure the chart is a native Excel waterfall chart rather than a picture or a different chart type.

Labels or values are missing. Check that the selected source range includes both columns and that category labels point to the names rather than the amounts. Use Chart Design > Select Data to review the range. Hidden rows, blank cells, or an accidental header selection can also make the displayed chart confusing.

Bars are too crowded. Combine minor movements into a sensible category, shorten long labels, or widen the chart. Do not combine items if doing so hides a material change the reader needs to understand. If there are many periods, separate the explanation into smaller charts rather than shrinking the text until it becomes unreadable.

The chart changes after editing the source. Excel charts typically reflect changes to cells in their source range. If you add rows outside the selected range, those rows may not appear. Update the data range through Chart Design > Select Data, or use an Excel table as the source when you expect the list to grow and want its range to expand with new rows.

Waterfall charts versus other chart types

Choose a waterfall when the reader needs to understand how sequential changes bridge one balance to another. Choose a regular column chart when the main task is comparing independent values, such as sales by region. A line chart is usually clearer for a continuous time series where the pattern over time matters more than the contribution of each individual movement.

A stacked column chart can show components that make up totals across categories, but it does not present a running bridge in the same way. A waterfall chart can make positive and negative contributions easy to follow, yet it depends on careful classification of totals and order. For a short explanation with only two or three values, a sentence or compact table may be clearer than a chart.

Excel versions and sharing the chart

The steps above target Excel for Microsoft 365 on Windows. Excel for Mac also includes waterfall charts, although ribbon placement and some formatting interactions can differ. If a command is not in the same place, look on the Insert, Chart Design, and Format tabs, or use the chart’s right-click menu for point-level options. Excel for the web may offer a different set of chart creation and formatting controls; for detailed formatting, open the workbook in the desktop app.

When sharing the workbook, keep the source values in the file and avoid sending only a screenshot if recipients may need to check or update the calculation. A chart can be copied into a presentation, but verify the colors, labels, and axis after pasting because its appearance can change with the destination theme. For a static report, include a short note defining what the opening balance and movements represent.

Frequently Asked Questions

How do I make a waterfall chart in Excel? Put category names and numeric changes in adjacent columns, select the range, and choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Then set opening, closing, and subtotal bars as totals when appropriate.

How do I make a bar start from zero in a waterfall chart? Select the individual bar, right-click, and choose Set as Total. This is appropriate for a balance or subtotal, not for an ordinary increase or decrease in the sequence.

Can a waterfall chart show negative values? Yes. Enter decreases as negative numbers in the source data. Excel displays them as downward changes from the current running level, subject to the chart’s formatting and axis scale.

Why does my waterfall chart end at the wrong number? Recalculate the opening balance plus all signed movements, check for duplicated subtotals, and confirm that the final balance is marked as a total. Also make sure every intended row is included in the chart’s data range.

Can I add a subtotal to an Excel waterfall chart? Yes. Add a row for the subtotal at the correct point in the sequence and set its bar as a total. Arrange later movements so they continue from that subtotal without counting the earlier detail a second time.

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.