How to Create a 100% Stacked Bar Chart
Data Format
Same shape as a stacked bar 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 bar.
- Value 1, Value 2, Value 3... (required, numeric): each column is one segment. Every bar is rescaled to the same total length, so raw values only matter relative to each other within a row.
Chart Elements
A 100% stacked bar chart uses the same style panel as a stacked bar chart, see the Stacked Bar Chart guide for the full control set. What's different:
Bars
Set Mode to 100% Stacked. Every category is rescaled to the same total length, and each segment shows as a percentage of that bar instead of its raw value.
Axis Labels
X Min and X Max default to 0 and 100 (percent) instead of a range calculated from your data, and the X axis Suffix defaults to "%" automatically unless you set your own.