SET PREVIOUS BAR
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. Typically, the bar will use the previous (adjacent) bar as its previous bar. You can designate a different bar to use as a previous bar.
1.Right click on the bar you wish to set a previous bar for.
2.Choose Set Previous Bar and select a previous bar from the available options in the drop down menu. If you are linking segments, the links will reference the bar you have designated as the previous bar.