Waterfall Chart Maker

Show how a starting value changes through increases and decreases. Paste your steps, add calculated subtotals, and inspect the final result.

Free online tool

Create your waterfall chart

Local editing · Account saves upload data
Open / backups
My Charts

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.

Editable waterfall steps in calculation order
StepTypeValueActions
2. Customize
Subtitle, source and footnote

Plain text included in the preview and image exports. Long text wraps and reduces the plot's available space; keep notes brief and use a larger image for detailed captions. No text is sent to analytics.

Colour palette

Keep labels or legends visible; colours alone may not distinguish every series. Colours repeat for larger datasets.

Values: number formatting

Changes display only, including image exports. Exact values stay in the editor. Rounding can make different values look equal; increase decimal places when needed.

Value axis: limits and ticks (Auto)

Leave blank for Auto. Include zero to preserve the baseline of totals. Custom limits crop the view; running totals are always calculated from all entered steps.

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.

Waterfall chart. All input values are available in the data table below.

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.

Checking sign-in…

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
Waterfall steps in input order, with calculated running totals.
StepTypeValueRunning total
Starting valueStart100100
Product salesChange60160
ServicesChange30190
SubtotalSubtotal190190
OperationsChange-45145
MarketingChange-15130
TaxChange-20110
Final totalFinal total110110
Quick guide

How to make a waterfall chart

  1. Enter the opening amount. Give the first row a label, a value and the Start type.
  2. Add the changes in sequence. Positive changes increase the running total. Negative changes decrease it.
  3. Insert summary rows. Choose Subtotal for an intermediate result or Final total for the last row. Their values are calculated automatically.
  4. 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.

Related chart tools