The waterfall chart allows you to plot values as bars, however, depending on whether they are negative or positive numbers the total is added or subtracted. The columns have different colors based on if the value is less than 0 (zero) or larger than 0 (zero) and they are connected with lines to make it easier for the reader to follow.
The waterfall chart is great for displaying financial information like income statements. It shows the cumulative effect for each activity and the outcome.
How to build
Go to tab "Insert" on the ribbon.
Click "Insert Waterfall, Funnel, Stock, Surface or Radar chart" button
Click "Waterfall chart" button.
The chart now looks like this.
Double click on chart column "Costs of goods sold" to open the task pane.
Click on chart column "Costs of goods sold" until only the column is selected The other columns are faded out if only one column is selected.