How to Create a Stacked Bar Chart in Excel

A stacked bar chart shows how the parts of something add up to a whole, using horizontal bars split into colored segments. It’s a good fit for things like sales by region broken down by quarter, survey answers by department, or budget spending by category. Each bar shows the total, and each segment shows one piece of it.

Excel can build one in a few clicks. This guide covers how to lay out your data, insert the chart, fix the common annoyances (like Excel listing your categories upside down), add totals, and decide when a 100% stacked bar is the better choice.

Stacked Bar vs. Stacked Column vs. 100% Stacked

Excel offers three closely related options, and picking the right one up front saves you rework:

• Stacked bar uses horizontal bars. It works best when your category names are long or you have many categories, because the labels sit on the left and are easy to read.
• Stacked column is the same idea with vertical bars. It suits time-based categories like months. See our guide on how to make a stacked column chart in Excel.
• 100% stacked bar stretches every bar to the same length and shows each segment as a percentage of its bar. Use it when you care about proportions rather than totals.

Microsoft’s overview of available chart types in Office describes every bar chart variant, including the 3-D versions.

How to Create a Stacked Bar Chart in Excel

Step 1: Organize your data

Put your categories (the bars) in the first column and each segment in its own column to the right, with a header row on top. Here’s a simple example:

Region	Q1	Q2	Q3	Q4
North	120	135	150	160
South	90	110	105	130
East	75	80	95	100
West	140	125	155	170

Each region becomes one bar, and Q1 to Q4 become the colored segments. Avoid blank rows or columns inside the range, and don’t include a Total row or column in your selection, because Excel would stack it as an extra segment.

Step 2: Select the data

Click the top-left cell (the blank corner above your category names) and drag to the bottom-right cell, including the headers. Excel uses the headers for the legend and the first column for the axis labels.

Step 3: Insert the chart

1. Go to the Insert tab.
2. In the Charts group, click Insert Column or Bar Chart (the icon with small bars).
3. Under 2-D Bar, choose Stacked Bar. Hover over each icon to see a preview and its name.

You can also click Recommended Charts, open the All Charts tab, choose Bar and pick Stacked Bar. In Excel for Mac and Excel for the web, the steps are the same: Insert > Bar (or the column/bar icon) > Stacked Bar.

Step 4: Check rows and columns

If Excel made your quarters into bars and your regions into segments, select the chart and click Chart Design > Switch Row/Column. Excel guesses based on the shape of your data, and it doesn’t always guess right.

Step 5: Add a title and labels

Click the chart title placeholder and type a descriptive title. Then click the Chart Elements button (the plus sign beside the chart) and check Data Labels to show each segment’s value, and Axis Titles if the units aren’t obvious.

Customize Your Stacked Bar Chart

Fix categories that appear in reverse order

Bar charts plot the first category at the bottom, so your list often looks upside down. To fix it, right-click the vertical (category) axis, choose Format Axis and check Categories in reverse order. Under Horizontal axis crosses, choose At maximum category so the value axis stays at the bottom.

Make the bars thicker

Right-click any segment, choose Format Data Series and lower the Gap Width under Series Options. Around 50% to 80% usually looks good. Keep Series Overlap at 100% so the segments stay stacked.

Change segment colors

Click a segment once to select the whole series, then use Format > Shape Fill to pick a color. For a quick palette change, use Chart Design > Change Colors. Our guide to editing a graph in Excel covers more formatting options.

Reorder the segments

Right-click the chart, choose Select Data, click a series in the Legend Entries (Series) list and use the up and down arrows. The first series appears closest to the axis. You may also want to edit the legend in Excel so the names read clearly.

Add totals at the end of each bar

Excel doesn’t have a built-in total label for stacked bars, but you can add one with a helper series:

1. Add a Total column to your data with a SUM formula for each row.
2. Right-click the chart, choose Select Data, click Add and select the Total column as a new series.
3. Select the new Total segment, add data labels to it, and set the label position to Inside Base.
4. Set the Total segment’s Shape Fill to No Fill and delete its legend entry.

