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.
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:
Period: includes a start, end, and all the years/periods to show in the waterfall
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)
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
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)
Before: input =E5 in cell G6 and copy down to G10
After: input =E6 in cell H6 and copy down to G10
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!
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.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.