For example, you might want to use Net revenue and Gross Income as two checkpoints between Gross Revenue and Net income starting and ending values. Tip: While the most typical waterfall chart is the one with a starting and ending value, you can also create subtotals as visual milestones in the series. In a nutshell, use a waterfall chart whenever you want to show how a starting value increases or decreases through a series of positive or negative changes.

Showing product value over a period of time.Analyzing inventory or sales over a period of time.Highlighting budget changes on a project.Other examples of quantitative analyses, where waterfall charts are used, include: Waterfall charts are popular in the corporate and financial environment because they are very useful for a visualization of the positive and negative movements within a measured quantity or KPI, such as your Monthly Net Profit or Cash Flow. Some people like to connect the lines between the contributions to make the chart look like a bridge (giving us the bridge chart name), while others leave the columns floating. Note: Other fun names for waterfall charts include Mario chart and flying bricks chart, because individual chart elements resemble an old arcade game. The floating columns between them are the contributing positive or negative values. In a waterfall chart, the first column is the starting value and the last column is the end value. In other words, it's an ideal way to visualize a starting value, the positive and negative changes made to that value, and the resulting end value. Waterfall charts 101Ī waterfall chart (also known as a cascade chart or a bridge chart) is a special kind of chart that illustrates how positive or negative values in a data series contribute to the total. Read on to learn why and how you can create one yourself which will bring more insights in just a few clicks. Unsurprisingly, it has continued to enjoy widespread popularity to this day. Prior to its release, the built-in Excel waterfall chart was the most highly anticipated chart type in the financial community.

Angle text in excel file