Waterfall Charts In Excel 2016. Inserting the waterfall chart. Select the data you want to create the waterfall chart from.
Click insert insert waterfall or stock chart waterfall. The answer used to be with great difficulty but excel 2016 changed that. Navigate to the insert tab and click the waterfall chart button it s the one with the bars going both above and.
The waterfall chart also known as a cascade chart or a bridge chart.
Click on the base series to select them right click and choose the format data series option from the context menu. The chart demonstrates how the value increases or decreases through a series of changes. The format data series pane immediately appears to the right of your worksheet in excel 2013 2016. It s one of the most common charts for which people use additional third party add ins for.