Waterfall Charts In Excel 2016. In this example we re using a simple expenses and. It s one of the most common charts for which people use additional third party add ins for.
The waterfall chart in excel 2016 getting started with a waterfall chart get the data right. The chart demonstrates how the value increases or decreases through a series of changes. In this example we re using a simple expenses and.
Waterfall chart will appear on the sheet.
The answer used to be with great difficulty but excel 2016 changed that. Click on the base series to select them right click and choose the format data series option from the context menu. Net sales is now shown as total. Select the data table step 2.