Waterfall Chart Properties – Value Axis


Single scale

Option

Description

Columns

Specifies the column or hierarchy to be displayed on the value axis.

Settings...

[Not available in this visualization.]

Single scale

Select this option if you want to display one common scale for all measures on the value axis.

One scale per trellis panel

Select this option if you, in your trellised waterfall chart, want to use separate value axis scales for the different panels. For example, use it if the magnitudes of the values differ from panel to panel.

Range

 

   Min

Determines the lower value of the axis range. Leave the field blank to automatically adjust the range to the currently lowest value in the filtered data.

   Max

Determines the upper value of the axis range. Leave the field blank to automatically adjust the range to the currently highest value in the filtered data.

   Set to Current Range

Allows you to set the axis range to the currently filtered values.

   Include origin

[Available for continuous axes only.]

Always includes the value 0 on the axis, regardless of filtering.

   Show zoom slider

Shows a zoom slider that you can manually manipulate to view only the interesting parts of the waterfall chart.

Show gridlines

Specifies whether or not gridlines should be visible.

Comment: This refers to vertical gridlines in a horizontal waterfall chart, and horizontal gridlines in a vertical waterfall chart.

Scale labels

 

   Show labels

Specifies whether or not scale labels should be visible.

      Horizontally

Shows scale labels horizontally.

      Vertically

Shows scale labels vertically.

      Max number of labels

Select the check box to specify a maximum number of scale labels to be shown. Limiting the number of labels can improve readability on axis scales with many values.

Scale

 

   To the left

   

Select this option to place the scale on the left-hand side in a vertical waterfall chart.

   To the right

   

Select this option to place the scale on the right-hand side in a vertical waterfall chart.

   At the bottom

   

Select this option to place the scale at the bottom in a horizontal waterfall chart.

   At the top

   

Select this option to place the scale at the top in a horizontal waterfall chart.

   Reverse scale

Reverses the current sort order on the scale.

One scale per trellis panel

Option

Description

Columns

Specifies the column or hierarchy to be displayed on the value axis.

Settings...

[Not available in this visualization.]

Single scale

Select this option if you want to display one common scale for all measures on the value axis.

One scale per trellis panel

Select this option if you, in your trellised waterfall chart, want to use separate value axis scales for the different panels. For example, use it if the magnitudes of the values differ from panel to panel.

Zoom

 

   Show zoom slider

Shows a zoom slider that you can manually manipulate to view only the interesting parts of the waterfall chart.

   Show gridlines

Specifies whether or not gridlines should be visible.

Comment: This refers to vertical gridlines in a horizontal waterfall chart, and horizontal gridlines in a vertical waterfall chart.

Scale labels

 

   Show labels

Specifies whether or not scale labels should be visible.

      Horizontally

Shows scale labels horizontally.

      Vertically

Shows scale labels vertically.

 

      Max number of labels

Select the check box to specify a maximum number of scale labels to be shown. Limiting the number of labels can improve readability on axis scales with many values.

Individual scale settings

 

[Drop-down list]

Select the scale for which you wish to change the settings. Select All scales to change settings for all scales simultaneously.

Scale Range...

Opens the Scale Range dialog where you can specify the range of the selected scale, and also determine whether or not to include the value 0 on the axis.

Position scale

Specifies which side in the visualization the scales should be positioned. The available alternatives vary depending on whether the bars are displayed vertically or horizontally.

   To the left

Select this option to place the scales on the left-hand side in the trellis panels.

   To the right

Select this option to place the scales on the right-hand side in the trellis panels.

   At the bottom

Select this option to place the scales at the bottom in the trellis panels.

   At the top

Select this option to place the scales at the bottom in the trellis panels.

 

Reverse scale

Reverses the current sort order on the scale.

See also:

Waterfall Chart Properties

How to Use the Waterfall Chart

What is a Waterfall Chart?