What a stacked bar graph shows and when to use it
A stacked bar graph displays multiple data series as segments within a single bar, so you can see both the total and how each part contributes to it. If you track monthly expenses by category — rent, utilities, groceries, transport — a stacked bar lets you compare total spending month to month while showing what ate up the budget each time.
Use a stacked bar when you want to emphasize the whole and its parts together. If you care more about comparing individual categories across time (utilities in January versus February), a regular grouped bar chart works better. If the number of categories changes or gets very large, the stacked bar becomes hard to read because only the bottom segment sits on a fixed axis.
Excel calls this chart type "Stacked Bar" (horizontal bars) or "Stacked Column" (vertical bars). The steps are identical — the only difference is which direction the bars run.
Key Takeaways
- Arrange your data in columns: one column for the category labels, then one column for each data series you want to stack.
- Select all your data including headers, then go to Insert > Chart and choose the Stacked Bar or Stacked Column type.
- Excel builds the chart automatically, but you can edit the title, axis labels, and legend by double-clicking the chart and using the Chart Design tab.
- If your data changes, the chart updates automatically as long as you stay within the original selection range.
How to arrange your data before you start
Excel reads data in a specific layout. Put your category names (the labels for each bar) in the first column. Put the name of each data series across the top row as a header. Then fill in the numbers below each header.
Here is a real example. Say you track quarterly sales by region:
| Quarter | North | South | East | West |
|---|---|---|---|---|
| Q1 | 12000 | 8500 | 15000 | 9200 |
| Q2 | 14000 | 9100 | 16500 | 10100 |
| Q3 | 13500 | 10200 | 17000 | 11300 |
The Quarter column becomes the bar labels. North, South, East, and West become the stacked segments. Each number is the value for that region in that quarter. Do not leave blank cells — if a data point is zero, enter 0.
Selecting your data and inserting the chart
Click on the cell in the top-left corner of your data (including headers) and drag to the bottom-right cell that contains a number. You can also click the top-left cell, hold Shift, and click the bottom-right cell. The selection should be a rectangle with no gaps.
With the data selected, go to the Insert tab at the top of the ribbon. Click Chart (or Insert Chart depending on your Excel version). A dialog box opens showing chart types on the left side.
Look for Bar or Column in the list on the left. Click it. On the right side, you will see different versions of that chart type. Choose the one labeled Stacked Bar or Stacked Column — it shows bars or columns divided into colored segments. Click it, then click OK or Create.
Excel builds the chart and places it on your worksheet. The chart is selected (you will see a border around it). You can click and drag it to move it, or drag a corner to resize it.
Editing the title, labels, and legend
Double-click the chart to enter edit mode. The ribbon changes to show Chart Design and Format tabs. The chart now has a gray border and small handles at the corners.
To change the title, click the title text at the top of the chart. A text box appears. Delete the old text and type a new title. Click outside the chart when you are done.
To label the axes, right-click the axis you want to label (the bottom or left edge of the chart) and choose Add Axis Title. A text box appears on that axis. Type the label — for example, "Quarter" for the bottom axis or "Sales ($)" for the left axis.
The legend (the colored box showing what each color means) appears by default on the right. To move it, go to the Chart Design tab and click Add Chart Element > Legend, then choose a position. To remove it entirely, click Legend and select None.
Changing colors and formatting the segments
Right-click any colored segment in the chart and choose Format Data Series. A panel opens on the right side. Under Fill, you can pick a solid color, gradient, or pattern for that entire series (all segments of one color across all bars).
If you want to change just one segment, click it once to select the whole series, then click it again to select only that one segment. Right-click and format it the same way.
To change the order of the segments (so North appears on top instead of at the bottom), right-click the legend and choose Format Legend. Go to the Legend Entries (Series) tab. Select a series name and use the up or down arrow to move it.
Updating the chart when your data changes
If you edit a number in your original data range, the chart updates automatically. You do not have to rebuild it.
If you add new rows or columns to your data, the chart does not automatically include them. Double-click the chart to edit it. Go to Chart Design > Select Data. The Select Data Source dialog opens. Click Edit under Horizontal (Category) Axis Labels and adjust the range to include your new rows. Then click Edit under Legend Entries (Series) and adjust the range to include your new columns. Click OK when you are done.
Common problems and how to fix them
If your chart looks wrong, the most common cause is that Excel misread which row or column contains labels. Double-click the chart, go to Chart Design > Select Data, and check that the Horizontal Axis Labels range points to your category column (Quarter, in the example above). If it points to a data column instead, click Edit and fix the range.
If one segment is missing or the colors are wrong, check your original data for blank cells or text where numbers should be. Excel skips blank cells and may misinterpret text as a label. Fill in any blanks with 0 and make sure all data cells contain numbers only.
If the bars are too thin or too thick, click the chart and go to Chart Design > Change Chart Type. Select your stacked bar type again and look for a Series Overlap or Gap Width option. Adjust the slider to make bars wider or narrower, then click OK.
Frequently Asked Questions
Can I make a stacked bar graph with more than four or five categories?
Yes, but the chart becomes harder to read. More than six or seven segments in one bar makes it difficult to compare the middle colors across bars. If you have many categories, consider a regular bar chart instead, or break your data into separate stacked charts by grouping.
How do I show the actual numbers on each segment instead of just colors?
Double-click the chart to edit it. Right-click any segment and choose Add Data Labels. Labels appear on each segment showing its value. Right-click the labels and choose Format Data Labels to control what information appears (value, percentage, category name, or a combination).
What is the difference between a stacked bar and a 100% stacked bar?
A regular stacked bar shows actual values, so bars of different heights represent different totals. A 100% stacked bar stretches every bar to the same height and shows each segment as a percentage of the whole. Use 100% stacked when you want to compare proportions rather than totals — for example, what percentage of revenue came from each region, regardless of total sales.
Can I export the chart as an image to use in a document or presentation?
Right-click the chart and choose Copy. Paste it into Word, PowerPoint, or another program. To save it as an image file, right-click the chart, choose Save as Picture, pick a format (PNG or JPG), and choose where to save it.