Chart label value from range

The capacity to set Excel chart label from a range is supported in Anaplan XL Reporting Web Edition.

This can be used to add totals to stacked Excel bar charts.

1. Create the Excel chart from your data.
2. Add Data labels.
3. Turn off the labels except for the last series.
4. Select on the label and directly type in =, and choose the cell that contains the total.
5. Turn off the value in the label formatting.

The chart and the total label will now update with your data.