Excel Waterfall Charts: How Stacked Bars Build the Bridge

Yes—an Excel waterfall chart uses columns that appear to float or stack between levels, showing how positive and negative changes move a running total. In Microsoft Excel for Microsoft 365 on Windows, create one with Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall; mark opening and closing balances as totals so they sit on the baseline.

What “stacked bars” means in a waterfall chart

A waterfall chart explains how a starting amount changes through a sequence of additions and deductions to reach an ending amount. The bars are usually called columns in Excel because they rise vertically, though people often call them bars. Each change column starts at the previous running total and ends at the new total. That placement makes the columns look as if they are suspended above the axis or stacked along an invisible staircase.

For example, a business might begin with cash of $100, add $60 in sales, subtract $25 in costs, and subtract $10 in taxes. The closing amount is $125. The sales column spans from $100 to $160; the costs column drops from $160 to $135; taxes take the level down to $125. Unlike an ordinary column chart, the change bars do not all start at zero.

Excel has a dedicated Waterfall chart type. It calculates the running levels from the ordered values in your source data; you do not have to build a conventional stacked chart with invisible helper series just to make the columns float. The stacked-bar description is useful for understanding the appearance, but it is not the chart type to choose from Excel’s menu.

How to create one in Excel

Arrange the categories in one column and the changes in the next, with one row per step. Use positive values for increases and negative values for decreases. For the example above, the rows would be Starting cash, 100; Sales, 60; Costs, -25; Taxes, -10; and Ending cash, 125. Select the category and value cells, including their headings if present.

Choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Waterfall.
Check that the categories appear in the intended order and that the increases and decreases move in the right direction.
Right-click the Starting cash column and choose Set as Total. Repeat for Ending cash.
Add a chart title and, if useful, data labels using the Chart Design and Chart Format tabs or the chart’s plus button.

The exact chart-insertion button can be displayed as a small chart icon on a narrow ribbon, but its menu includes Waterfall. In Excel for Mac, use the Insert tab and select the Waterfall chart option; the ribbon layout can differ by build. The key step is the same on supported desktop versions: identify the opening and closing balance columns and set each as a total.

Why the first and last bars need special treatment

Excel treats ordinary rows as changes to the running balance. It does not automatically know that a value such as 100 is the initial balance rather than an increase of 100 from zero. If you leave the opening balance as a regular change, later levels can still be arithmetically consistent, but the display may not communicate the intended beginning point. Set that column as a total to anchor it to the horizontal axis.

The same distinction applies to a final balance. In the example, the closing amount of 125 is the result of the preceding steps, not another increase of 125. Marking it as a total makes it a full column from zero to 125 instead of a floating change. For the arithmetic, 100 + 60 – 25 – 10 = 125. The displayed ending total should match that result; if it does not, check the source values and category order.

A subtotal in the middle of a chart can also be marked as a total. This is useful when a report moves through sections—for example, revenue changes followed by expenses, then a profit subtotal, then further adjustments. A total resets the column to the baseline while leaving subsequent changes able to continue from that level.

How Excel calculates the floating columns

Excel reads the data in row order and accumulates each change. In the example, the opening total is 100; after sales the running level is 160; after costs it is 135; after taxes it is 125. Each intermediate bar visually connects the prior level to the new level. A positive change extends upward from the prior level, while a negative change extends downward.

This is why order matters. The same values in a different sequence can produce a different story, even if their sum is unchanged. A waterfall chart is not simply sorting values by size or showing independent category totals. It depicts a sequence of contributions, so arrange rows in the business or process order you want readers to follow. If the chart is intended to explain a bridge between two periods, label the steps with the actual drivers—such as price, volume, payroll, or exchange-rate effects—rather than vague labels like “Item 1.”

The chart’s total columns and change columns communicate different roles. In many Excel themes, increases, decreases, and totals use separate colors. Those colors help readers scan the bridge, but the chart should still have clear labels because colors alone may be inaccessible or ambiguous in a printout.

When a waterfall chart is the right choice

Choose a waterfall when the central question is “How did this starting value become this ending value?” Common examples include a profit bridge from last year to this year, a project budget moving through additions and overruns, inventory changes, headcount movement, or a cash balance adjusted by transactions. It is especially effective when readers need to see which steps raise or lower the total.

It is less suitable when categories are independent amounts with no meaningful cumulative sequence. To compare sales by product, for instance, a standard column or bar chart is generally clearer: each product’s value is a separate result rather than a step in a running balance. A line chart may be better for a value measured continuously over time, while a stacked chart can compare how component parts make up totals across groups.

Use a waterfall for sequential contributions to a beginning-to-ending result.
Use a regular column chart for independent values compared from a common zero baseline.
Use a stacked column chart when each category is made up of component series and the component totals matter.

