2. Selecting data

More complex displays are possible using multiple measures, or multiple hierarchies added to COLUMNS (Series). Doing this will stack each set of values on each bar. This can be useful for showing how several sub items affect the total.

2.1. Totals and aggregators

As the chart shows cumulative effects, the measure's Aggregator should be set to Sum, which will ensure that the totals that are displayed on the chart reflect this cumulative total. Using other aggregations is possible, but may not display the desired result on the chart.

Subtotal bars will be displayed if there are multiple hierarchies or multiple levels selected on Rows in the Data Analysis Panel.

3. Properties

The Grand Total bar is hidden by default. To show it, un-check Hide Grand Total in the Properties window's Main tab for the chart.

A waterfall chart (sometimes called a 'bridge' chart) typically displays connecting lines bridging bars that start or end at the same position. They can be turned off by setting Connecting Line Style to None in the series Look properties.

4. States

A common choice for waterfall charts is to visually distinguish between bars with positive versus negative values. This can be achieved by using states. For more information, see the Set up states on a metric set article.