Excel Waterfall Chart Template

Download our free Excel waterfall template

What is a Waterfall Chart?

A waterfall chart is a dynamic, intuitive visualization that shows how a series of positive or negative changes impact an initial value, ultimately resulting in a final total. Commonly used in financial analysis, business reporting, and performance tracking, this chart breaks down how specific data points, such as revenue shifts, cost fluctuations, or budget adjustments, contribute to the outcome.

Key features of a waterfall chart include:

  • Color-coded bars that distinguish between gains (positive contributions) and losses (negative impacts).
  • Floating columns that represent each step in the progression from start to finish.
  • Intermediate values that clarify the drivers behind cumulative results.

Whether you’re analyzing net income, dissecting a project budget, or exploring operational trends, an Excel waterfall chart helps transform complex datasets into clear, actionable insights.

How to Create an Excel Waterfall Chart

A waterfall chart is a great way to visually show the effect of positive and negative cash flows on a cumulative basis. If you’re using Excel 2016 or later, Excel has a built-in waterfall chart option that makes this quick to build. If you’re working in Excel 2013 or an earlier version, you’ll need to build your own waterfall chart using the Up/Down Bars and Error Bars features instead. Both methods are covered below, and you can download our Excel Waterfall Chart Template at the bottom of the article.

Using Excel’s Built-In Waterfall Chart (Excel 2016 and Later)

Select your data, including the header row. Go to the Insert tab, and in the Charts group, click the Waterfall chart icon (it looks like a column chart with bars above and below the horizontal axis), then choose Waterfall. Excel builds the chart automatically from your data.

To mark a column as a total, such as a starting or ending balance, rather than a change, click that column in the chart, go to Format Data Point, and check the Set as Total box. This anchors the bar to zero instead of stacking it on the previous value.

Waterfall Chart Template Screenshot

Step 1 – Create a Data Table with 7 Columns

In order to build your own waterfall chart, you first have to organize your data as follows:

  1. Period: includes a start, end, and all the years/periods to show in the waterfall
  2. Cash Flow: the amount of cash flow for each period (only enter data in the grey cells; the end period should have a formula =SUM(D5:D10) in cell D11)
  3. Cumulative: sum of current and all previous period’s cash flows (enter =SUM($D$5:D5) in cell E5 and copy down until E10); this column is used to build the connectors later
  4. Start & End: the start and end cash flows are linked to cell F5 and F11 and will be used to create column charts (show as the total columns)
  5. Before: input =E5 in cell G6 and copy down to G10
  6. After: input =E6 in cell H6 and copy down to G10
  7. Data label position: will be used to create a scatter plot to add data labels to the correct positions; enter formula =MAX(F5:H5) in cell I5 and copy down to I11

Step 2 – Build the Waterfall Chart Using Up/Down Bars

  • Select cell F4 to H11, press ALT + N + C to insert column charts.
  • Right-click on the chart and select Change Chart Type; change chart type of Before and After Series to Line.
  • Click either of the Before or After Series Lines, click the green plus button on the top right corner of the waterfall chart and check the box for Up/Down Bars.
  • The Up-Bars show positive changes, while the Down-Bars show negative changes.
  • Change the color of each of the Up-Bars, Down-Bars, and Start & End columns to colors of your choice. Select No Outline for columns and bars.
  • Right-click on each of the Before and After series and select Format Data Series; under Fill & Line, select No line.
  • Under Series Options, change Gap Width to 50%. Do the same for the Start & End column series.
  • Select the Horizontal axis, right-click and go to Select Data. Select cell C5 to C11 as the Horizontal axis labels.
  • Right-click on the horizontal axis and select Format Axis. Under Axis Options -> Labels, choose Low for the Label Position.
  • Change Chart Title to “Free Cash Flow.” Remove gridlines and chart borders to clean up the waterfall chart.

Step 3 – Add Data Labels to the Bars and Columns

Recall that we created a column called Data label position; this column will be used to define the position of the labels.

  • Right-click on the waterfall chart and go to Select Data. Add a new series using cell I4 as the series name, I5 to I11 as the series values, and C5 to C11 as the horizontal axis labels.
  • Right-click on the waterfall chart and select Change Chart Type. Change the chart type of the data label position series to Scatter. Make sure the Secondary Axis box is unchecked.
  • Right-click on the scatter plot and select Add Data Labels.
  • Right-click on the data labels and go to Format Data Labels. Under Label Options, check the box for Value from Cells and select cells D5 to D11 for the data label range.
  • Uncheck other boxes for Label Options. Select Above for Label Positions.
  • Right-click on the scatter plot and select No Fill and No Outline to hide the scatter plot.

Step 4 – Insert Connectors Between Each Bar Using Error Bars

  • Right-click on the chart and Select Data. Add a new series using cell E5 to E10 as the Series Y Values and type “Connectors” as the series name.
  • Click on the Connectors series, click the green plus button on the top right corner of the chart, and check the box for Error Bars.
  • Select the Y error bars (vertical bars) and delete them.
  • Right-click on the error bars and select Format Error Bars. Under Error Bar Options, select Plus for Direction and No Cap for End Style.
  • For Error Amount, select Fixed value and type 1.
  • Change the error bars outline to grey color. Right-click on the connector series and select No Color and No Outline to hide the data points.
  • Remove the legend to clean up the waterfall chart.

