TOTAL BARS

<< Click to Display Table of Contents >>

Navigation:  Bar Level Formatting >

TOTAL BARS

Previous pageReturn to chapter overviewNext page

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.

APPLIES TO: WATERFALL CHARTS

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