To create a new waterfall chart:
On the toolbar, click the
Waterfall Chart button, .
Comment: You can also select Insert > Visualization > Waterfall Chart from the menu.
Response: A first attempt to set up a suitable waterfall chart is made by the application.
Adjust the waterfall chart to display the categories and measures of your choice.
Comment: Because the waterfall in its nature adds up values, make sure the measures are meaningful. Typically, "(Sum)" is selected as the aggregation type.
Comment: You can specify another order of the values on the category axis. For more information, see custom sort order.
To use multiple columns on the Value axis:
This is an example of how to use more than one column on the Value axis.
Click the arrow next to the plus sign on the Value axis.
Select a new column from the menu.
Comment: A column can also be dragged from the Data panel to the column selector.
Response: (Column Names) is automatically added to the Category axis. For more information on (Column Names), see the Non-Column Selections page.
To use more columns on the Value axis, repeat the steps above.
Comment: When the number of columns used on the Value axis exceeds three, the name of each column is no longer displayed, only how many columns are selected.
To display intermediate totals
You can display bars representing intermediate calculated totals in waterfall charts where a categorical coloring is used, or in waterfall charts with a hierarchy on the category axis.
Right-click the visualization to display the pop-up menu.
Select Total bars.
Select the column containing the values after which you want to display totals.
To show separate waterfalls per categorical color
In a waterfall chart where a categorical coloring is applied, you can show separate waterfalls per color.
Right-click the waterfall chart to display the pop-up menu.
Select Properties.
Go to the Appearance page.
Beneath Show one waterfall, select Per categorical color.
To show separate waterfalls per category on the category axis
In a waterfall chart where a categorical coloring is applied, you can show separate waterfalls per category on the category axis.
Right-click the waterfall chart to display the pop-up menu.
Select Properties.
Go to the Appearance page.
Beneath Show one waterfall, select Per value on category axis.
To continue a waterfall over trellis panels
In a trellised waterfall chart, the waterfall can continue over multiple trellis panels instead of starting from zero in each trellis panel.
Right-click the trellised waterfall chart to display the pop-up menu.
Select Properties.
Go to the Appearance page.
Select the Continue over trellis check box.
Click the arrow next to the check box to select over which individual trellis panels the waterfall should continue; Pages, Panels, Rows, and Columns.
Response: The first value in a following trellis panel starts where the last value ended in the previous panel.