How to Create a Stacked Bar Chart in Excel (Step-by-Step)
Stacked bar charts are a native Excel chart type available in all versions — both horizontal (stacked bar) and vertical (stacked column) variants. They show how multiple series contribute to a total across categories. The most common issue is Excel swapping rows and columns, which is a one-click fix. This guide also covers the 100% stacked variant for comparing composition rather than totals.
What is a stacked bar chart in Excel?
A stacked bar chart in Excel places multiple data series end-to-end within each bar, so the full bar length represents the total while each colored segment shows one series' contribution. The horizontal version is called a stacked bar chart; the vertical version is a stacked column chart — both are inserted from the same chart menu. A 100% stacked variant normalizes all bars to the same length and shows segments as percentages, making it easier to compare composition across categories.
6 steps to make a stacked bar chart in Excel
Prepare your data
Rows represent categories (e.g. regions, products, quarters). Columns represent series (e.g. revenue streams, expense types, demographics). The first column should be your category labels. Each additional column is one segment in the stack. Headers in both the first row and first column are important — Excel uses them for the legend and axis labels.
Select your data range
Click and drag to select all rows and columns including headers. For example, if you have 5 categories and 3 series, select a 6×4 range (including headers). Do not include total rows or columns — they would add an extra segment equal to the sum of all others.
Insert the stacked chart
For horizontal bars: Insert → Charts → Insert Bar Chart → Stacked Bar. For vertical bars: Insert → Charts → Insert Column Chart → Stacked Column. Both variants are in separate menus — bar and column chart types are listed separately in Excel.
Fix orientation if Excel misreads it
Excel sometimes swaps what it treats as categories vs series, producing a chart with bars and segments in the wrong direction. If this happens: right-click the chart → Select Data → Switch Row/Column. This transposes the data interpretation without changing your source data.
Add data labels
Chart Elements (+) → Data Labels. Labels appear on each segment showing raw values. For small segments where the label doesn't fit, reduce the font size to 7–8pt or remove labels for segments below a threshold (you can delete individual labels by selecting them and pressing Delete).
Switch to 100% stacked for composition comparison
If you want to compare how composition varies across categories rather than absolute totals: right-click → Change Chart Type → select 100% Stacked Bar (or 100% Stacked Column). All bars now extend to the same width/height. Add data labels showing Percentage via Format Data Labels → Percentage.
When to use a stacked bar chart in Excel
Revenue breakdown by segment over time
Show how total revenue grows while also revealing which segments are driving growth. Each quarter is a bar; each segment is a revenue stream.
Budget allocation across departments
Compare how each department's budget is split across expense categories. The total bar length shows budget size; segments show where it goes.
Survey response distributions
100% stacked bars are ideal for Likert scale data — each bar is a question; segments are strongly agree, agree, neutral, disagree, strongly disagree. Composition comparison across questions is instant.
Headcount by team and level
Show workforce composition across departments. Each bar is a department; segments are seniority levels or roles. Both totals and composition are readable simultaneously.
Components of a stacked bar chart in Excel
Bars / columns
Each bar represents one category. Bar length equals the sum of all segment values for that category.
Segments
Colored sections within each bar, each representing one data series. Segments are stacked end-to-end. The stacking order is set in Select Data → Legend Entries.
Series legend
Color-coded key matching segment colors to series names. Positioned below or beside the chart.
100% normalization
In the 100% stacked variant, all bars extend to the same length regardless of total value. Segment sizes represent percentages, not absolute values. Useful when composition comparison matters more than totals.
Frequently Asked Questions
Related