Stacked Column Waterfall Chart in Excel: How It Works

Yes—you can make a stacked column waterfall chart in Excel, but Excel does not offer a chart type with that exact name. For a standard bridge, use Excel’s built-in Waterfall chart; for a stacked-column version, prepare helper series and plot them as a stacked column chart.

What a stacked column 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 revenue, costs, and other adjustments move a beginning balance to a closing balance. The intermediate columns appear to float at the running total rather than all starting at zero.

“Stacked column waterfall” usually describes a way to construct that visual from a regular stacked column chart. One invisible series lifts each visible change segment to its correct running-total position. Other series display increases, decreases, and any full-length total columns. The result resembles a waterfall, even though the underlying chart type is stacked column.

This is different from an ordinary stacked column chart, where each category’s series build upward from the axis to compare component totals. In a waterfall, the important story is the movement between balances. That distinction matters when you choose the chart or explain what the bars mean.

Use Excel’s built-in Waterfall chart when possible

Microsoft 365 for Windows includes a native Waterfall chart, so a custom stacked-column construction is not necessary for most simple bridges. Put the opening amount, each change, and the closing amount in one list. Select the category and value cells, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall.

The native chart treats entries as changes by default. To make the opening and closing bars represent complete balances, select each total bar, right-click it, and choose Set as Total. This tells Excel not to add that value to the preceding running balance. Check both endpoints: a closing balance displayed as another change is a common source of a misleading chart.

The built-in chart is generally easier to maintain because Excel handles the floating columns and change categories for you. It is a good first choice for a financial bridge, project variance, inventory movement, or other sequence of additions and subtractions. Use the custom method below when you specifically need stacked-column styling, more control over the series, or a chart layout the native type cannot provide.

Prepare helper data for a stacked-column version

This worked example starts at 100, adds 30 for sales, subtracts 15 for costs, adds 10 for another adjustment, and ends at 125. Enter the categories in A2:A6 and the amounts in B2:B6: Opening, Sales, Costs, Other, and Closing. Enter 100 in B2, 30 in B3, -15 in B4, and 10 in B5. The closing amount is the sum of the opening amount and the changes.

Add five helper columns with these headings: Running balance in C, Base in D, Increase in E, Decrease in F, and Total in G. These series separate the visible change segments from the invisible columns that position them. Put the opening amount in the Total series on the opening row, and put the closing amount there on the closing row. Use zero for the other helper values on those two rows.

With the opening amount and changes in B2:B5, enter the closing formula in B6: =SUM(B2:B5). The example returns 125.
With B2 holding the opening amount and B3:B5 holding the changes, enter =B2 in C2. In C3, enter =C2+B3 and fill it down through C5. The running balances are 100, 130, 115, and 125.
With each change in column B and the prior and current balances in columns C, enter =IF(B3>=0,C2,C3) in D3 and fill it down through D5. This puts the base at the prior balance for an increase and at the new balance for a decrease.
With changes in B3:B5, enter =MAX(B3,0) in E3 and fill it down through E5. The increase series returns 30, 0, and 10.
With changes in B3:B5, enter =MAX(-B3,0) in F3 and fill it down through F5. The decrease series returns 0, 15, and 0.

For the opening and closing rows, set D, E, and F to zero. Set G2 to =B2 and G6 to =B6; set G3:G5 to zero. This gives the total series full-height columns only at the endpoints. In the example, the negative change is stored as a positive segment height in the Decrease series. Its base is the lower, post-decrease balance, so the segment visually spans from 115 to 130.

Insert and format the custom chart

Select the category labels in A2:A6 and the five helper series in C2:G6. If the ranges are not adjacent in your worksheet, select one range and use Ctrl while selecting the others on Windows. Then insert the chart with Insert > Insert Column or Bar Chart > 2-D Column > Stacked Column. Check the legend and category order; if Excel plots the categories as series, use Chart Design > Switch Row/Column.

Make the Base series invisible so the remaining series appear to float. Select a Base segment, open the Format Data Series pane, and under Fill & Line choose Fill > No fill and Border > No line. Keep the Increase, Decrease, and Total series visible. Give increases and decreases distinct colors, while using a separate, consistent color for the opening and closing totals.

