Office 2016 introduces a new chart type to Excel’s arsenal – the waterfall chart. It's great for showing how positive and negative values contribute to a total – like tracking the worth of a financial portfolio over time or visualizing income and expenses. Unlike a line chart, which reveals trends, a waterfall chart emphasizes individual gains and losses.
To create a waterfall chart, make a simple two-column array, with months in the left column and dollar amounts (positive and negative) in the right. Select the array and click Insert and click the Recommended Charts icon. Then click the All Charts tab on the insert Charts dialog box. Click Waterfall in the right pane and click OK. A rather poorly formatted chart greets you.
Next, we will rein in that Y axis so the hefty Start amount doesn’t swamp the other data. Right-click the Y-axis labels and click Format Axis. In the Axis Options pane, enter 15400 and click OK. Then click the Number item and in Category select Currency and, in the Decimal places box that appears, type 0, and press Enter. Finally, set that first data point on the chart as a Total item. Click on the first column in the chart and click on it again so that only that column is highlighted (the others should look faded). In the Format Data Point pane, click the Series Options icon and then check the Set as total checkbox. The selected column now turns gray.
Source : https://www.computerworld.com/article/3268664/enterprise-applications/10-spiffy-new-ways-to-show-data-with-excel.html