Difference between revisions of "Chart Label value from Range"
(Created page with "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. File:Labels from Range.png...") |
|||
| Line 1: | Line 1: | ||
| − | The capacity to set Excel chart label from a range in now supported in XLCubed Web Edition. | + | The capacity to set Excel chart label from a range in now supported in XLCubed Web Edition.<br> |
This can be used to add totals to stacked bar charts. | This can be used to add totals to stacked bar charts. | ||
Revision as of 12:46, 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
