How to Make a Waterfall Chart in Excel (2026 Guide)
Home›Excel Charts›Make a Waterfall Chart
ExcelHow-To⏱ 3 min read

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

  1. Select your data range

    Include the header row and both columns.

  2. Insert tab → Waterfall icon

    The icon is in the Charts group. Looks like stacked bars with color-coded pos/neg.

  3. 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).

  1. Double-click the total column

    First click selects the whole series; second click selects just that column.

  2. Right-click → Set as Total

    Column drops to the axis and takes on the "Total" color.

  3. 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.

Skip the manual version if you can

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
Excel Wizard

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.