Stacked Column Chart Excel With Two Columns?

Charts & pivot tables · Updated November 20, 2026

Yes—Excel can make a stacked column chart from two columns of values, but the chart needs at least two data series to create meaningful stacked segments. If your two columns are one category column and one values column, you will get one series rather than a true stack; arrange the data so each category has two or more value columns, then select it and choose Insert > Insert Column or Bar Chart > 2-D Stacked Column.

What “two columns” can mean

The phrase can describe two different things: two columns in the worksheet, or two vertical columns in the finished chart. Those are not necessarily the same. In a stacked column chart, Excel groups data by category, then stacks the values from multiple series into one vertical column for each category. Each colored section of that column represents one series.

For example, suppose the worksheet has a column for quarter and two columns for product sales:

  • Quarter: Q1, Q2
  • Product A: 40, 32
  • Product B: 25, 38

There are three worksheet columns, but the chart shows two stacked columns—one for Q1 and one for Q2. Each chart column has two segments, one for each product. By contrast, if the worksheet contains only a category column and a single sales column, Excel can draw a regular column chart, but there is only one series to show, so there is nothing to stack against another series.

Arrange the worksheet data first

Use one row per category and one value column per series. Put clear series names in the top row and category labels in the first column. Avoid blank header cells, merged cells, and explanatory notes inside the data range, because Excel may interpret them as chart data or create confusing labels.

A small example could look like this:

  • Row 1: Quarter | Product A | Product B
  • Row 2: Q1 | 40 | 25
  • Row 3: Q2 | 32 | 38

Select the entire range, including the headers and category names. Excel uses the first row to name the series and the first column to label the category axis. If your data is arranged the other way around, with series listed down the rows, it can still be charted; Excel may simply choose the opposite orientation. You can change that after inserting the chart.

Create a two-series stacked column chart

  1. Arrange the data with category labels in the first column and at least two numeric series in adjacent columns.
  2. Select the complete data range, including its headers.
  3. On the ribbon, choose Insert > Insert Column or Bar Chart.
  4. Under 2-D Column, choose Stacked Column. Do not choose Clustered Column if you want the series segments placed on top of one another.
  5. Review the chart title, category labels, and legend. Use Chart Design > Add Chart Element to add or adjust elements such as axis titles or data labels.

In some Microsoft 365 layouts, the chart options may appear in a gallery or a Recommended Charts dialog. Choose the Stacked Column subtype, rather than a 3-D option, if you want the standard two-dimensional chart. On Mac, the Insert tab also contains the chart options, although the ribbon layout can differ slightly by Excel version. Excel for the web has chart insertion and formatting options too, but some advanced formatting controls available in the desktop app may not be present.

Choose the right stacked chart subtype

A standard Stacked Column chart preserves the actual value scale. In the example, Q1 totals 65 and Q2 totals 70, so the Q2 column is taller. This is the best choice when readers need to compare both the overall totals and the individual contributions, while remembering that only the bottom segment shares a common baseline. Comparing the heights of segments higher in the stack can be harder.

A 100% Stacked Column chart scales each category to 100%. It is useful for comparing proportions, such as the percentage of sales contributed by each product in each quarter. It does not show the absolute totals: a category totaling 65 and one totaling 700 will both reach the same height. A 3-D stacked chart adds perspective that can make segment sizes harder to judge, so 2-D is usually easier to read for precise comparisons.

If the real goal is to compare each series side by side, choose Clustered Column instead. With clustered columns, the two products appear next to each other for each quarter rather than combining into a single total-height column. The chart type should match the question: stacked for composition and totals, 100% stacked for share, and clustered for direct series comparisons.

Check the series and category orientation

After insertion, look at the legend and horizontal axis. If the legend lists Q1 and Q2 while the axis lists Product A and Product B, Excel has treated the rows and columns in the opposite way from what you intended. Select the chart and choose Chart Design > Switch Row/Column. For the example, the desired result has Product A and Product B in the legend and Q1 and Q2 on the category axis.

