How to Create a Stacked Bar Chart in Excel

A stacked bar chart is one of Excel's most practical visualization tools — it lets you show both individual values and their contribution to a whole, all in a single glance. Whether you're comparing quarterly sales across product lines, tracking survey responses by category, or breaking down a budget by department, a stacked bar chart communicates layered data more efficiently than multiple separate charts ever could.

Here's exactly how to build one, what your options are, and which variables determine how your chart should be set up.

What Is a Stacked Bar Chart?

A stacked bar chart displays multiple data series as segments within a single bar. Each bar represents a total, and each colored segment within it represents a component of that total.

Excel offers two main variants:

Use the standard version when the totals themselves matter. Use the 100% version when you only care about how the parts compare proportionally.

Step-by-Step: Creating a Stacked Bar Chart in Excel

Step 1 — Organize Your Data

Before touching a chart, your data layout matters enormously. Excel reads stacked bar charts most reliably when structured in a specific way:

• First column: Category labels (e.g., months, regions, product names)
• Subsequent columns: Each data series you want stacked (e.g., Product A, Product B, Product C)
• No blank rows or columns within your data range

Example layout:

Step 2 — Select Your Data Range

Click and drag to highlight the entire table, including headers. Excel uses these headers to label your chart's legend automatically.

Step 3 — Insert the Chart

1. Go to the Insert tab on the Ribbon
2. Click the Bar Chart icon (it looks like horizontal bars) in the Charts group
3. In the dropdown, choose Stacked Bar or 100% Stacked Bar

📊 If you want vertical stacked bars (columns), choose the Column Chart icon instead and select "Stacked Column" — the mechanics are identical, just oriented differently.

Step 4 — Adjust the Chart Layout

Excel generates the chart immediately. From here, you'll typically want to:

• Edit the chart title — click it directly and type a descriptive name
• Modify the legend — drag it to a better position or use the Chart Design tab to adjust
• Change colors — click any segment, then right-click → Format Data Series to adjust fill colors
• Add data labels — right-click any segment → Add Data Labels to display values inside each segment

Step 5 — Refine Axes and Series Order

The order your data series appear in the spreadsheet determines the stacking order in the chart. If the visual hierarchy doesn't match your intent:

1. Right-click the chart → Select Data
2. In the Legend Entries (Series) panel, use the up/down arrows to reorder series
3. Click OK — the stacking order updates instantly

For axis formatting, right-click either axis → Format Axis to adjust scale, number format, or interval.

Key Variables That Affect Your Chart Setup 🔧

Not every stacked bar chart is built the same way. Several factors shape how you should approach yours:

Data volume: Charts with more than 6–8 stacked segments per bar become visually cluttered and hard to read. If your data has many categories, consider grouping smaller ones into an "Other" bucket before charting.

Excel version: The chart interface has evolved across Excel 2016, 2019, 2021, and Microsoft 365. The core steps above apply to all modern versions, but the Design and Format tab layouts may differ slightly. Older versions (pre-2013) use a different ribbon structure entirely.

Data orientation: If your categories run across columns rather than down rows, Excel may interpret the axes differently. You can correct this via Select Data → Switch Row/Column inside the chart editor.

Negative values: Stacked bar charts handle negative values awkwardly — segments appear below the baseline and can distort the visual. If your data includes negatives, a grouped bar chart or waterfall chart is often a cleaner alternative.

Platform: Excel on Mac, Windows, and Excel Online (Microsoft 365 in a browser) all support stacked bar charts, but the Online version has fewer formatting options. Mobile versions of Excel have very limited chart customization.

Standard vs. 100% Stacked — Choosing the Right Type

This decision has a bigger impact than most users expect:

• If a stakeholder needs to know that Q3 revenue was $9,700 total, use the standard stacked bar — the bar length carries that information.
• If the question is "what share of Q3 revenue came from Product B?" — the 100% stacked bar makes proportions immediately obvious without requiring mental math.

Mixing up these two types is one of the most common charting mistakes in Excel. The visual looks similar enough that audiences may not notice, but the conclusions they draw can be meaningfully different.

Common Formatting Decisions That Change the Reading

Gap width controls how thick or thin your bars appear. A narrower gap (larger bars) works well for dense comparisons; wider gaps suit simpler datasets. Right-click any bar → Format Data Series → Gap Width to adjust.

Gridlines can be removed entirely for cleaner presentations or kept for precision reading. Toggle them via the Chart Elements button (the + icon on the chart edge).

Data label placement inside segments works well when segments are large enough to fit readable text. For thin segments, outside-end labels or a data table below the chart are cleaner options.

The right combination of these choices depends on where the chart is going — a slide deck, a printed report, an internal spreadsheet, or a dashboard — and how much data density your audience expects to engage with.