From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Waterfall charts

Waterfall charts - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Start my 1-month free trial Buy for my team

Waterfall charts

“

- [Instructor] Another really cool, really useful chart that was just introduced in Excel 2016 is the waterfall chart. Now, you used to be able to create similar looking waterfall or step charts using some hack kind of methods with older versions of Excel. These new 2016 waterfall charts make it so much easier. So waterfall charts are commonly used for showing the net value after a series of positive or negative contributions. So they're often used for things like corporate balance sheet analyses or personal income and spending, so a great way to visualize progression from a starting point to an ending point. Pro tip here, you can use sub-totals to create checkpoints midway through your waterfall. That helps to split up certain types of gains or losses. For instance, with a corporate balance sheet analysis, you might have gross revenue and then subtract cost of goods sold, which takes you to gross profit, and then gross profit minus operating expenses equals operating income, which is…

Contents