Download the sample data here http://www.bluepecantraining.com/portfolio/create-waterfall-charts-in-excel-2016/ A waterfall chart is useful when you want to display a series of totals and how they are affected by intermediary positive and negative values.