Stacked Waterfall Chart Excel Template: A Setup Guide

Excel does not have a separate chart type called a stacked waterfall chart. To make one in Microsoft Excel for Microsoft 365 on Windows, build a helper table that splits each change into a hidden base and a visible increase or decrease, then plot those series as a stacked column chart. For a conventional financial bridge, Excel’s built-in Waterfall chart is often simpler; the stacked-column method is useful when you need more control over the chart’s series and appearance.

What a stacked waterfall chart shows

A waterfall chart explains how a starting amount changes through a sequence of additions and deductions to reach an ending amount. For example, a business might show how a starting balance of 100 becomes 140 after several changes. Unlike an ordinary column chart, each change bar appears to float from the previous running balance rather than from zero.

People use “stacked waterfall” in two related ways. They may mean a waterfall-style chart built from stacked columns, using an invisible series to position each change bar. Or they may want each step split into multiple colored components, such as sales gains from several product lines. The template below handles the first meaning: one net change per step. Multi-component versions need extra helper series and careful handling of positive and negative contributions.

When to use Excel’s built-in Waterfall chart

For a straightforward bridge with one value per step, try Excel’s native chart first. Select the category labels and values, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Excel creates a chart designed for running totals, and you can mark a column as a total by selecting it and using Set as Total in the chart’s formatting options. This is often easier to maintain than a custom stacked-column construction.

The built-in chart is not a stacked-column chart with several independently controlled component series. Choose the helper-table approach when you specifically need stacked-column formatting, need to control the base and contribution series, or are adapting a chart layout that relies on stacked columns. If your aim is only to show a bridge clearly, do not assume that adding the word “stacked” will make the standard Waterfall chart more accurate or easier to read.

Build the helper-table template

Set up these columns in a worksheet: A for Category, B for Signed change, C for Running balance, D for Base, E for Increase, F for Decrease, and G for Total. Enter this illustrative example:

Row 2: Opening balance, 100
Row 3: Online sales, 40
Row 4: Returns, -15
Row 5: Freight, -10
Row 6: Other adjustments, 25
Row 7: Closing balance, with B7 left blank

The arithmetic is 100 + 40 – 15 – 10 + 25 = 140, so the closing balance should be 140. In C2, enter =B2 to establish the opening running balance. With the layout above, enter =0 in D2, =0 in E2, =0 in F2, and =B2 in G2. These values make the opening balance appear as a total bar rather than a floating change.

For the first change row, row 3, enter =C2+B3 in C3 to calculate the new running balance. Enter =IF(B3<0,C3,C2) in D3 for the hidden base, =MAX(B3,0) in E3 for the increase, =MAX(-B3,0) in F3 for the decrease, and =0 in G3. Copy C3:G3 down through row 6. The resulting running balances are 100, 140, 125, 115, and 140. For a negative change, the base is the lower balance; for a positive change, it is the balance before the change.

For the closing total in row 7, enter =C6 in C7, =0 in D7, =0 in E7, =0 in F7, and =C7 in G7. The closing bar will therefore show 140. These formulas assume the opening balance is in B2, changes are in B3:B6, and the closing category is in row 7. If you add or remove change rows, extend the running-balance formulas and point the closing row at the last change’s balance.

Insert and format the stacked column chart

Use the category labels in A1:A7 and helper data in D1:G7 as the chart source. Because those ranges are not adjacent, select the first range and then add the second as a non-adjacent selection (Ctrl-select on Windows). If that selection is awkward in your workbook, create a contiguous chart-source block elsewhere with the category column followed by Base, Increase, Decrease, and Total, then chart that block.

Select the chart-source labels and four helper series, including their headings.
Choose Insert > Insert Column or Bar Chart > 2-D Stacked Column.
Confirm the series order is Base, Increase, Decrease, Total. Use Chart Design > Select Data if Excel has assigned the columns incorrectly.
Select the Base series, open Format Data Series, and set Fill to No fill. The series remains in the chart to position the visible bars, but its columns become transparent.
Give Increase and Decrease contrasting colors, and make Total easy to distinguish. Add data labels if the values need to be read without estimating from the axis.

