How to Create the Excel Waterfall Chart
Originally published: 19/02/2018 15:51
Publication number: ELQ-49563-1
View all versions & Certificate

How to Create the Excel Waterfall Chart

This tool provides a Waterfall Chart Template in Excel with fully adjustable values so that you can input your own.

Finance professionals are often asked to create excel waterfall charts for management or board presentations. They're a powerful and 'simple' visual way to demonstrate changes over a certain time period. It can be really difficult to present variances using lots of numbers of on an excel spreadsheet if you're not talking to other 'numbers' people. This does not take you through step-by-step how to build an excel waterfall chart, but instead provides a template with 2 examples so that you can adjust as required.

One is a recurring revenue waterfall and the other is a cash waterfall. The fields highlighted in yellow are for you to input your own figures and change the charts accordingly.

This Best Practice includes
1 Excel Waterfall Chart Template in Excel

Ben Murray offers you this Best Practice for free!

download for free

Add to bookmarks


4.4 / 5 (11 votes)

please wait...