100 stacked bar chart / Chart type guide
100% Stacked Bar Chart: Meaning, Examples, and Excel Tips
A 100% stacked bar chart gives every bar the same total length and shows how each segment contributes to 100% of the category.
What a 100% stacked bar chart shows
Each bar is normalized to 100%, so the chart compares composition rather than absolute size.
Best use cases
Use 100% stacked bars when the share of each part matters more than the total.
- Survey response percentages
- Market share by region
- Budget mix by department
- Traffic channel share by month
100% stacked vs regular stacked bar chart
A regular stacked chart shows totals and composition. A 100% stacked chart removes total size and focuses only on percentages.
Excel data format
Use one category column and one numeric column for each segment. Excel can calculate the percent view when you choose the 100% stacked chart type.
When to avoid it
Avoid 100% stacked bars when total size matters, because every bar is forced to the same length.
Copyable data
CSV example
Use this small dataset to test whether the chart structure fits your use case.
channel,Organic,Paid,Referral,Direct
January,45,20,15,20
February,42,24,14,20
March,50,18,12,20FAQ
What does 100% stacked bar chart mean?
It means every bar represents 100% of a category, and each segment shows its share of that category.
Can Excel make a 100% stacked bar chart?
Yes. Select your data, open Insert, then choose the 100% stacked bar or 100% stacked column option.
When is a regular stacked chart better?
Use a regular stacked chart when the total value of each category is important.
Last updated: 2026-07-06