Waterfall charts can be used to categorize revenue or cost components of a market segment. Each bar is related to and effected by surrounding bar values. Given the first bar value, the next bar adds or subtracts it to the second value, and so on. You can create or designate a bar (or multiple bars) as a total bar, which is the sum of the intermediate bars in the chart.
1.Right click on the bar you wish to be a total bar. This will display the Format Bars Context Menu
2.Choose Set Bar as Total
3.You can also go to the Format Bars/Series Task Pane and set your desired bar as a total bar