All About Waterfall Charts

  • WATERFALL CHARTS

    The Waterfall, also known as a cascade or bridge chart, is used when presenting changes in a key measure or walking an audience through the categories in a financial statement.

    Start Free Trial
WATERFALL CHARTS

Build Up Waterfall

Build Up Cascade Chart/Waterfall Chart

Change Waterfall

Change Cascade Chart/Waterfall Chart

Stacked Waterfall

Stacked Cascade Chart/Waterfall Chart

Horizontal Waterfall

Horizontal Cascade Chart/Waterfall Chart

Waterfall charts, the preferred chart type for many consultants and finance professionals, show the change in a key measure, like revenue or profits, between two time periods. The individual bars in this type of Waterfall chart allow you to see which products, categories, or regions contributed the most to the change.

The Waterfall Chart is also used to compare the impact of different line items on a financial statement, like an income statement or statement of cash flows. For example, you can show revenue as the first bar in a Waterfall chart and then all of the cost categories "waterfall" off of revenue until you end with a net income bar. This Waterfall chart enables you to walk your audience through each step and see the relative impact of each line item. You can reinforce the message about relative impact by adding a data row to this chart to show the percent of revenue for each of the bars.

Waterfall charts can be used as an alternative to a stacked bar chart to show segmentation by categories, products, or regions. The Waterfall allows you to build up to a total value by discussing each bar that contributes to the total and it is particularly useful when you have positive and negative values.

Bar comparison lines are frequently used with Waterfall charts to highlight the change between two bars, typically the beginning and ending bar. Axis breaks are often needed when creating a Waterfall chart to allow you to focus attention on the drivers of change, or individual bars, instead of the beginning and ending values, or total bars.

Examples

Change in Revenue between Quarters by Product

Income Statement Walk from Revenue to Net Income

Sales Build-Up by Product or Region

Change in Profitability by Customer

Production Volume by Region and Year

VIDEOS

Creating Better Cascade Charts

How to Make a Cascade Chart

Using Axis Breaks

Making a Chart Using Excel