Waterfall versus an ordinary stacked column chart

An ordinary stacked column chart plots multiple series within each category. The second series is placed above the first, the third above the second, and so on. Those stacks show composition: for example, how several departments contribute to each month’s total. The segments are not automatically interpreted as sequential increases and decreases to one running balance.

A waterfall chart instead treats each row as a change in sequence, with the next step beginning at the cumulative level left by the previous one. Its floating columns may look like stacked segments, but a conventional stacked chart will not reproduce the same behavior simply by selecting “Stacked Column.” You would have to construct helper series and manage positive and negative movements, labels, and totals manually. That workaround can be appropriate for unusual formatting requirements, but it is more fragile and harder to update than the native chart.

There is also a practical terminology distinction: Excel’s built-in chart is called Waterfall, not “stacked bar waterfall.” If you are searching the ribbon, look for Waterfall under the chart insertion menu rather than looking for a special stacked-bar subtype.

Formatting and reading the chart well

Keep category names short enough to read, but specific enough to explain the movement. If there are many steps, group minor drivers into a clearly named “Other” category rather than squeezing dozens of labels into a small chart. Put the opening and ending totals at the ends of the sequence, and make any intermediate subtotal visually and verbally clear.

Data labels can show the size of each change, while the vertical axis shows the cumulative levels. These are not the same thing: a label of -25 means the step reduced the balance by 25, while the top or bottom of the floating bar indicates the resulting cumulative level. If labels collide, enlarge the chart, reduce the number of displayed decimals, or label only the most important steps. Avoid shrinking the font until the chart becomes difficult to read.

Use contrast that remains legible in grayscale and for readers with color-vision differences. If the chart colors are not easy to distinguish, select the chart and use Chart Design > Change Colors, then check the result against the background and labels. A descriptive title such as “Change in operating profit, 2025 to 2026” is more informative than “Waterfall chart.” Include units—dollars, thousands of dollars, or units—when the axis or labels do not make them obvious.

Common problems and how to fix them

The start or end floats: Right-click the relevant column and choose Set as Total. Confirm the total is intended to be an anchor, not another change.
A decrease rises instead of falling: Check that the source value is negative and that it is in the correct row. A text value that looks like a number may also need to be converted to a numeric value.
The final balance is wrong: Recalculate the opening value plus all increases and decreases. Check for omitted rows, duplicate entries, or a subtotal accidentally included as a change.
The chart tells the wrong story: Verify row order. Waterfall charts follow the source sequence, and reordering steps changes the path.
Labels are confusing: Explain whether labels show change amounts or cumulative totals. Use a clear title and units, and do not rely on color as the only signal.

When source data changes, Excel updates the chart from its source range. If you add new categories below a fixed source range, the chart may not include them automatically. Consider placing the data in an Excel table before inserting the chart so that adding rows to the table can extend its data range. Review the chart after changes, especially the total markers: a newly added opening, closing, or subtotal row may need to be set as a total explicitly.

Alternatives when the built-in chart is not enough

For most financial and operational bridges, the native Waterfall chart is the simplest option. A manually assembled floating-column chart can give more control over spacing, connectors, or a custom layout, but it requires helper data and careful maintenance. It is easier to introduce errors, especially when negative values, changing row counts, or subtotals are involved. Keep a clear separation between source figures and any helper calculations if you build that kind of chart.

If the audience needs to compare several bridges side by side, consider whether small separate charts or a table of drivers would be clearer than a single crowded waterfall. If the audience mainly needs the final amount and not the sequence of causes, a simple column, bar, or KPI display may communicate more directly. The right alternative depends on whether the story is cumulative movement, composition, trend, or comparison.

Frequently Asked Questions

Are waterfall charts made from stacked bars in Excel?
Not in the usual sense. Excel’s dedicated Waterfall chart uses floating columns to show cumulative changes. A regular stacked column chart is a different chart type and does not automatically calculate the running balance.

How do I make the first and last bars touch zero?
Right-click each relevant column in the chart and choose Set as Total. This anchors the opening and ending values to the baseline; repeat the action for any subtotal that should also appear as a full total.

Can a waterfall chart show negative numbers?
Yes. Enter decreases as negative numeric values. Excel displays each decrease as a downward step from the current cumulative level, provided the source cell contains a true number and the chart’s row order is correct.

Why does my waterfall chart show the wrong ending amount?
Check that the opening amount and all intervening changes add to the intended ending amount, and make sure a final balance or subtotal has not been included again as a change. Also verify that every source row is included in the chart range.

Can I use an ordinary stacked column chart instead?
Only if you specifically want to show component parts within categories. For a beginning-to-ending bridge, use the Waterfall chart type; recreating its floating steps with a stacked chart requires extra helper data and is more difficult to maintain.

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.