Waterfall Chart Properties – Appearance


waterfall_properties_appearance.png

 

Option

Description

Orientation

 

   Vertical

   

Use this option to display the bars and blocks vertically in the visualization.

   Horizontal

   

Use this option to display the bars and blocks horizontally in the visualization.

Show one waterfall

 

Over all category and color axis values

Use this option to show all bars and blocks in a single waterfall. This is the default setting. An example is shown below.

waterfall_properties_appearance_per_color_and_category.png

Per categorical color

[Applicable to categorically colored waterfall charts.] Use this option to show separate waterfalls per categorical value on the Color axis. The result of selecting this option in the waterfall chart above is shown below.

waterfall_properties_appearance_per_color.png

Per value on category axis

[Applicable to categorically colored waterfall charts.] Use this option to show separate waterfalls per value on the Category axis. The result of selecting this option in any of the waterfall charts above is shown below.

 waterfall_properties_appearance_per_category.png

   Continue over trellis

   

[Applicable to trellised waterfall charts.] Select this check box if you want the waterfall to continue over multiple trellis panels. That is, the first value in the next trellis panel will start where the last value ended in the previous panel.

Clear the check box to show one waterfall per trellis panel. In this case, the first value in each trellis panel will be a bar starting from zero.

You can click the arrow to select over which individual panels the waterfall should continue: Pages, Panels, Rows and Columns.

The example below shows a trellised waterfall chart, where the waterfall does not continue over trellis.

waterfall_properties_appearance_trellis_not_continue.png

The result of changing this visualization to a waterfall that continues over trellis is shown below.

waterfall_properties_appearance_trellis_continue.png

Bar and block width

Drag the slider to modify the width of the bars and blocks.

Transparency

Drag the slider to change the transparency of the bars and blocks. This makes it possible to see lines or curves that are placed in the background through these items.

Show lines that connect bars and blocks

Select this check box to add transition lines between the bars and blocks.

   Color

   

In the Color palette, specify the color of the transition lines.

Use separate color for marked items

Select this check box to use the specified marking color to distinguish marked items in this visualization. If the check box is cleared, then unmarked items will be faded out instead, and the original color  will be kept for the marked items. See Marking in Visualizations for more information.

Sorting

[Applicable to waterfall charts with a categorical coloring.]

Sort blocks within each category axis value

Sorts the blocks within a value on the category axis by size. The block representing the highest value in the category is placed first in the waterfall, and the lowest value at the end.

Reverse block order

Reverses the current order of the blocks, that is, the block currently placed first in the category will be placed last, the second-first will be placed second-last, and so on.

Time series

 

Compensate for missing values

Select this check box if you are using a Date, Time or DateTime column somewhere in the visualization and you need to perform some calculation where a required time period is missing. For example, if you have created a visualization and there are missing data for some categories, selecting this check box will produce a block of the same size as the previous block instead of showing no block at all. See Working With Time Hierarchies for more information.

Enabling this setting will temporarily add new rows with empty values for the missing periods so that they can be used in the calculation.

See also:

Waterfall Chart Properties

How to Use the Waterfall Chart

What is a Waterfall Chart?