Stacked Waterfall Chart in Excel: How It Works

Excel does not offer a built-in stacked waterfall chart: its native Waterfall chart plots one series, not a stack of component contributions. To make a stacked version in Microsoft 365 for Windows, use a stacked column chart with a hidden base series, positive segment heights, and separate total bars; this works best when each step’s component changes all move in the same direction.

What a stacked waterfall chart shows

A waterfall chart explains how a starting value changes through a sequence of additions and deductions to reach an ending value. Its bars appear to float between cumulative levels rather than all starting at zero. A stacked waterfall adds another layer of information: the bar for a step is divided into colored segments that show which components make up that step’s change.

For example, a business might begin with a balance of 100, increase it by 30 from volume and 20 from price, then reduce it by 15 for materials and 5 for shipping. The final balance is 130. A conventional waterfall shows each change as a separate bar. A stacked version can combine the two increases into one upward step split into volume and price segments, and the two deductions into one downward step split into materials and shipping.

That distinction matters when choosing a chart. Use a regular waterfall if each cause needs its own sequential position. Use a stacked waterfall when you want fewer steps and need to show the composition of each step. It is a custom chart construction, so it requires more preparation and is less automatic than Excel’s native chart type.

How the Excel workaround works

A stacked column chart normally draws every column from the zero line. To make columns appear to float, add a first series that holds the lower edge of each column, then hide that series. The visible component series sit on top of this invisible base. For an increase, the base is the value before the increase; for a decrease, the base is the value after the decrease. The visible segments are positive heights, so they extend between the two cumulative values.

For a downward step, this means the component segments fill the space from the new, lower balance up to the old balance. The bar therefore shows the size and composition of the decline, while its position and connecting lines show that the balance fell. Make the decrease visually clear with a sign column, labels, or a consistent color convention; the segment heights themselves are plotted as positive magnitudes.

This design assumes that all components within a single step have the same sign. If one category includes both increases and decreases—for example, a positive price effect offset by a negative volume effect—an ordinary stacked column does not position those segments as a single sequential bridge. Split that step into separate movements, choose a regular waterfall, or use a more specialized chart design instead of implying a clean stack where the arithmetic does not support one.

Prepare a small example table

Set up the source data with a category column and one column for each component. In this example, A contains the step name, B contains volume, C contains price, and D contains costs or other effects. Row 2 is the opening total; rows 3 through 5 are changes; row 6 is the closing total. Enter 100 as the opening value in F2, then enter the component changes: row 3 has 30 and 20, row 4 has -15 and -5, and row 5 has 10 and 5. The balances should progress from 100 to 150, then 130, then 145.

Use E for the balance before each change, F for the balance after it, G for the hidden base, H for total bars, and I:K for the visible segment heights. Keep the opening and closing values in H, and leave their component cells blank. For changes, put the absolute size of each component in its corresponding segment column. Use blank cells rather than zeros for series that do not apply to a row, so the chart does not draw unnecessary zero-height points.

Opening: balance 100; no component segments.
Increase: volume +30 and price +20, taking the balance from 100 to 150.
Decrease: costs -15 and -5, taking the balance from 150 to 130.
Other increase: components +10 and +5, taking the balance from 130 to 145.
Closing: total 145; no component segments.

With the layout above, and with the starting value entered in F2, the formula in E3 for the balance before the first movement is =F2. It returns 100 in this example. Copy the same pattern down the movement rows, referring to the previous row’s ending balance: E4 refers to F3, and E5 refers to F4.

With component changes in B3:D3 and the starting balance in E3, the formula in F3 for the balance after the movement is =E3+SUM(B3:D3). It returns 150 because 100 + 30 + 20 + 0 = 150. Copy it down for the other movement rows; the corresponding ending balances are 130 and 145. Enter 0 in E2 and H2, and put 100 in H2 for the opening total. For the closing row, put 0 in G6 and the final balance, 145, in H6.

For the movement rows, the formula in G3 for the hidden base is =MIN(E3,F3). It returns 100, the lower endpoint of the first increase. Copy it down: the base for the decline is 130, and the base for the final increase is 130. With the volume changes in B3:B5, the formula in I3 for the first visible segment is =ABS(B3); it returns 30. Copy the absolute-value pattern across the component columns and down the movement rows. The price segment in J3 is 20, for example. Because all components in a movement have the same sign, their positive heights add up to the distance between the two balances.

Build the stacked column chart

After preparing the helper columns, select the category names in A2:A6 and the chart series in G2:K6. If the ranges are not adjacent in your worksheet, hold Ctrl while selecting the additional range on Windows. Then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Depending on the ribbon layout, the chart options may appear in the Insert tab’s column or bar chart menu.

