#Waterfall chart series#

This is because it is has the same value as Operating Profit and is adjacent in the list. Note that, in this example, Item X from the original column of data (step 1) is not displayed. The waterfall chart is displayed on the dashboard: Click Publish to Dashboard and select a target dashboard.

#Waterfall chart series#

To choose a different color for a series, click the colored box next to the series name ( Increment, Decrement, Totals) and select a color from the palette.

For waterfall charts, this only hides increments and decrements, not aggregates.

To hide any items with a value of zero, select the Hide Detail Zero Values check box.

If required, select Auto Axis or Rotate Axes.

Click the Chart button on the Anaplan Toolbar and select Waterfall Chart.

Further occurrences of a value will share the same color. If there are more than nine values, the color sequence begins again. The first color in the palette is assigned to the first value the second color is assigned to the second value and so on. The chart displays End Total as the label.ДЄlthough the default colors are green for an Increment, red for a Decrement, and blue for Totals, you can choose different colors in Chart Options when generating the chart. If it does not finish on an aggregate, the chart will automatically generate a total based on the preceding values. If the waterfall chart finishes on a valid aggregate it will take the name of that aggregate as the label for the total. Waterfall charts will always display an end total. If there are two consecutive aggregates of the same value in the hierarchy, the aggregate closest to the top of the hierarchy is displayed - see the example below. The list or line items must always be on rows and any non-numeric data in the selection is ignored.ДЄggregates are only displayed if all the values selected are aggregates of the same value type. If you select multiple columns, only the data from the first column will be used to generate the chart. A waterfall (cascade) chart is a special type of column chart that is used to show how an initial value is increased. Only a single column of data is used to generate a waterfall chart. This chart type belongs to PowerCharts XT.

Any line items that don't have a parent are ignored, and will not be included in the waterfall chart.

Composite lists (parent hierarchies) cannot be used to create a waterfall chart.

You should consider these points before selecting data: You can create a waterfall chart from data in a simple list or from line items.