What a stacked bar chart shows and when to use one

A stacked bar chart is a bar chart where each bar is divided into segments, with each segment representing a different category. Instead of showing bars side by side, the segments stack on top of each other within a single bar. This layout makes it straightforward to see both the total for each bar and how much each segment contributes to that total.

Use a stacked bar chart when you want to compare totals across groups while also showing what makes up each total. For example, you might use one to show monthly sales broken down by product type, or quarterly expenses split between departments. The chart lets you see at a glance which months had the highest sales overall, and which product contributed most to each month.

A stacked bar chart works best when you have two or three categories to stack. If you have more than four, the smaller segments become hard to read and compare. For that situation, a regular grouped bar chart (bars side by side) often works better.

Key Takeaways

  • Arrange your data in a table with one column for the category labels, and one column for each data series you want to stack.
  • Select your entire data range including headers, then go to Insert and choose the stacked bar chart type.
  • Excel will create the chart automatically, but you can resize it, move it, and change the title to match your data.
  • Right-click any part of the chart to edit colors, axis labels, and the legend so the chart tells your story clearly.

Organizing your data before you create the chart

Before you insert a chart, your data needs to be arranged in a specific way. Create a table with one column on the left for your category labels — these become the labels along the bottom of the chart. Then create one column for each data series you want to stack. For example, if you are tracking sales by product type across months, your first column would be the month names, and the next columns would be one for each product.

Make sure your first row contains headers — the category label column should have a header like "Month" or "Region", and each data column should have a header like "Product A" or "Product B". Excel uses these headers to label the legend and axes. Do not leave blank rows or columns within your data range, as Excel may stop reading your data early.

Here is a straightforward example layout:

MonthProduct AProduct BProduct C
January500030002000
February600035002500
March550040003000

Selecting your data and inserting the chart

Click on the first cell of your data table — the one containing your first header — and drag to select the entire range including all headers, labels, and numbers. You can also click the first cell and then hold Shift while clicking the last cell in your range. The selection should include the category labels in the first column and all the data columns you want to stack.

Once your data is selected, go to the Insert tab at the top of the ribbon. In the Charts group, you will see a button for bar charts. Click the small arrow next to it to open the chart type menu. Look for Stacked Bar — it shows bars with colored segments stacked horizontally. Click it, and Excel will insert the chart into your worksheet.

The chart appears on top of your data. You can click and drag it to move it to a blank area of your worksheet, or drag the corners to resize it. If you want the chart on a separate sheet, right-click it and choose "Move Chart", then select "New sheet".

Editing the chart title and labels

By default, Excel may label your chart "Chart Title". Click on that text to select it, then type a new title that describes what the chart shows — for example, "Sales by Product, January to March" or "Department Spending by Quarter". Press Enter when you are done.

The axis labels — the text along the bottom and left side of the chart — usually come from your data headers. If they are hard to read or too small, right-click the chart and choose "Edit Data". This opens a small window showing your original data range. You can adjust the range here if you need to include or exclude columns.

To change the axis titles themselves, right-click the chart, choose "Add Chart Element", then select "Axis Titles". You can add a title for the horizontal axis (the one showing your categories) and the vertical axis (the one showing the numbers). These titles help anyone reading the chart understand what the numbers represent.

Changing colors and the legend

Right-click any colored segment in one of the bars to select that entire data series. All segments of the same color will highlight. Right-click again and choose "Format Data Series" to open a panel where you can change the color. Pick a color that contrasts well with the others so each segment is straightforward to see.

The legend appears on the right side of the chart by default and shows which color represents which product or category. If the legend is in the way, right-click it and choose "Format Legend". You can move it to the bottom, top, or left side of the chart. If you want to remove it entirely, right-click it and press Delete — though a legend usually helps readers understand what they are looking at.

If a data series name in the legend is unclear or misspelled, go back to your original data table and edit the header in that column. The chart will update automatically to show the new name.

Adjusting the axis scale and gridlines

By default, Excel sets the scale of the vertical axis (the numbers) automatically based on your data. If you want to change where the axis starts or ends, right-click the numbers along the vertical axis and choose "Format Axis". You can set a minimum and maximum value, or change how often the gridlines appear.

Gridlines are the faint horizontal lines behind the bars that help you read the values. If they are too faint to see, right-click them and choose "Format Major Gridlines" to make them darker or thicker. If there are too many gridlines and the chart looks cluttered, you can reduce how often they appear by changing the interval in the Format Axis panel.

Frequently Asked Questions

Can I make a stacked bar chart with more than three data series?

Yes, but readability suffers. With four or more segments per bar, the smaller segments become hard to distinguish and compare. If you have many data series, consider a grouped bar chart instead, where bars sit side by side rather than stacked.

How do I change a stacked bar chart to a regular bar chart?

Right-click the chart and choose "Change Chart Type". Select the regular bar chart option (not stacked), and click OK. Your data stays the same; only the layout changes.

What if my data includes negative numbers?

Stacked bar charts can show negative numbers, but they become confusing because segments stack in both directions. For data that includes both positive and negative values, a regular grouped bar chart or a line chart usually works better.

Can I export the chart as an image to use in a document or presentation?

Right-click the chart and choose "Copy". Then open your document or presentation and paste it. You can also right-click the chart, choose "Save as Picture", and pick a file format like PNG or JPG to save it separately.