Customize a stacked column or bar chart
This page contains instructions for applying typical customizations for the stacked bar and column chart types.
How do I show the total of all the subcategories in a stacked bar or column?
A stacked column chart effectively illustrates the breakdown of a larger category into smaller subcategories and their relative proportions. However, with numerous subcategories, discerning the total sum can become challenging. So try showing the total in the tooltip.
To achieve this:
1. Create a
stacked column chart
2. Add
this data to the data grid, ensuring column D is not assigned to a series
3. Enter the editor and enable data labels at Customize > Basic > Data labels > Visibility On
4. Go to
Basic >
Tooltip > then paste this into the tooltip body field
Total: {total}
5. The total now shows in the body of the tooltip
