Waterfall Chart Properties – Value Axis


One axis with a single scale

waterfall_properties_value_axis_one_scale.png

 

Option

Description

Columns

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

Settings...

[Not available in this visualization.]

One axis with a single scale

Select this option if you want to display one common scale for all values 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

 

   Reverse scale

Reverses the current sort order on the scale.

 

One scale per trellis panel

waterfall_properties_value_axis_one_scale_per_trellis.png

 

Option

Description

Columns

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

Settings...

[Not available in this visualization.]

One axis with a single scale

Select this option if you want to display one common scale for all values 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

[Not applicable].

 

   Left value axis

[Not applicable].

   Right value axis

[Not applicable].

 

   Bottom value axis

[Not applicable].

 

   Top value axis

[Not applicable].

 

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?