Super Sale WeekClaude Skills — 20% OFF
Tips

How to Make a Waterfall Chart in PowerPoint: Step by Step

Powerdrill Bloom·
How to Make a Waterfall Chart in PowerPoint: Step by Step

To make a waterfall chart in PowerPoint, select Insert > Chart, choose Waterfall from the chart list, and click OK. Replace the sample data in the worksheet that opens with your own labels and values. Then right-click each total column, such as net income, and select Set as total so it starts at zero.

This guide covers how to prepare your data, insert the chart, set totals, and format the chart so it reads well on a slide. It also walks through a full example, from revenue to net income, and a faster way to build the slide from an Excel file. Steps come from Microsoft's support pages, read on November 17, 2026.

What a waterfall chart shows

A waterfall chart explains how a starting number turns into an ending number. Microsoft's definition is short: "A waterfall chart shows a running total as values are added or subtracted."

Each step between the start and the end is its own column. Increases go up, and decreases go down. Microsoft says the columns "are color coded so you can quickly tell positive from negative numbers."

The first and last columns usually sit on the horizontal axis. The steps in between float, because each one starts where the previous one ended. Microsoft notes that because of this look, "waterfall charts are also called bridge charts."

That shape makes the waterfall chart a favorite for business slides. Common uses include:

  • Profit bridges. Show how revenue becomes net income after costs, expenses, and taxes.
  • Budget changes. Show what moved this year's budget away from last year's.
  • Cash flow. Show the opening balance, the money in and out, and the closing balance.
  • Headcount or customer counts. Show starting numbers, additions, losses, and the ending total.

A bar chart can show the same numbers. It cannot show how each step adds to or subtracts from the total, which is the main point of a bridge.

If you are new to this chart type, our explainer on what a waterfall chart is covers the concept in more depth.

Check your PowerPoint version

The built-in waterfall chart is not in every version of Office. Microsoft's page on how to create a waterfall chart lists PowerPoint for Microsoft 365, PowerPoint 2024, PowerPoint 2021, PowerPoint 2019, and PowerPoint 2016.

If you use one of those, you can follow this guide as written. On a Mac, the same chart lives under the Insert tab in Excel for Mac, and you can copy it into your slides.

Older versions, such as PowerPoint 2013, do not have the waterfall type. The usual workaround is a stacked column chart with an invisible base series. It works, but it takes more setup and breaks easily when numbers change. If you can, use a newer version.

Prepare your data

A waterfall chart needs only two columns: a label and a value. The order of the rows is the order of the columns on the chart.

Set up your data like this:

Column A Column B
Starting value, such as revenue A positive number
Each change, one per row Positive for increases, negative for decreases
Subtotals, if any The running total at that point
Ending value, such as net income The final total

Three rules keep the chart correct:

  1. Use signs, not colors. Enter decreases as negative numbers. The chart colors them for you.
  2. Enter totals as totals. A subtotal row holds the running total, not a change. You will mark it as a total later.
  3. Keep labels short. Long labels wrap or tilt on a slide. Two or three words per label is ideal.

Check the arithmetic before you build the chart. The start plus all the changes should equal the end. If it does not, the chart will show a gap that confuses your audience.

Insert a waterfall chart in PowerPoint

You can make a chart in PowerPoint itself or in Excel. Microsoft's guidance on charts and graphs in presentations explains the trade-off. If you have lots of data to chart, it suggests you "create your chart in Excel, and then copy it into your presentation."

For a single bridge with ten or fewer steps, building it in PowerPoint is quicker. Here are the steps.

  1. Open the slide where you want the chart.
  2. Select Insert > Chart.
  3. In the list on the left, select Waterfall.
  4. Click OK.
  5. In the worksheet that appears, replace the sample labels and values with your own.
  6. Close the worksheet when you are done.

Microsoft's own steps are the same. It says to "click Insert > Chart and pick the chart you want." It then tells you to "replace the placeholder data with your own information."

If the chart does not update, check that your data sits inside the range marked by the colored border in the worksheet. Drag the corner of that range to include new rows.

Set totals so they start at zero

When you first insert the chart, every column floats, including your totals. That is the most common reason a waterfall chart looks wrong.

Microsoft explains the fix. Values such as net income can be set "so they start on the horizontal axis at zero and don't 'float'." Here is how:

  1. Click the chart once to select it.
  2. Click the total column again so only that one column is selected.
  3. Right-click it and select Format Data Point.
  4. In the task pane, check Set as total.

Microsoft also offers a shortcut. You can set totals "by right-clicking on a data point and picking Set as Total from the shortcut menu."

Repeat this for every subtotal and for the final total. The starting value usually needs it too, so it sits on the axis.

Be careful with the selection. Microsoft warns that if all the data points are selected, you will see "the Format Data Series option, rather than the Format Data Point option." Click the single column a second time to select only that point.

To undo a total, clear the Set as total box. The column will float again.

Format the chart for a slide

A default chart works, but a few changes make it easier to read from across a room.

Colors. The chart uses three colors: one for increases, one for decreases, and one for totals. Microsoft says the legend groups the points into "Increase, Decrease, and Total." Click a legend entry to select all columns in that group, then change the fill under Format. Many teams use green for increases, red for decreases, and gray or dark blue for totals.

Connector lines. Thin lines link the top of each column to the start of the next. Microsoft says they help "show the flow of the data in the chart." To hide them, right-click the series, select Format Data Series, and clear Show connector lines. Keep them on for most slides.

Data labels. Use the Chart Elements button next to the chart to show data labels. Microsoft says this button lets you "show, hide, or format things like axis titles or data labels." Labels matter on a waterfall chart, because the audience wants the size of each step.

