Waterfall Chart Properties – Total Bars


waterfall_properties_total_and_subtotals.png

 

Option

Description

Show total bars

Select this check box if you want to add bars showing calculated totals. A total bar can represent the resulting value for an entire waterfall or an intermediate running total.

 

   Color

   

In the color palette, select the color of the total bars.

   One total bar per waterfall

   

Use this option to display a bar representing the calculated total for each waterfall within the visualization. An example is shown below:

waterfall_total.png

   Name

   

In the text field, type the scale label for the total to be displayed on the category axis.

   One total bar after each value in

      

[Applicable to waterfall charts where a categorical coloring is used, or to waterfall charts with a hierarchy on the category axis.] Use this option to display bars representing intermediate calculated totals.

In the drop-down list, select the column containing the values after which a display of totals is of interest.  

The examples below show monthly subtotals and quarterly subtotals, respectively, in a hierarchically structured waterfall chart.

waterfall_subtotal_lower_level.png

 

waterfall_subtotal_higher_level.png

See also:

Waterfall Chart Properties

How to Use the Waterfall Chart

What is a Waterfall Chart?