Adjust the gap width if the columns look too thin or crowded. Add a descriptive chart title and, if useful, data labels. Be aware that labels on the Increase and Decrease series show the size of each change, not the cumulative balance at the end of that step. If readers need the running balance, provide it in a nearby table or add carefully chosen labels rather than assuming the segment labels communicate it.

On Mac, the ribbon chart commands are broadly similar, although the precise interface can vary by Excel release. The Windows Ctrl-based selection shortcut differs on Mac, where Command is commonly used for selecting nonadjacent ranges. If selecting several ranges is awkward, place the chart data in a contiguous helper table and select that table instead.

How to choose between native and custom charts

Choose the native Waterfall chart when the purpose is simply to show a sequence of changes and totals. It needs less helper data, is easier for another person to audit, and is less vulnerable to a broken base calculation when amounts change. Remember to set total bars explicitly. A chart can look plausible while presenting the closing balance as an additional movement if that step is missed.

Choose the stacked-column construction when a specific design requires it, or when you need to coordinate the waterfall segments with other stacked series. It offers hands-on control over series formatting and can be useful in a report template that relies on stacked-column charts. The trade-off is that the helper table is part of the chart logic: reviewers should be able to see or inspect it, not just the polished chart.

Use a native Waterfall chart for a straightforward bridge with increases, decreases, and one or more totals.
Use a custom stacked column when you need custom series behavior or a design requirement that the native chart cannot meet.
Use a regular column or line chart when the main goal is to compare values across periods rather than explain how changes build to a total.

Common problems and how to fix them

If every bar starts at zero, the Base series may not be included, or it may not be plotted as the first positioning series. If the floating segments are hidden, confirm that only the Base series has no fill and no line. Also verify that the chart is a Stacked Column chart, not a clustered column chart; clustered columns do not build the helper series on top of one another.

If a decrease points the wrong way or sits at the wrong height, check the helper logic. In this method, the decrease amount is a positive height in the Decrease series, while the Base is the balance after the decrease. Entering the change itself as a negative height will not create the intended floating segment in this layout. For a decrease of 15 from 130, the visible segment should occupy the range from 115 to 130.

If the ending total is wrong, check the signs in the source changes and confirm that the closing formula includes the opening amount and every change exactly once. In the example, 100 + 30 – 15 + 10 equals 125. If source data changes, extend formulas and the chart’s data range to include new categories; otherwise the chart may continue to show an old result.

This helper setup assumes the running balances remain at or above zero. When balances cross below zero, a positive-height stacked-column construction can become confusing because the visual positioning and axis crossing need additional handling. For negative balances, use the native Waterfall chart or redesign and test the helper layout carefully rather than assuming the simple positive-balance method will remain clear.

Keep the chart understandable and maintainable

Waterfall charts work best when categories are ordered to match the calculation and labels are concise. Grouping several small adjustments into a clearly named “Other” category can help, but do not hide a material change that readers need to evaluate. Keep the source amounts and helper calculations in the workbook, and label the units—dollars, units, hours, or another measure—so the scale is not ambiguous.

For a recurring report, turn the source range into an Excel table with Insert > Table so new rows can be easier to manage. However, a table does not automatically guarantee that every chart range or custom helper formula will expand exactly as intended. After adding categories, confirm the chart includes them and that each running balance, base, and change series is populated. A quick reconciliation of opening balance plus all changes to closing balance is a useful quality check.

Frequently Asked Questions

Does Excel have a stacked column waterfall chart type?
Not as a named built-in chart type. Excel has a native Waterfall chart, and you can build a waterfall-like visual with a regular Stacked Column chart by using helper series.

How do I make a total bar in Excel’s Waterfall chart?
Select the bar that represents the total, right-click it, and choose Set as Total. Do this for the opening or closing balance as needed, then check that the chart shows the intended cumulative result.

Why do I need a Base series?
The Base series creates the invisible height that positions each change above the axis at its running-balance level. Without it, the visible increase and decrease columns begin at zero instead of floating between balances.

Can I use negative numbers for decreases in the custom chart?
Keep the original negative change in the source data, but use a positive segment height in the custom Decrease helper series. Set that segment’s Base to the post-decrease balance. This is how the example displays a decrease from 130 to 115.

Which chart should I use for a simple financial bridge?
Start with Excel’s native Waterfall chart. It is more direct for a sequence of changes and totals. Use a custom stacked-column version only when you need its additional formatting control or a specific chart design.

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.