Waterfall Chart Explained: How to Make, Read and Report It
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.
| Step | Change | Running total |
|---|---|---|
| Opening balance | 50,000 | |
| Supplementary funding | +12,000 | 62,000 |
| Equipment | −18,000 | 44,000 |
| Consumables | −9,500 | 34,500 |
| Travel | −6,000 | 28,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.
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
- No formal reference included. Add a verified data-visualisation source before publishing if you want to cite one.