Learn how to create a waterfall chart in Excel for budget tracking, variance analysis, and project reporting with this step-by-step guide.
06 May 2026
Taro
TL;DR: Most waterfall chart tutorials stop at inserting the chart type. This one shows you how to build one in Excel, how to read it against project budget variance and sprint cost data, and exactly where Excel's manual update cycle creates risk for IT teams managing live projects.
A waterfall chart is a bar chart that shows how a starting value rises or falls through a series of incremental steps to reach a final total. Unlike a standard bar chart, most bars appear to float rather than start at zero. Each bar begins where the previous one ended, making the direction and magnitude of every change immediately readable.
A practical example: a team starts a sprint with a $500,000 budget. Hardware costs subtract $120,000. A vendor credit adds back $30,000. Staffing subtracts $80,000. The final bar lands at $330,000. A standard bar chart shows four disconnected columns. A waterfall chart shows the full path from $500,000 to $330,000 as one continuous sequence.
That visual logic extends well beyond finance. Any running total built from sequential increments fits the format, including sprint budget burn, P&L variance, or an IT lifecycle management cost breakdown tracked across phases.
One practical note: Excel's built-in waterfall chart type was introduced in Excel 2016. Earlier versions require a floating stacked bar workaround with considerably more manual setup. If your team needs a reliable audit trail as data changes, that version distinction matters.
Waterfall charts appear in two main domains, and both follow the same logic: a starting value shifts up or down through increments until it reaches a final total.
P&L variance analysis: starts with budgeted revenue, adds or subtracts variances by cost center or product line, lands on actual net income
Each bar isolates one driver, so the chart explains itself in board decks and quarterly reviews without requiring a separate table
Sprint cost tracking: approved budget at the left, each sprint consumes or returns funds, running total shows remaining budget at every stage
Phase-by-phase cost visibility across a software lifecycle is more actionable than a single burn-rate percentage
Pairs naturally with a structured audit trail when stakeholders need to see what changed, when, and by how much
Most Excel tutorials only cover P&L examples. The sprint budget use case is where IT teams feel the real gap, particularly when project data changes weekly and the chart requires a full manual rebuild each time.
A standard bar chart anchors every bar to zero. A waterfall chart uses floating bars instead, where each bar starts where the previous one ended, building a running total across positive and negative values.
Key differences:
Anchor point: Bar charts start at zero; waterfall bars float from the prior value
Purpose: Bar charts compare discrete values; waterfall charts show cumulative change
Spacer workaround: Older Excel versions required a hidden "spacer" series to simulate floating bars, a setup that breaks when data updates
Native support: Excel 2016 and Microsoft 365 include a built-in waterfall chart type with automatic floating bars and a "Set as Total" option for subtotals
For IT project reporting, this distinction matters. A bar chart can show individual sprint costs. A waterfall chart shows how those costs accumulate against your original budget, which is the number stakeholders actually need.
Before touching the chart wizard, the data layout has to be right. This is the step most waterfall chart Excel tutorials skip entirely, and it's where nearly every first attempt breaks.
Excel's built-in waterfall chart type (introduced in Excel 2016 as part of Office 365) reads your data as a simple two-column table: a label column and a value column. What you enter in that value column determines whether a bar floats, rises, or falls. Get the column layout wrong and the chart renders nonsense, regardless of how carefully you follow the insert steps.
Here is the structure that works:
Base row: Your starting value (opening balance, sprint budget, project baseline). Enter the full number. This becomes the grounded first bar.
Increase rows: Positive incremental values only. Enter them as positive numbers. Each one floats upward from the previous bar's endpoint.
Decrease rows: Negative incremental values. Enter them as negative numbers. Each one floats downward.
Subtotal or total rows: Running totals or the final cumulative value. Enter the full cumulative number here, not the delta. In the chart, you will right-click these bars and select "Set as Total" so Excel grounds them instead of floating them.
For a sprint budget variance example: row 1 is your approved sprint budget (base), rows 2 through 6 are individual cost categories as positive or negative deltas, and the final row is the remaining budget as a subtotal.
One column. One value per row. No formulas that reference other chart cells unless you are building a dynamic model. Keep it flat for the first build.
A common mistake on waterfall chart XLS files inherited from colleagues: the subtotal rows already contain cumulative formulas. If you leave those in and also mark the bar as a total, Excel double-counts and the chart collapses. Strip the formulas, enter static values, then mark totals manually.
If your project data changes weekly, this manual prep becomes a recurring maintenance task. Tools like Taro generate waterfall-style variance views from live project data, which removes the rebuild cycle entirely. But for a one-time Excel build, the flat structure above is the right starting point.
The built-in waterfall chart type arrived in Excel 2016 and Microsoft 365 (Windows and Mac both support it, with identical steps). If your data prep is clean from the previous step, inserting the chart takes under three minutes.
Select your data range first. Highlight the category labels and the single values column, including your subtotal and total rows. Do not include helper columns if you built any for reference. Excel reads one value per category, so a clean two-column selection is all it needs.
Then follow this exact click sequence:
With your range selected, go to Insert on the ribbon.
Click Insert Waterfall, Funnel, Stock, Surface or Radar Chart (the icon looks like a small bar chart with floating bars).
Select Waterfall. Excel drops a default chart onto the sheet immediately.
At this point, your subtotal and total bars will likely appear as floating incremental bars, which is wrong. Fix that now.
Is the step most tutorials skip past. Right-click the bar that represents your subtotal or final total. Select Format Data Point from the context menu. In the panel that opens, check Set as Total. The bar drops to the baseline and fills with a distinct color. Repeat this for every subtotal row in your dataset. In Microsoft 365 builds, the label reads "Set as Total" consistently. Excel 2016 and 2019 use the same label, so the step is identical across versions.
appear by default between bars. If they are missing or you want to adjust them, right-click any bar, choose Format Data Series, and toggle Show connector lines on. These lines help stakeholders follow the cumulative logic, especially in sprint budget variance reviews where the sequence of increases and decreases matters.
Keeps the chart readable without a legend lookup. Click any bar once to select the series, then click a second time to select that single bar. Right-click and choose Add Data Label. For project progress charts, labeling only the subtotal and total bars reduces noise while keeping the key numbers visible.
One practical note: Excel's waterfall chart handles static snapshots well, but if your project data updates weekly, you will need to manually re-check your "Set as Total" assignments every time rows shift. Teams managing recurring budget variance reviews often find this friction compounds quickly, similar to the version-control challenges described in IT lifecycle tracking workflows where manual resets introduce silent errors. An audit-ready change log helps catch those drift points before a stakeholder presentation.
Each bar in a waterfall chart carries a specific meaning, and misreading one during a stakeholder presentation can undermine the entire analysis.
Positive bars: (typically blue or green) represent increases. In a project budget context, that might be a new resource allocation or a scope addition that adds to the running total.
Negative bars: (typically red or orange) represent decreases. Think cost savings, scope reductions, or budget drawdowns. These bars float above the baseline rather than starting from zero, which is the visual logic that makes waterfall charts work.
Subtotal and total bars: (typically gray) reset to the baseline. In Excel, these are the bars you manually flagged using "Set as Total" in the previous step. They show the cumulative position at a checkpoint, not just a single movement.
The key thing to communicate to stakeholders: no bar stands alone. Each floats from where the previous bar ended. A red bar that looks small in isolation might represent a significant drawdown once you trace it back to the running total.
For teams tracking IT asset lifecycles or multi-phase project budgets, this cumulative logic is exactly what makes waterfall charts more informative than a simple bar chart.
The core problem with a waterfall chart in Excel is that it's static. Every time your sprint closes, a budget line shifts, or a stakeholder asks for a revised view, you're back to editing source data, re-checking "Set as Total" bars, and reformatting colors manually. For teams running weekly reporting cycles, that rebuild cost adds up fast.
This matters most in project and IT contexts. If you're tracking budget variance across a multi-phase rollout — the kind of work covered in an effective IT lifecycle management implementation — a chart that goes stale between Monday's standup and Friday's stakeholder review isn't just inconvenient. It creates version-control risk.
The excel waterfall chart also has no audit trail. When a number changes, there's no record of what it was before or why it shifted. For compliance-sensitive projects, that gap is a real liability. Purpose-built audit and change tracking solves exactly that.
Taro's live analytics dashboards connect directly to your project data, so budget variance updates automatically without a manual rebuild. The chart reflects current numbers every time someone opens it.
An Excel waterfall chart earns its place when you need a clean, one-time breakdown of how a budget moved from start to finish. It's precise, portable, and requires no special software. For a board presentation or a post-project review, it does the job well.
The problem shows up when budgets are live. Sprint budgets shift, scope changes mid-cycle, and the moment a number updates in your source data, the chart needs to be rebuilt. That manual loop, pulling figures, recalculating variances, reformatting bars, is the bottleneck most project managers quietly absorb every reporting cycle.
Taro handles that differently. Its analytics dashboards pull from your live project and sprint data, so the view stays current without anyone touching a spreadsheet. If your team is spending more time maintaining the chart than acting on it, that's the signal to look at a connected workspace instead.
Q. How do I create a waterfall chart in Excel?
A. In Excel 2016 or later, select your data, go to Insert > Charts > Waterfall. For older versions, build it manually using a stacked bar chart with invisible base bars. Right-click subtotal and total bars and check "Set as Total" so they render correctly.
Q. What is a waterfall chart used for in finance?
A. Waterfall charts show how an opening value rises and falls through a series of transactions to reach a final balance. They're standard in P&L analysis, budget variance reviews, and cash flow statements — making it easy to see exactly which line items drove gains or losses.
Q. Can a waterfall chart show project progress?
A. Not well. Waterfall charts are built for cumulative financial data, not task timelines. For project progress tracking, a Gantt or burndown chart is a better fit. A dedicated project tool handles this more reliably than repurposing a finance-oriented chart type.
Q. How does a waterfall chart differ from a bar chart?
A. A bar chart compares independent values side by side. A waterfall chart shows how a starting value moves through a series of positive and negative changes to reach a final total. You're reading movement and causation, not just size.
Q. What are the benefits of using a waterfall chart in data analysis?
A. Waterfall charts make it immediately clear where value is gained or lost across a sequence. That visibility reduces the time spent explaining variance to stakeholders — something a standard bar chart or data table can't deliver at a glance.
Q. How do I mark a bar as a total in Excel?
A. Right-click the bar, select "Format Data Point," and check "Set as total." Excel recalculates it as an absolute value instead of an incremental change and recolors it automatically. Without this step, the chart misrepresents your ending or subtotal figures.
Start your 14 day Pro trial today. No credit card required.