Gridlines and axis. Remove gridlines if your data labels are on. A clean chart keeps attention on the steps.

Title. Write a title that states the finding, not the topic. "Costs ate half of revenue growth" tells more than "Q3 profit bridge."

Use the Chart Design and Format tabs for other changes. Microsoft notes that if you do not see these tabs, you can click anywhere in the chart to bring them back.

Build it in Excel and paste into PowerPoint

If your numbers live in a workbook that changes every month, build the chart in Excel instead. The steps are almost the same.

In Excel, select your data, then select Insert > Insert Waterfall > Waterfall. Microsoft adds that you can "also use the All Charts tab in Recommended Charts to create a waterfall chart."

Set your totals in Excel the same way. Then copy the chart and paste it into your slide.

Microsoft calls this "the best way if your data changes regularly." When you paste, keep the chart linked to the workbook. Then the chart can reflect the latest numbers when the workbook changes.

Linked charts have one catch. If you send the deck to someone without the workbook, they cannot refresh it. For a deck you will email, paste a normal copy instead.

For more on keeping slides in sync, see our guide on how to update PowerPoint charts from Excel.

A worked example: from revenue to net income

Here is a profit bridge for a small company's third quarter. All amounts are in thousands of US dollars.

Label Value Type
Revenue 500 Total
Cost of goods sold -200 Change
Gross profit 300 Subtotal
Operating expenses -150 Change
Other income 20 Change
Taxes -40 Change
Net income 130 Total

Check the math first. Revenue of 500 minus 200 gives a gross profit of 300. Then 300 minus 150, plus 20, minus 40 gives 130. The net income row matches, so the chart will close cleanly.

Now build it:

  1. Insert a waterfall chart and paste the seven rows into the worksheet.
  2. Set Revenue, Gross profit, and Net income as totals.
  3. Color increases green, decreases red, and totals dark blue.
  4. Turn on data labels and remove gridlines.
  5. Title the slide "Operating costs took half of gross profit."

The finished chart tells the story at a glance. Revenue starts tall, cost of goods sold cuts it, and gross profit lands at 300. Operating expenses take another 150, other income adds a little, and taxes trim the rest. Net income ends at 130.

Your audience can see that operating expenses are the biggest single step after the gross profit line. That points the discussion toward cost control, which is exactly what a good bridge should do.

For a version built straight from an Excel export, see our guide on how to create a waterfall chart for revenue breakdown from Excel.

Make a waterfall chart in PowerPoint with AI

Building the chart is fast once the data is ready. The slow part is usually getting the data ready: pulling numbers from a large export, grouping line items, and checking the totals.

An AI tool can do that preparation and build the slides for you. Here is the method in three steps, using Powerdrill Bloom.

Step 1: Upload your Excel, CSV, or PDF file

Upload the file that holds your figures, such as a profit and loss export or a budget workbook. The Excel to PPT page says you can create slides "from any topic, Excel, CSV or PDF."

Include the period you want to explain. One quarter or one year is a good scope for a single bridge.

Uploading a profit and loss file to make a waterfall chart in PowerPoint with Powerdrill Bloom

Step 2: Ask for the bridge in natural language

Describe the chart you need. For example: "Build a waterfall chart from revenue to net income for Q3." Then list the steps you want, such as cost of goods sold, operating expenses, other income, and taxes.

The page says the tool "identifies patterns, key sections, and data points, then organizes them into clear angles you can build into your presentation." Ask it to check that the steps add up to the ending total.

Step 3: Pick your slides and export to PowerPoint

Choose the insights you want to keep, pick a theme, and generate the deck. The page says you can "export to PowerPoint in one click."

Open the file in PowerPoint and check each total against your source. Adjust colors and labels with the formatting steps above.

Choosing slides before exporting the waterfall chart deck to PowerPoint

Common mistakes to avoid

These are the problems that come up most often with a waterfall chart in PowerPoint.

  • Totals left floating. Set every subtotal and final total with Set as total.
  • Totals entered as changes. A subtotal row holds the running total, not the change since the last row.
  • Wrong signs. Decreases must be negative numbers, or the chart shows them going up.
  • Too many steps. More than ten columns gets crowded on a slide. Group small items into "Other."
  • No data labels. Without labels, the audience has to guess the size of each step.
  • A topic title. State the finding in the title, not just the period.
  • Broken links. A linked chart cannot refresh without its workbook. Paste a normal copy for decks you send out.

For other chart types, see our guide on how to make a bar graph in PowerPoint. For layout tips, see how to make data slides easy to read.

When your figures sit in a large export, try Powerdrill Bloom to turn them into a ready bridge slide.

Frequently asked questions

Does PowerPoint have a waterfall chart?

Yes. PowerPoint for Microsoft 365, 2024, 2021, 2019, and 2016 include a built-in waterfall chart. Select Insert > Chart, then choose Waterfall from the list.

How do I make a total column start at zero?

Select the single total column, right-click it, and select Format Data Point. Then check Set as total. The column will start on the horizontal axis.

Can I make a waterfall chart in PowerPoint from Excel data?

Yes. Build the chart in Excel with Insert > Insert Waterfall > Waterfall, then copy and paste it into your slide. Keep it linked if the data changes often.

Why does my waterfall chart look wrong?

The most common causes are floating totals, decreases entered as positive numbers, and subtotals entered as changes. Fix the data and set each total with Set as total.

What is another name for a waterfall chart?

A waterfall chart is also called a bridge chart. The name comes from the floating columns that bridge the starting value and the ending value.

Sources: Microsoft Support, Create a waterfall chart · Microsoft Support, Use charts and graphs in your presentation.