Difference between revisions of "Chart Label value from Range"
| Line 11: | Line 11: | ||
; Turn off the value in the label formatting | ; Turn off the value in the label formatting | ||
[[File:Label range value.png|750px|center]] | [[File:Label range value.png|750px|center]] | ||
| + | |||
| + | The chart and the total label will now update with your data. | ||
[[Category:Grid Reporting]] | [[Category:Grid Reporting]] | ||
[[Category:Visualisations]] | [[Category:Visualisations]] | ||
Revision as of 12:49, 25 November 2022
The capacity to set Excel chart label from a range in now supported in XLCubed Web Edition.
This can be used to add totals to stacked bar charts.
Example Setup
- Create the Excel chart from your data as normal
- Add Data labels
- Turn off the labels except for the last series
- Click on the label and directly type in "=" and select the cell that contains the total
- Turn off the value in the label formatting
The chart and the total label will now update with your data.