The totals now sit just past the end of each visible bar. If the axis stretches too far, set a fixed Maximum under Format Axis.

Format the value axis and numbers

Right-click the horizontal (value) axis and choose Format Axis. Under Bounds, set a fixed Minimum of 0 and a sensible Maximum so the bars don’t look squashed. Under Number, choose a category such as Currency or Number and set the decimal places. If your values are large, set Display units to Thousands or Millions to keep the labels short.

Move the legend

A legend at the top often reads better than one on the right for a bar chart, because it lines up with the segments. Click Chart Elements > Legend and choose Top. If you only have two or three segments, you can delete the legend and label the segments directly instead.

Use the chart in PowerPoint or Word

Copy the chart with Ctrl + C and paste it into your slide or document. Use Paste Special and choose a linked option if you want the chart to update when the Excel data changes. Our guide on how to link an Excel chart to PowerPoint walks through it.

When to Use a 100% Stacked Bar Chart

If your regions have very different totals, a regular stacked bar makes it hard to compare the mix inside each bar. A 100% stacked bar fixes that by making every bar the same length. It’s ideal for survey results (agree, neutral, disagree) or market share. Insert it from the same menu, or change an existing chart with Chart Design > Change Chart Type. Turn on data labels and format them as percentages if your source data contains raw numbers.

Common Uses for Stacked Bar Charts

• Sales or revenue by region, split by product line or quarter.
• Survey responses by group, often as a 100% stacked bar.
• Project timelines. A Gantt chart is a stacked bar with an invisible first segment. See how to make a Gantt chart in Excel.
• Budget spending by department, split into categories.

Troubleshooting Stacked Bar Charts

• The bars are side by side, not stacked. You picked Clustered Bar. Use Chart Design > Change Chart Type and choose Stacked Bar.
• A Total row appears as its own bar. Remove the total row or column from the data range with Select Data.
• Numbers show as one long segment. Your values are stored as text. Convert them to numbers (look for a green triangle in the cells) and the chart will update.
• Gaps or missing segments. Blank cells are plotted as zero or gaps. Click Select Data > Hidden and Empty Cells to change how they’re handled.
• Negative values look odd. Stacked bars handle negatives poorly because they stack to the left of zero. Consider a clustered bar instead.
• The chart doesn’t update with new rows. Format your data as a table with Ctrl + T before creating the chart so new rows are included automatically.

Tips for Better Stacked Bar Charts

• Keep the number of segments to five or fewer. More than that makes the colors hard to tell apart.
• Put the most important series first so it lines up with the axis and is easy to compare.
• Sort your categories by total so the longest bar is at the top.
• Use consistent colors across related charts in the same report.
• Save a finished chart as a template by right-clicking it and choosing Save as Template.

Frequently Asked Questions

What is a stacked bar chart?

It’s a horizontal bar chart where each bar is divided into segments. The full bar shows a total, and each segment shows how much one part contributes to it.

What’s the difference between a stacked bar and a stacked column chart?

Only the direction. Stacked bars run horizontally, and stacked columns run vertically. Bars are easier to read with long category names.

Can I add more data to an existing stacked bar chart?

Yes. Right-click the chart, choose Select Data and add a series, or drag the colored range handles in the worksheet to include the new rows or columns.

How do I show percentages instead of values?

Change the chart to a 100% stacked bar, then add data labels. If your data is raw numbers, calculate percentages in helper columns and label from those, since Excel won’t convert labels to percentages automatically.

How do I save my chart as a template?

Right-click the chart and choose Save as Template. To reuse it, go to Insert > Recommended Charts > All Charts > Templates.

Wrapping Up

A stacked bar chart takes less than a minute to create once your data is laid out with categories in the first column and segments across the top. Fix the reversed category order, thicken the bars, and add totals if your audience needs them. When proportions matter more than totals, switch to a 100% stacked bar.

Related: how to make a stacked column chart in Excel.