Pros

Simple to create in Excel 2016+ At-a-glance visual display of positive and negative changes

Cons

Less common chart type not as familiar to many people Built-in waterfall chart type has limited options

Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Waterfall Chart - 34Waterfall Chart - 14Waterfall Chart - 55Waterfall Chart - 53Waterfall Chart - 46