Waterfall Chart Maker
Show how a series of gains and losses build up to a final number - free, no signup.
What this tool does
Enter one row per line as label, value - positive for a gain, negative for a loss - and this draws a waterfall chart: each bar floats from where the running total left off, stepping up for a positive value and down for a negative one. Name a row 'Total' (or 'Ending ...') and it draws as a full bar from zero instead of a step, so you can show a subtotal or grand total partway through the sequence.
Draws a waterfall chart from signed values you paste or type - each bar starts where the running total left off, so gains and losses are visible as steps.
Colours gains and losses differently by default, and draws a labelled 'Total' row as a full bar from zero rather than another step.
Connects each bar to the next with a guide line, so the running total is easy to trace visually.
How to use it
- Enter one row per line as label, value - use a negative number for a decrease.
- Name any row 'Total', 'Subtotal', 'End' or 'Balance' to draw it as an absolute bar instead of a step.
- Add a Y-axis label and title if you want them, then export as PNG or SVG.
Why use this chart maker
Waterfall charts explain how a start value becomes an end value through gains and losses, as in budgets and profit bridges.
Why we built it
We built the waterfall chart maker to draw rows labelled Total, Subtotal, End or Balance as absolute bars. Compute the numbers with the percentage calculator and the profit margin calculator.
If your task goes further, try the Funnel Chart Maker and the Gantt Chart Maker.
Who this tool is for
- Finance staff showing how a total is built
- Analysts explaining changes in revenue or cost
- Students
When to use it
- Profit and loss bridges.
- Budget changes.
- Explaining headcount or revenue movement.
- Financial reports.
What a waterfall chart is for
Showing HOW a total was reached, not just the total itself.
A waterfall chart is built for explaining change: a starting cash balance moving through sales, costs and refunds to an ending balance, or a revenue figure being reduced step by step by costs to arrive at a net profit. Each bar floats between where the running total was and where it ends up after that step, so the chart reads as a visual explanation of a calculation rather than just a set of unrelated bars.
It answers a different question than a bar or line chart: not 'how big is each thing' but 'how did we get from the start to the end, and which steps mattered most'. A single very large or very small step stands out immediately because of its size, in a way a plain table of numbers doesn't communicate as quickly.
How the 'Total' convention works
Most rows are treated as a step: the bar starts at the current running total and moves up or down by that row's value. But a row whose label contains the word 'Total', 'Subtotal', 'End' or 'Balance' (in any case) is treated differently - it draws as a complete bar from zero, representing an absolute checkpoint rather than another step in the sequence. This is the standard convention used by spreadsheet waterfall charts, and it lets you show a subtotal partway through a long sequence without breaking the flow.
What you give it, and what you get back
| Item | Details |
|---|---|
| Input | Signed values per step; a row named Total marks a checkpoint. |
| Output | A waterfall with gains and losses coloured differently. |
| Export | Save the chart. |
Issues you may run into
| What you see | Why it happens | What to do |
|---|---|---|
| A row is treated as a total | Its label contains total, subtotal, end or balance. | Rename the row. |
| Totals do not match | Steps do not add up to the total shown. | Check the values. |
| A row is skipped | It does not match the expected format. | Check the message listing unreadable lines and fix them. |
Assumptions and limitations
- The 'Total' convention is triggered by the words total, subtotal, end or balance appearing anywhere in a row's label - rename a row if it happens to contain one of those words but shouldn't be treated as an absolute checkpoint.
- This shows the running total working correctly for any sequence of numbers; it does not validate that your figures are accounting-correct or that they actually sum to a real total.
- The chart is drawn as SVG and exported to PNG at a fixed resolution suited to slides and documents, not large-format print.
Frequently asked questions
How do I make a waterfall chart online for free?
Enter one row per line as label, value - negative for a decrease - and the chart draws instantly, stepping each bar from the running total. Download it as a PNG or SVG with no signup and no watermark.
What is a waterfall chart used for?
It shows how a series of gains and losses build up to (or wear down) a final number - a cash flow statement, a profit build-up, or any sequence of additions and subtractions from a starting point.
How do I show a subtotal in the middle of the chart?
Name that row 'Total', 'Subtotal', 'End' or 'Balance' (anywhere in the label, any case) and it draws as a complete bar from zero instead of a step from the running total.
How do negative values work?
A negative value steps the bar down from the current running total, coloured differently from a positive step by default, so gains and losses are visually distinct at a glance.
Can I paste data from Excel or Google Sheets?
Yes - as long as each row has a label and a signed value separated by a comma or tab, a straight paste works.
Is my data uploaded anywhere?
No. The chart is drawn entirely in your browser using the data you type or paste - nothing is sent to a server, and closing the tab clears it.