If switching orientation does not fix the chart, use Chart Design > Select Data to inspect the chart data range and series. Each series should point to the intended numeric cells, and the category-axis labels should refer to the category names. This is especially helpful when you added a column after making the chart or selected an incomplete range. You can also edit the source cells directly; a chart linked to those cells normally updates when their values change.

Format stacks, colors, and labels

Use the legend to identify the series, and choose colors with enough contrast to distinguish adjacent segments. A consistent color for each product across multiple charts makes comparisons easier. Select a series to format its fills, or use Chart Design > Change Colors to choose from the available palettes. Keep the chart title specific, such as Sales by Quarter and Product, so readers know what the stacks represent.

Data labels can show the values inside or near the segments. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position. Labels are useful for a chart with a few categories, but they can overlap or become cluttered when there are many small segments. Consider showing labels only when exact values matter, and retain the value axis for context.

Excel stacks the series in an order based on the chart’s series list. If you want a different series at the base or top, open Chart Design > Select Data and adjust the series order. A stacked chart does not automatically provide a separate, reliable total label above each column in every layout. You can describe totals in a nearby table, add a total column to the source data for reference, or use a carefully designed helper series when labels above the stacks are essential. Avoid adding total values as an ordinary extra series: that would stack the totals on top of the components and make the columns misleading.

Common problems and what they mean

  • The chart shows separate columns, not stacks: The selected subtype may be Clustered Column. Use Chart Design > Change Chart Type and select Stacked Column.
  • Only one colored segment appears: The range may include only one numeric series, or the other values may be blank or stored as text. Check that each intended series has numeric values and a proper header.
  • The chart shows two columns but no segments: You may have a category column and one value column. Add another numeric series for each category if you need a true stack.
  • Categories and series look reversed: Try Chart Design > Switch Row/Column, then verify the legend and axis labels.
  • Some columns are shorter or unexpectedly missing: Check for blank cells, zeros, filtered rows, or negative values. Negative values are plotted below the baseline rather than contributing to the positive stack, which can change how totals look.

For a quick check, compare a category’s chart height with the sum of its source values. For Q1, 40 plus 25 equals 65; for Q2, 32 plus 38 equals 70. If the standard stacked columns do not reflect those totals, confirm that the chart includes both series and that the intended chart type and data range are selected.

When another chart type is clearer

Stacked columns are not automatically the best answer just because the data has two value columns. If the main question is whether Product A sold more than Product B in each quarter, clustered columns make the direct comparison easier because both series start from the same baseline. If the question is how each quarter’s total is divided between products, stacked columns communicate that composition while still showing total size.

For many categories or long labels, a stacked bar chart—with horizontal bars—may fit better. For changes over many time periods, a line chart may make trends easier to follow, though it does not show composition in the same way. If there is only one value series, use a regular column chart unless you can meaningfully split the values into components. Adding arbitrary segments just to make a stacked chart work would misrepresent the data.

Frequently Asked Questions

Can I make a stacked column chart with only two worksheet columns?
Yes, but if one column contains category names and the other contains values, those columns define only one series. The chart can have one column per category, but each column will have a single segment. To show a meaningful stack, include at least two numeric series as well as the category labels.

Does a stacked column chart show two columns?
It shows one chart column for each category, not one for each worksheet column. Two categories produce two chart columns; two series produce two stacked segments within each category column. The number of chart columns is determined by the number of categories being plotted.

How do I change a clustered chart into a stacked chart?
Select the chart and choose Chart Design > Change Chart Type. Choose Stacked Column under the 2-D Column options and confirm. If the data still appears in an unexpected arrangement, use Chart Design > Switch Row/Column.

What is the difference between stacked and 100% stacked columns?
A standard stacked chart uses the original values, so column height represents the category total. A 100% stacked chart gives every category the same full height and shows each series as a share of that category. Use the latter to compare proportions, not absolute totals.

Can Excel show totals above stacked columns?
It can be done, but total labels are not the same as ordinary segment data labels. For a simple chart, display the totals in a nearby table or add them in a separate, clearly labeled way. Do not add totals as a normal stacked series, because that would count the components twice visually.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.