On Windows, Ctrl is used to select non-adjacent ranges. On a Mac, use Command for non-adjacent selections; ribbon names and the Format Data Series pane may look slightly different, but the same chart construction applies. In Excel for the web, chart editing options can differ from the desktop application, so use desktop Excel if you cannot access the needed series formatting controls.

How to make the chart reusable

Turn the input range into an Excel Table with Insert > Table, keeping the headers. A table expands as rows are added, which helps keep input data organized; however, chart-source ranges and formulas should still be checked after adding new steps. For a reusable template, distinguish input cells from calculated helper columns using fill colors, and add a short note that negative amounts represent deductions.

Keep the closing total linked to the last running balance instead of typing the answer again. That prevents the chart from showing an old ending value after an input changes. If the number of steps varies often, make room for extra blank change rows in advance, or use a structured formula setup and verify the chart includes the intended rows. Save a clean copy as an Excel Template file (.xltx) if you want a starting workbook that can be reused without overwriting the original.

Common problems and limits

Bars start at zero: The Base series may still be visible. Set its fill to No fill rather than deleting the series; removing it destroys the floating effect.
Decreases point the wrong way: Enter deductions as negative numbers in the input column. The helper formula converts them to positive column heights while placing them at the lower balance.
The ending bar is wrong: Check that the final total refers to the last running balance, and confirm that each change is included once.
Totals look like changes: Opening and closing balances belong in the Total series, not the Increase or Decrease series.
The balance crosses below zero: This simple helper setup assumes nonnegative running balances. A negative balance can require separate positive and negative base logic; use Excel’s built-in Waterfall chart or design and validate a more advanced helper table for that case.

A common misconception is that the Base series is merely decorative. It carries the vertical position of every floating bar, so it must remain part of the stacked chart even though it is invisible. Another limitation is that this template gives each step one net increase or decrease. If a step must show, for example, separate positive contributions from three departments and a separate negative adjustment, build and validate additional series rather than treating one net amount as a true component breakdown.

Stacked columns versus a standard waterfall

The built-in Waterfall chart is usually the better choice for a clear bridge with one change per category: it is designed for running totals and offers a direct way to identify total columns. The stacked-column workaround can offer greater series-level styling control, but it relies on helper formulas and a transparent series. That makes it more sensitive to source-range mistakes and more work to maintain.

Use a regular stacked column chart instead when the purpose is to compare components that all share a common zero baseline, such as monthly sales by product. Use a waterfall when the purpose is to explain how sequential changes produce a final value. Use the custom method only when the floating bridge and stacked-column control are both important. A chart should clarify the calculation; if readers need a long explanation to understand what each color means, simplify the design or add a clear legend and labels.

Frequently Asked Questions

Does Excel have a stacked waterfall chart template?
Excel includes a Waterfall chart type, but not a separate built-in chart type named Stacked Waterfall. You can create the stacked-column version with helper series, or start from an existing workbook and save your finished setup as an .xltx template.

Can I download a stacked waterfall template from Excel?
Excel’s built-in chart command creates a chart from your selected data; it does not guarantee a ready-made stacked waterfall workbook. The helper-table layout and formulas above provide a practical template structure you can save and reuse.

How do I show a subtotal in a waterfall chart?
With Excel’s built-in Waterfall chart, select the column that should be a subtotal and use Set as Total in its formatting options. With the custom stacked-column method, put the subtotal value in the Total series and set the other plotted helper values for that row to zero.

Why are my waterfall bars not floating?
Usually the Base series was omitted, is not first in the stacked series order, or has not been made transparent. Check that the Base values place each bar at the prior or resulting balance as appropriate, and keep the series in the chart with No fill.

Can a stacked waterfall show positive and negative components in one step?
Yes, but the simple template above shows only a net change for each step. A component-level version needs additional helper series and a deliberate rule for where each positive or negative segment begins. Check its calculations against known running totals before relying on the chart.

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.