Free Waterfall Chart Template for Excel (.xlsx Download)
Free Excel waterfall chart template with a ready-built P&L bridge. Native chart type, auto-expanding Table, no email gate. Download the .xlsx and edit.
Free Waterfall Chart Template for Excel (.xlsx Download)
Most free waterfall templates are one of two disappointments: a decade-old workbook built on the pre-2016 error-bar workaround, or a landing page that wants your email address before it wants to help you. This one is neither. It’s a clean .xlsx built on Excel’s native waterfall chart type, the input range is an auto-expanding Table, and the download link is right on this page — no gate, no signup.
Here’s what’s inside and how to use it. The download is at the bottom, after you know what you’re downloading.
What the Template Contains
The workbook has three sheets:
Bridge — a worked example: a profit-and-loss bridge walking from Revenue down to Operating Income. The data sits in an Excel Table on the left; the finished, formatted waterfall chart sits beside it. Increases are blue, decreases red, totals dark navy and grounded to the axis, connector lines and data labels on. It’s the chart you’d want to paste into a board deck, populated with example numbers.
| Category | Amount |
|---|---|
| Revenue | 842,000 |
| Cost of Goods Sold | -318,000 |
| Gross Profit | 524,000 |
| Salaries | -196,000 |
| Marketing | -84,000 |
| Overheads | -61,000 |
| Operating Income | 183,000 |
Instructions — the quick-start steps in plain text, so the guidance travels with the file when you send it to someone who never saw this page.
Blank Bridge — the same Table-and-chart pairing with placeholder categories and zero values. This is your working copy: type over the placeholders and the chart builds itself as you go.
Two structural choices matter more than the styling:
- The subtotal rows are formulas, not typed numbers. Gross Profit sums the rows above it; Operating Income sums everything. Change any input and the subtotals — and the chart — update instantly. Templates with hard-coded subtotals go quietly wrong the first time someone edits a number; this one can’t.
- The source range is an Excel Table. Add a row inside the Table and the chart picks it up automatically. No range editing, ever. If a chart of yours has ever ignored new data, that pain is exactly what this design prevents — the full diagnosis lives in Excel Chart Not Updating? 7 Fixes That Actually Work.
How to Use It
- Open the Blank Bridge sheet. Leave the worked example intact as a reference.
- Replace the category names in the first column with your own line items. Keep them short — “Q2 Marketing Spend” fits on an axis; a sentence doesn’t.
- Enter your values. Increases positive, decreases negative. The chart redraws with every entry.
- Add or delete rows inside the Table as needed. Right-click a row > Insert or Delete. The chart follows.
That’s genuinely all a standard bridge requires. Total time from download to presentable chart: under five minutes.
Customizing It
Adding your own subtotals. If you insert a new subtotal row (say, EBITDA), do two things: make its value a formula summing the relevant rows, then flag it on the chart — click the chart, click that column twice so it alone is selected, right-click, and tick Set as Total. Excel never infers totals; you declare them. This is the one step people forget, and it’s the difference between a bridge and a lie. The full explanation is in the waterfall chart tutorial.
Changing the colors. Click the legend, click one entry (Increase, Decrease, or Total), press Ctrl+1, pick a new fill. Resist the urge to get creative with the red/green semantics — your audience’s instincts about those colors are stronger than your branding guidelines.
Retitling and labeling. The chart title is a text box; click and type. Data labels are on by default — keep them. A waterfall without figures is decoration.
One warning. If you restructure the data significantly — sorting rows, deleting a subtotal, pasting a block over the Table — re-check that your total columns are still flagged. Set as Total flags belong to data points, and heavy restructuring can silently detach them. Thirty seconds of checking beats presenting a floating total to a CFO.
Why It’s Built on the Native Chart (and Why That Matters)
A surprising number of the waterfall templates ranking in search — including some from very reputable finance-education sites — still construct the chart the pre-2016 way: stacked columns with invisible spacer series, error bars for connectors, helper columns full of positioning formulas. Those builds were impressive engineering when they were necessary. In 2026 they’re technical debt you’re invited to download.
The practical difference shows up the first time you edit. In a legacy-build template, adding a category means extending four or five helper columns whose formulas you didn’t write, and one wrong fill-down produces a bridge that’s confidently wrong. In this template, adding a category means typing a label and a number into a Table row. The native chart does the geometry; there is no geometry for you to break.
The trade-off is version support: the native waterfall requires Excel 2016 or later. If you’re maintaining files for someone stranded on Excel 2013, the legacy construction is genuinely the right call — and the tutorial walks through it. For everyone else, simpler is safer.
Reading the Worked Example
The Bridge sheet’s sample numbers aren’t random — they demonstrate the three behaviors you’ll rely on:
- Revenue (842,000) and the two cost blocks show standard rises and falls, with the connector lines carrying the running total between them.
- Gross Profit and Operating Income are the flagged totals: grounded to the axis, navy, and formula-driven. Change Salaries to −250,000 and watch both the subtotal cell and its bar move together — that’s the formulas-not-values design earning its keep.
- The Marketing and Overheads rows are deliberately small relative to Salaries, so you can see how the chart handles bars of very different magnitude without any manual scaling.
Spend two minutes changing numbers on the worked example before touching the blank version. Watching the chart respond teaches the template’s logic faster than any instruction sheet — which is also why the sample data ships populated instead of zeroed.
Who This Template Is For
It’s for anyone who needs a bridge chart this afternoon: budget vs. actual walks, profit bridges, cash movements, headcount changes, pipeline value progression. It deliberately does one thing. If you’ve outgrown it — you need waterfalls inside combo charts, per-bar conditional formatting, or IBCS-compliant reporting styles — that’s the territory of paid charting add-ins, and we’ve tested which ones justify their price in Best Excel Chart Add-Ins. Most people never need them. Start free.
And if you’d rather understand the machine than just drive it, the companion tutorial builds this exact chart from a blank worksheet, modern method first, legacy method included: How to Make a Waterfall Chart in Excel.
Download the Template
The file is a standard .xlsx — no macros, no external links, nothing that will trip a corporate security filter. It requires Excel 2016 or later (the native waterfall chart doesn’t exist in older versions; the tutorial’s legacy method covers you there). It opens in Excel for Mac and Excel for Microsoft 365 without modification.
Use it, rebrand it, ship it inside your own reports. That’s what it’s for.