All About Cascade Charts

  • CASCADE CHARTS

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

    Start Free Trial
CASCADE/WATERFALL CHARTS

Build Up Cascade

Build Up Cascade Chart/Waterfall Chart

Change Cascade

Change Cascade Chart/Waterfall Chart

Stacked Cascade

Stacked Cascade Chart/Waterfall Chart

Horizontal Cascade

Horizontal Cascade Chart/Waterfall Chart

Cascade or 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 Cascade chart allow you to see which products, categories or regions contributed the most to the change.

The Cascade 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 Cascade chart and then all of the cost categories "waterfall" off of revenue until you end with a net income bar. This Cascade or 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 abour relative impact by adding a data row to this chart to show percent of revenue for each of the bars.

Cascade charts can be used as an alternative to a stacked bar chart to show segmentation by categories, products or regions. The Cascade 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 Cascade charts to highlight the change between two bars, typically the beginning and ending bar. Axis breaks are often needed when creating a Cascade 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