What a stacked column chart shows and when to use it

A stacked column chart displays multiple data series as segments within a single column, one on top of the other. Instead of showing bars side by side, each column contains all your categories combined into one visual unit. This works best when you want to show both the total of something and how that total breaks down into parts — for example, monthly sales by product type, where you see total revenue at a glance and also which products contributed most to it.

The stacked format is clearer than a regular grouped column chart when the total matters as much as the individual pieces. If you need to compare how one product performs across months, a grouped chart (bars side by side) works better. But if you need to see "total sales went up, and here's why," stacked columns tell that story faster.

Key Takeaways

  • Arrange your data in columns, with categories across the top row and data series down the left column, before you insert the chart.
  • Select all your data including headers, then go to Insert > Column Chart and choose the stacked option from the dropdown menu.
  • Excel builds the chart automatically, but you can edit the title, axis labels, and legend by right-clicking each element.
  • If your data changes, the chart updates on its own because it is linked to the cells you selected.

Arrange your data the way Excel expects it

Excel reads data in a specific layout. Put your category names (the labels for each column) in the first column, starting in cell A2. Put your data series names (the categories you are breaking down) across the top row, starting in cell B1. Then fill in the numbers below each series name.

For example, if you are tracking sales by product across three months, your layout looks like this: Month names in column A (January, February, March), product names across row 1 (Product A, Product B, Product C), and the sales numbers in the grid below. Do not skip rows or leave blank cells in the middle of your data — Excel needs a clean rectangle to work with.

Include the header row and header column in your selection when you build the chart. Excel uses these labels to name the segments and the axis automatically.

Insert the chart and select the stacked column type

Highlight all your data, including the headers. Click the Insert tab at the top of the ribbon. In the Charts group, click Column Chart — a small arrow appears next to it. Click that arrow to open the dropdown menu.

You will see several column chart options. The stacked version is usually in the second row. Hover over each one to see its name: look for Stacked Column (not "Clustered Column," which shows bars side by side). Click it, and Excel inserts the chart into your sheet.

Edit the chart title and labels

The chart appears with a default title like "Chart Title." Click directly on that text to select it, then type your own title. Press Enter when you are done. A good title tells the reader what they are looking at — "Sales by Product, Q1 2024" is clearer than "Monthly Data."

Right-click the vertical axis (the numbers on the left side) to add or change its label. Select Add Axis Title, then type what those numbers represent — "Sales in Dollars" or "Units Sold." Do the same for the horizontal axis if the category names are not clear on their own.

The legend (the box showing which color is which product) appears automatically on the right. If it is in the way, right-click it and choose Delete. You can also right-click it and select Format Legend to move it to the bottom or top of the chart.

Adjust colors and segment order if needed

Each data series gets its own color automatically. To change a color, right-click one of the colored segments in the chart and select Format Data Series. A panel opens on the right side. Click Fill and choose a new color.

The order of segments (which product appears at the bottom, which at the top) follows your data order from left to right. If you want Product B at the bottom instead of Product A, move the Product B column to the left in your data table, and the chart updates on its own.

Update the chart when your data changes

The chart is linked to the cells you selected. If you change a number in your data table, the chart updates automatically — you do not have to rebuild it. If you add a new row or column of data, you may need to update the chart's data range. Right-click the chart, select Select Data, and adjust the range to include the new data.

If you copy the chart to another sheet or file, it brings the data with it. The chart will not update if the original data changes, but it will show the values from the moment you copied it.

Common reasons a stacked column chart does not look right

If your segments are in the wrong order, check your data table. The leftmost data column becomes the bottom segment; the rightmost becomes the top. Rearrange your columns to match the order you want.

If the chart looks empty or shows only one color, you may have selected only one data series instead of all of them. Delete the chart and start over, making sure to highlight the entire data range including all headers.

If the axis numbers are too large or too small, right-click the vertical axis and select Format Axis. You can set the minimum and maximum values manually to zoom in or out on your data.

Frequently Asked Questions

Can I show percentages instead of raw numbers in a stacked column chart?

Yes. Right-click the chart, select Select Data, then look for an option to change the data labels. You can also right-click individual segments and choose Format Data Labels to display percentages. Some versions of Excel require you to calculate percentages in your data table first, then build the chart from those numbers.

What is the difference between a stacked column chart and a 100% stacked column chart?

A regular stacked column shows actual values, so taller columns mean larger totals. A 100% stacked column stretches every column to the same height and shows each segment as a percentage of the whole. Use 100% stacked when you want to compare proportions across categories rather than absolute amounts.

How do I move the chart to a different location on the sheet?

Click the chart once to select it (you will see a border around it), then drag it to a new spot. To move it to a different sheet entirely, right-click it, select Cut, go to the other sheet, right-click an empty cell, and select Paste.

Can I print just the chart without the data table?

Yes. Click the chart to select it, then go to File > Print. Excel will print only the selected chart. If you do not select the chart first, it prints the entire sheet including the data.

What if I want to add data labels showing the exact numbers on each segment?

Right-click the chart and select Add Chart Element > Data Labels. Choose where you want the labels to appear (center, inside end, or outside end). For stacked charts, inside end usually works best so the labels do not clutter the chart.