Final Product

Below is a preview of the waterfall chart template. Feel free to use this template to present the results of your financial analyses!

Waterfall Chart Template Screenshot - Final Results

Download CFI’s Free Excel Waterfall Chart Template

Tips to Improve a Waterfall Chart

Refining your waterfall chart in Excel doesn’t require advanced tools, just a few intentional edits that improve readability and focus. These adjustments help your audience stay oriented and make faster decisions based on your insights.

Add data labels where they matter most

Right-click a column and choose Add Data Labels to display the value directly on the chart. You can then select Format Data Labels to reposition them, adjust size, or change the font for clarity.

Give the chart a clear and useful title

Click anywhere on the chart to bring up the design tools. Use the Chart Design tab to insert a chart title that explains the visualization’s purpose. A precise label reduces guesswork and supports interpretation.

Use color intentionally

Open the Change Colors panel in the Chart Design tab. Select a palette that suits your brand or reporting style. To emphasize trends or categories, click Customize Colors and assign specific shades to each series.

Designate your totals correctly

Excel doesn’t always label starting and ending columns as totals by default. To fix this, right-click a column that represents a total, go to Format Data Series, and select Set as Total from the side panel.

Remove distractions

Clean visuals improve comprehension. Delete elements that don’t contribute to the message, such as the legend, axis lines, or gridlines. Use the Chart Options menu to control visibility.

Enable connector lines to clarify progression

Activate connector lines to show how one value leads to the next. Right-click the chart bars, open Format Data Series, and check the Show Connector Lines Box. This adds a subtle but helpful visual thread.

Adjust the spacing between columns

Reducing the gap width tightens the appearance of your chart and improves the sense of flow. Right-click any bar, choose Format Data Series, and slide the gap width to the left for closer spacing.

Focus on contrast, not decoration

Color contrast matters more than visual complexity. Highlight changes that reflect real movement in the data. Avoid overly detailed formatting in your chart design that could distract from the meaning.

If using multiple charts, align their axes

Charts placed side-by-side in a report should use the same vertical scale. Otherwise, comparisons will be distorted. To do this, manually set the vertical and horizontal axis bounds under Format Axis for each chart before finalizing your report.

Use consistent bar width and alignment

Misaligned columns or inconsistent widths can distract from your message. In Excel, use the gap width slider in the Format Data Series panel to ensure even spacing. This keeps the chart tidy and professional.

Label only what matters

Avoid overloading your chart with data labels. Instead, focus on labeling totals or high-impact values. For example, highlight the final result, net income, or key turning points while letting smaller changes remain visual. This keeps attention on what drives the outcome.

Format the horizontal axis for readability

Ensure your horizontal axis categories are short, relevant, and evenly spaced. Avoid long text or repetitive labels. If needed, rotate the text slightly under Format Axis to prevent crowding.

Group similar contributions visually

If your waterfall template in Excel has multiple small values contributing to one outcome, consider grouping them in your data table before building the chart. This helps emphasize the story rather than overwhelming the viewer with minor fluctuations.

A few careful edits can make a visually appealing chart that supports interpretation without requiring explanation.

When Does a Waterfall Chart Make Sense?

A waterfall chart makes sense when explaining how a starting value moves step by step to a final outcome. It also works exceptionally well when presenting a high-level summary of financial performance, showing how each factor, whether gain or loss, contributes to the overall change.

Use a waterfall chart when you need to:

  • Break down income flow across periods or categories
  • Visualize budget variances between planned and actual results
  • Compare the beginning and ending net income totals
  • Analyze how departments or cost centers affect a project budget
  • Identify drivers behind the final bar, such as total expenses or profit
  • Highlight intermediate values that contribute to the outcome
  • Track progress in performance dashboards
  • Transform static numbers into a precise visual sequence

This chart type is ideal for presentations, reports, and dashboards where clarity matters more than granular interactivity. It simplifies complex relationships and gives decision-makers a clean path from question to insight.

If your goal is to break down values across multiple steps and tell a clear story of change, a waterfall chart is often the right fit. Consider alternatives like a cascade chart or standard bar chart when more detail is needed, or if visual comparability is the priority.

Put Your Waterfall Chart to Work

A waterfall chart turns a dense list of numbers into a story your audience can follow at a glance, which is exactly the kind of skill that separates a good financial model from a great one. CFI’s FMVA® Certification covers Excel-based financial modeling and data visualization techniques like this one in depth, so you can build analysis that’s as clear as it is accurate.

Additional Resources

This is a free Excel Waterfall Chart Template guide. Check out more of our resources to take your Excel skills to the next level:

See all Excel resources

See all Financial Modeling resources

0 search results for ‘’