How to Create a 100% Stacked Column Chart
Data Format
Same shape as a stacked column chart, Category plus two or more value columns. What changes is how the values are displayed, not the data itself.
| Category | Value 1 | Value 2 | Value 3 |
|---|---|---|---|
| Q1 | 24 | 12 | 6 |
| Q2 | 29 | 14 | 8 |
| Q3 | 27 | 13 | 7 |
| Q4 | 33 | 17 | 9 |
- Category (required): the label for each column.
- Value 1, Value 2, Value 3... (required, numeric): each column is one segment. Every column is rescaled to the same total height, so raw values only matter relative to each other within a row.
Chart Elements
A 100% stacked column chart uses the same style panel as a stacked column chart, see the Stacked Column Chart guide for the full control set. What's different:
Bars
Set Mode to 100% Stacked. Every category is rescaled to the same total height, and each segment shows as a percentage of that column instead of its raw value.
Axis
Y Min and Y Max default to 0 and 100 (percent) instead of a range calculated from your data.
Axis Tick Labels
The Y axis Suffix defaults to "%" automatically unless you set your own.