How to Make a Waterfall Chart in Excel (2026)
Waterfall charts explain how a value changes from a starting point to an ending point through additive steps — perfect for variance analysis, revenue walks, and budget-to-actual comparisons. Native since Excel 2016; older versions need a manual workaround.
⚡ Quick Answer
Set up two columns: category labels and values (positive for gains, negative for losses). Select the range. Insert tab → Waterfall icon → Waterfall. Double-click totals/subtotals → Set as Total.
Method: Native waterfall (Excel 2016+)
Step 1: Set up your data
Two columns:
- Category — Starting value, individual changes, Ending value
- Value — starting number, positive for increases, negative for decreases, ending number
Example (Q1 to Q2 revenue walk):
Q1 Revenue 1,200,000
New customers 150,000
Upsells 80,000
Churn -110,000
Discounts -40,000
Q2 Revenue 1,280,000
Step 2: Insert the waterfall chart
Select your data range
Include the header row and both columns.
Insert tab → Waterfall icon
The icon is in the Charts group. Looks like stacked bars with color-coded pos/neg.
Click "Waterfall"
Excel builds the chart. Positive values one color, negative another, connectors between bars.
Step 3: Mark totals
By default Excel treats all values as floating changes. You need to tell it which columns are totals or subtotals so they sit on the axis (not float).
Double-click the total column
First click selects the whole series; second click selects just that column.
Right-click → Set as Total
Column drops to the axis and takes on the "Total" color.
Repeat for subtotals
Any interim totals you want shown as anchored columns.
Formatting the waterfall
Color scheme
Right-click any data point → Format Data Series → Fill. Excel assigns 3 colors by default:
- Positive changes (usually green)
- Negative changes (usually red)
- Totals/subtotals (usually gray or blue)
Change these to your brand colors for a polished look. Legend at the top of the chart shows all three.
Show or hide connectors
The horizontal lines connecting bar tops are connectors. Right-click any connector → Format Connector Lines → toggle on/off, change color and weight. Keep them subtle (light gray, thin line) so bars are the focus.
Data labels
Right-click a bar → Add Data Labels. Format to show the value. For readability, position labels above positive bars and below negative bars — Excel does this by default with "Inside End" option, but "Outside End" often reads cleaner.
Method: Manual waterfall (Excel 2013 and earlier)
Older Excel versions don't have native waterfall charts. Build one manually using a stacked column chart.
Set up 4 data columns
Category Base Rise Fall Total
Q1 0 1,200 0 0
Change 1 1,200 150 0 0
Change 2 1,350 80 0 0
Change 3 1,320 0 110 0
Change 4 1,210 0 40 0
Q2 0 0 0 1,280
Base = invisible spacer that lifts the visible bar to the right height. Rise = visible bar for gains. Fall = visible bar for losses. Total = anchored total column.
Insert stacked column chart from the 4 columns
Then right-click the "Base" series → Format Data Series → Fill → No fill. The base becomes invisible, lifting the other bars to the correct waterfall positions.
If your Excel is 2016 or later, use the native waterfall. Manual construction is tedious and error-prone. The base-column formula calculation is the tricky part — one wrong reference and the chart looks meaningless.
Common waterfall use cases
- Revenue variance — Q1 to Q2, broken by new customers, upsells, churn, discounts
- Budget to actual — planned to actual, broken by favorable and unfavorable variances
- Price bridge — old price to new price, broken by cost inputs, margin, tax changes
- Headcount — start-of-period to end-of-period, broken by hires and departures
- Cash flow — opening balance to closing balance, broken by inflows and outflows
Build waterfall charts from a description
Setting up a proper waterfall from scratch — data structured, totals marked, colors right — takes real work. Excel Wizard lets you describe what you want to show ("waterfall showing Q1 to Q2 revenue variance") and it builds the chart with correct totals, subtotals, and formatting.
Install Excel Wizard →Frequently asked questions
How do I make a waterfall chart in Excel?
Select your data with category labels and values (positive and negative). Go to Insert tab → Waterfall icon → pick Waterfall. Excel builds the chart automatically. Native waterfall charts require Excel 2016 or later.
When should I use a waterfall chart?
Use waterfall charts to explain how a value moved from a starting point to an ending point through positive and negative contributions. Common uses: revenue variance, budget-to-actual walks, price bridge analysis, hiring tracking.
How do I mark totals and subtotals in a waterfall chart?
After inserting the chart, double-click the total or subtotal column to select just that data point. Right-click → Set as Total. Excel changes that column to sit on the axis and applies the 'Total' color.
Can I make a waterfall chart in Excel 2013 or earlier?
Not natively. Waterfall charts were added in Excel 2016. In older versions, build a waterfall manually using a stacked column chart with 'invisible' base bars formatted with No Fill.