Waterfall Chart Explained: How to Make, Read and Report It

By Dr. Faheem Afzal Shah, Founder, StatFAS.com · Tool: Waterfall Chart Generator

A waterfall chart shows how an initial value is increased and decreased by a sequence of contributions to reach a final value. In research it is useful for budgets, effect decomposition, sample flow and any running total.

What it is

Each bar floats from the running total before the step to the running total after it. Increases and decreases are usually coloured differently, and the first and last bars represent the start and end totals. The principle is a cumulative sum: Totalafter = Totalbefore + Δi.

Original example (illustrative)

A grant account starts with 50,000, receives a 12,000 supplement, and has three expenses.

StepChangeRunning total
Opening balance50,000
Supplementary funding+12,00062,000
Equipment−18,00044,000
Consumables−9,50034,500
Travel−6,00028,500

The closing balance is 28,500, which equals 50,000 + 12,000 − 18,000 − 9,500 − 6,000. The chart makes it clear that equipment is the largest single drain.

How to make it in StatFAS

Open the Waterfall Chart Generator. Provide a label column and a signed change column.

Reading and reporting

Check the starting and ending totals first, then the largest steps. State units and the order of steps, because order affects the visual floats but not the final total. A caption could read: Figure 1. Changes in grant balance across funding and expenditure categories. A waterfall chart is descriptive and carries no inference.

Common mistakes and alternatives

Omitting the total bars, mixing units, truncating the axis, presenting steps in an arbitrary order without explanation, and using it for non-additive quantities (such as percentages that do not sum). Alternatives include stacked bars, tables, and bar charts of the changes. For basic summaries see descriptive statistics and charts.

Conclusion

Use a waterfall chart when the point is how components add up to a final value, and keep it to additive quantities.

Screenshots to supply (genuine captures only):
1. statfas-waterfall-chart-interface.png, alt: "StatFAS Waterfall Chart Generator interface"
2. statfas-waterfall-chart-example-data.png, alt: "Example data entered in the StatFAS Waterfall Chart Generator"
3. statfas-waterfall-chart-settings.png, alt: "Waterfall Chart Generator settings in StatFAS"
4. statfas-waterfall-chart-result.png, alt: "Waterfall Chart Generator result generated in StatFAS"

References