Waterfall Chart Maker

Build a waterfall (bridge) chart with subtotals. Download PNG, SVG, PowerPoint or Excel. Free, no sign-up.

Your steps

These are example numbers. Replace them with your own steps.

Labels

Chart options
Bars run
Colors

Names the increase, decrease and total colors. Hide it only if your caption already explains them.

Text size

Large text suits slides and posters. On a phone the preview stays normal size, but downloads and copied images use large text.

Adds a unit to the bar labels and the axis, like $ before or kg after. Up to 6 characters.

Applies to the bar labels, the axis and the table. The CSV and Excel downloads keep the full numbers.

Leave these blank and the axis starts at 0 with even steps.

On a shared or school computer, uncheck this or clear your chart when you're done.

Hover over or tap a bar to see its value. From the keyboard, tab to the chart and use the arrow keys.

Written from your data. Edit it if you like, then copy it into your document or web page.

Show data table
On this page

How to use the waterfall chart maker

  1. List the steps. One row per step. The first row can be a starting total, like an opening balance.
  2. Type the changes. Increases are positive numbers and decreases are negative, like -950. You can paste two columns from a spreadsheet, with an optional third column that says Subtotal.
  3. Add subtotals. Tick Subtotal on a row to draw a total bar at that point, like gross profit. Leave the amount blank and the tool adds up the steps above it. If you type an amount, it checks your number and tells you if the steps add up to something different.
  4. Pick the totals. Keep the ending total bar to show where you finished. Connector lines help the eye follow the running total.
  5. Add a unit. Under Chart options, put $ before each value or a unit like kg after it. You can also show numbers in thousands or millions.
  6. Download. Save the chart as a PNG or SVG, or as a PowerPoint slide with editable shapes. Copy the table, or download the steps and running totals as a CSV or an Excel file with formulas.

Order matters here. Each bar starts where the last one ended, so moving a row moves every step after it. Use the arrow buttons on a row to move it.

What a waterfall chart shows

A waterfall chart, also called a bridge chart, shows how a starting total becomes an ending total one change at a time. It answers one question: how did we get from the first number to the last one? In the words of Microsoft Support, "the initial and the final value columns often start on the horizontal axis, while the intermediate values are floating columns." Each floating bar begins at the running total left by the bar before it.

With the example budget (example data), the balance starts at 1,200. The paycheck adds 1,800, bringing it to 3,000. Rent, groceries, bills and fun money then take away 1,620 between them, so the month ends at 1,380, a net change of +180. The chart makes it easy to see that rent is the biggest single drop.

Colors carry meaning here: increases, decreases and totals each get their own color, and the legend names them. Pick Patterns under Chart options if the chart will be printed in black and white.

When to use a waterfall chart

  • Budgets and bank balances: money in and money out over a month.
  • Profit breakdowns: revenue, then each cost, down to profit.
  • Changes in a count: students at the start of the year, plus new arrivals, minus moves, to the end-of-year total.
  • Explaining a gap: why this year's number differs from last year's, one reason per bar.

If you only need to compare separate amounts, a plain bar graph is easier to read. The bar graph maker handles that.

Making a waterfall chart in Excel instead

Excel 2016 and later, including Microsoft 365, have a built-in waterfall type. Microsoft's steps are:

  1. Select your data.
  2. Go to Insert, then Insert Waterfall.
  3. Pick Waterfall.

Recommended Charts, on the All Charts tab, lists it too. If your version doesn't have it, or you just need one chart for a report, this maker does the same job in the browser with nothing to install.

Related tools and guides

Frequently asked questions

What is a waterfall chart?

It's a bar chart that shows how a starting number turns into an ending number, one change at a time. Microsoft Support describes it as a chart that "shows a running total as values are added or subtracted." The first and last bars usually start at zero, and the bars in between float.

How do you read a waterfall chart?

Start at the left bar, then follow each floating bar. A bar that goes up adds to the total, and a bar that goes down takes away. Where each bar ends is the running total at that point, and the last bar shows the final total.

Why are the bars in a waterfall chart floating?

Each change starts where the last one finished, not at zero. That's what lets you see the running total and the size of every change on one chart.

Can a waterfall chart show negative totals?

Yes. If the running total drops below zero, the bars cross the zero line and the axis extends below it. The table shows the running total after each step so you can check it.

Is a waterfall chart the same as a stacked bar chart?

No. A stacked bar chart splits one total into parts. A waterfall chart shows how a total changes step by step. For parts of a whole, the stacked bar graph maker is the better fit.

How do I add a subtotal to a waterfall chart?

Tick Subtotal on the row where you want it. The tool draws a total bar from zero up to the running total at that point, like gross profit between the cost of goods and the operating costs, and the next change starts from that bar. Leave the amount blank and it adds up the steps above. If you type an amount, it checks your number against the steps and says so when they differ.

Can I put a waterfall chart in PowerPoint?

Yes. Use Download PowerPoint to get a slide where each bar, line and label is its own shape you can move and recolor. If you only need a picture, Download PNG or Copy image works too.

How this page is checked

Cedrick Reese built this waterfall chart maker on the same chart engine as the rest of BarGraphCreator. The running totals were recalculated separately from the tool's own code for the example budget and for edge cases: a total that drops below zero, all increases, all decreases, no starting total, decimal amounts, and subtotals, including a typed subtotal that doesn't match the steps. The PowerPoint and Excel downloads were opened in separate software (python-pptx, openpyxl and LibreOffice) to confirm the shapes, the formulas and the running totals, but not yet in Microsoft Office itself. The definition and the Excel steps come from Microsoft Support's waterfall chart article, which is rechecked when Excel's chart menus change.

Last updated: