Waterfall Chart Maker
Show how a starting value changes through increases and decreases. Paste your steps, add calculated subtotals, and inspect the final result.
Create your waterfall chart
Create and download without an account · Device saves and project files are in Open / backups
1. Enter data
Or drop one file here. Up to 2 MB; nothing is uploaded to a server.
Use Label, Value and an optional Type column. Types are start, change, subtotal and total. Leave summary values blank. With two columns, the first value is the start and the rest are signed changes.
Start sets the opening value. Change adds a positive or negative amount. Subtotal and Final total show the calculated running total without adding it again.
| Step | Type | Value | Actions |
|---|---|---|---|
Preview
8 steps · Final running total 110
Steps stay in input order. Subtotal and total columns start at zero; change columns float between consecutive totals.
Hover over a mark for details. Click or tap to pin. Use this selector for keyboard access, small shapes, zero and missing values. Escape closes details. The data table is available below. Downloads exclude the details card.
Applies to PNG and SVG downloads. Dark labels work best on light backgrounds. The preview checkerboard is not exported.
Applies to PNG and SVG downloads. The waterfall layout reserves space for step labels. The preview and downloads use the same proportions. SVG stays sharp when resized; some editors may substitute fonts.
Accessible data table
| Step | Type | Value | Running total |
|---|---|---|---|
| Starting value | Start | 100 | 100 |
| Product sales | Change | 60 | 160 |
| Services | Change | 30 | 190 |
| Subtotal | Subtotal | 190 | 190 |
| Operations | Change | -45 | 145 |
| Marketing | Change | -15 | 130 |
| Tax | Change | -20 | 110 |
| Final total | Final total | 110 | 110 |
How to make a waterfall chart
- Enter the opening amount. Give the first row a label, a value and the Start type.
- Add the changes in sequence. Positive changes increase the running total. Negative changes decrease it.
- Insert summary rows. Choose Subtotal for an intermediate result or Final total for the last row. Their values are calculated automatically.
- Check and download. Inspect the exact changes and running totals, label the units, and download a PNG or SVG.
What is a waterfall chart?
A waterfall chart, also called a bridge or cascade chart, explains how a sequence of changes turns an opening amount into a closing amount. Each change column floats between the running total before and after that step. Its height represents the size of that individual change.
Starting values, subtotals and the final total are anchored at zero. Connector lines help trace the cumulative balance between steps. The chart can explain a budget, inventory movements, staffing changes or any other additive sequence measured in one consistent unit.
Reading the changes and totals
In the example, 100 + 60 + 30 gives an intermediate total of 190. The subtotal row displays 190 without adding it again. The later changes subtract 45, 15 and 20, leaving a final total of 110.
The sales column represents a change of 60, even though its upper edge reaches a running total of 160. Hover, tap or use the keyboard selector to distinguish the step’s change from the cumulative total. The accessible table shows both.
Preparing waterfall data
Use a decimal point for fractional values and keep currency symbols or unit names in the axis label. For example, enter −12.5 as a change and use “Thousands of euros” as the value-axis label. Leave subtotal and total input cells blank so they can recalculate after earlier edits.
A two-column import uses its first value as the opening amount and treats all later values as changes. If your source contains cumulative balances, calculate the differences first. For percentage data, use additive percentage-point changes only when they have the meaning you intend. Compounded percentage growth requires a different calculation.
Waterfall chart or ordinary column chart?
Choose a waterfall when each row changes the result of the rows before it. Use a column chart to compare independent category values from a common baseline. A line graph shows how recorded values develop over time. A bar graph is useful for comparing categories with longer names.
Keep steps in a meaningful order and include units. Custom axis limits change the visible view while preserving all calculations and input values. The zero baseline stays included, and cropped columns are identified in the tool.
Frequently asked questions
How are subtotals and the final total calculated?
A subtotal shows the running total of the preceding start and change rows. It is drawn from zero and does not add that amount again or reset the running calculation. The final total uses the same calculation and belongs at the end.
What data format should I paste?
Use Label, Value and an optional Type column. Type accepts start, change, subtotal or total. Leave Value blank for subtotal and total rows. Without a Type column, the first row is the starting value and later rows are changes. Import adds a calculated final-total row if one is missing.
Can a waterfall chart cross zero?
Yes. Starting values and changes can be negative, positive or zero. A negative change subtracts from the running total, including when it moves the total below zero. The value axis includes zero so summary columns have a meaningful baseline.
Can I enter running balances instead of changes?
This version expects a starting value followed by signed changes. Convert later balances to differences from the preceding balance before importing. For example, balances of 100, 130 and 120 become a start of 100, a change of 30 and a change of −10.
What happens if I change an earlier value?
All later floating columns, subtotals and the final total recalculate. Step order is preserved because it determines the cumulative result. An invalid value pauses chart downloads and publishing until it is corrected.