Format the base series so it becomes invisible: select a base column, open Format Data Series, and set Fill to No fill and Border to No line. The visible component bars and total bars should now appear to float at their cumulative positions. Give the total series a distinct fill, and use a consistent color for each component series. Adjust Gap Width in Format Data Series to make the bars wider or narrower. Add a clear title, axis labels if useful, and data labels where the component values need to be read precisely.

A stacked column chart does not automatically draw the horizontal bridge connectors found in Excel’s native waterfall chart. If connectors are important, add them as chart shapes or use a separate helper series and a combo-chart design. Shapes are easy to add but may need repositioning when the chart changes; a helper series takes more setup. Do not rely on connectors if the chart will be frequently rebuilt without checking their alignment.

When to use Excel’s native Waterfall chart

For a standard bridge with one value per step, the built-in chart is simpler and usually preferable. Select the category labels and change values, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall. Excel plots the changes cumulatively. To mark a starting balance, ending balance, or subtotal as an anchored column, right-click that data point and choose Set as Total. The exact menu can vary slightly with the selected chart element and Excel build.

The native chart handles the basic cumulative positioning and connector lines without helper columns. It does not provide a native way to stack several component values inside each change bar. One practical alternative is to show the total change as the waterfall step and place a separate stacked bar chart beside it to explain the component breakdown. That keeps the bridge easy to read while preserving the detailed attribution.

Common problems and how to fix them

Bars start at zero: Check that the chart type is 2-D Stacked Column, the base series is included first, and the base series is set to No fill and No line. If the base is missing, the remaining columns cannot float at their intended levels.
A decrease looks like an increase: The helper bar uses positive segment heights by design. Confirm that its base is the lower endpoint, retain the sign in the source values, and label or color the category so readers can tell it is a decrease.
A bar has the wrong height: Check that the component values add to the net movement and have the same sign within that step. A 30 increase and a -10 decrease do not form a single 20-unit stacked movement under this method; show them as separate steps or use another design.
The total bars stack with the components: Keep total values in their own series and leave the component cells blank on opening and closing rows. Ensure the total series is included in the chart and formatted separately.
Labels or connectors no longer line up: Changes to category order, chart size, or data range can affect manual labels and shapes. Review them after editing, or use an adjacent breakdown chart that does not depend on manually positioned connectors.

For a quick diagnostic, verify the arithmetic in the worksheet before formatting the chart: each ending balance should equal the previous balance plus the signed component changes. Then check that the base is the smaller endpoint and the visible segment heights sum to the absolute net change. These checks catch most errors before they become hard-to-spot visual problems.

Choosing a clear chart design

A stacked waterfall can become difficult to interpret when it contains many steps, many component colors, or mixed positive and negative effects. Keep the component categories consistent across the chart, use a restrained palette, and explain the colors with a legend. Label the opening and closing totals plainly. If the audience must compare exact values, include data labels or a nearby table rather than expecting viewers to estimate small differences from column heights.

Consider whether a single step should really combine several causes. Stacking makes the components’ contribution to one net movement visible, but it does not show an order among those components. If order matters—for example, if each stage changes the balance before the next stage is applied—plot the causes as separate waterfall steps. A stacked bar chart placed beside a conventional waterfall is often clearer than forcing both questions into one graphic.

Frequently Asked Questions

Can Excel make a stacked waterfall chart automatically?
No. Excel’s built-in Waterfall chart supports a single series and does not stack multiple component series within each step. A floating stacked column chart with a hidden base is a common workaround, but it needs helper data and more manual formatting.

Can I show both increases and decreases in one stacked step?
Not reliably with the simple hidden-base method described here. It works when all components in a step move in the same direction. Separate mixed-sign effects into individual steps or show their breakdown in a separate chart.

How do I make a stacked column float in Excel?
Add a base series equal to the lower endpoint of each movement, place the component heights above it, and format the base series with No fill and No line. Use separate total bars for the opening and closing balances.

Does the method work in Excel for Mac?
The underlying stacked-column workaround is also available in Excel for Mac, although ribbon placement and some formatting dialogs can differ by version. The instructions here use Microsoft 365 for Windows. Excel for the web may have different chart-formatting options, so some manual formatting steps may be less convenient.

What is the difference between a waterfall and a stacked waterfall?
A conventional waterfall gives each change its own step in a running total. A stacked waterfall groups the components of a change into one bar, using colored segments to show the breakdown. Excel supports the conventional version directly, but the stacked version requires a workaround.

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.