stacked bar chart excel / Step-by-step workflow
Stacked Bar Chart in Excel: Data Format, Options, and Fixes
To make a stacked bar chart in Excel, arrange categories in the first column, put each segment in its own value column, select the table, then insert a stacked bar or stacked column chart.
- 01
Use the right Excel data layout
Use one row per category and one numeric column per segment. Keep headers short, avoid merged cells, and remove blank rows inside the chart range.
- 02
Choose stacked bar or stacked column
Select the table, open Insert, choose Bar Chart or Column Chart, then select the stacked option. Use horizontal stacked bars for long category labels.
- 03
Use 100% stacked bars for percentages
Use 100% stacked bars when the percent composition matters more than the raw totals. This is common for survey responses, market share, and budget mix.
- 04
Fix unreadable segment labels
Sort the categories when ranking matters, shorten long labels, reduce the number of segments, and move labels outside when the segments are too small.
- 05
When Excel data should become a CSV
If you plan to reuse the chart online, export a clean CSV with category and segment columns so the same data can be previewed in a bar chart maker.
Copyable data
Use this starter table
Paste this into a spreadsheet or preview it in the chart tool before styling.
category,Product A,Product B,Product C
North,40,35,25
South,30,45,25
West,25,30,45FAQ
What data format works best for a stacked bar chart in Excel?
Use categories in the first column and segment values in separate numeric columns.
What is the difference between stacked bar and 100% stacked bar in Excel?
A stacked bar uses raw totals. A 100% stacked bar normalizes every bar to the same length and shows percent composition.
Why is my stacked bar chart wrong in Excel?
Common causes are merged cells, numbers stored as text, blank rows inside the range, or selecting the wrong chart orientation.
When should I avoid a stacked bar chart?
Avoid it when viewers need exact comparisons for each segment across many categories.
Last updated: 2026-07-06