Excel Stacked Column Chart with Two Series

Yes. In Excel for Microsoft 365 on Windows, put your category labels in the first column and the two series in the next columns, select the data, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Excel draws one column per category, with the two series segments stacked to show both their parts and their combined total.

What a two-series stacked column chart shows

A stacked column chart combines two or more data series in a single vertical column for each category. Each series appears as a separate colored segment, and the full height of the column represents the sum of those values. With two series, the chart can show how each category’s total is divided between two components while also making totals easy to compare.

For example, suppose a small shop tracks online and in-store orders by month. A stacked column for each month can show both order channels as segments, while the column’s total height shows all orders that month. If online orders are 40 and in-store orders are 60, the column totals 100 and contains segments of 40 and 60.

This chart is most useful when the series are parts of a meaningful whole and share the same unit. It is less suitable when the main task is comparing the two series precisely across categories: the bottom segment starts at a common baseline, but the top segment starts at different heights. A clustered column chart often makes that comparison easier.

Arrange the source data

Use a simple rectangular table with one header row. Put category names in the first column and one series in each additional column. For example:

Column A: Month
Column B: Online orders
Column C: In-store orders

Enter the months in A2:A5 and the corresponding values in B2:C5, with the headings in A1:C1. Select the whole range, including the headings, before inserting the chart. Excel uses the first row for series names and the first column for category labels. Including those headings makes the legend and axis clearer than selecting only the numbers.

Keep each category on its own row and each series in its own column. Avoid blank rows or columns inside the table, merged cells, and extra totals mixed into the data. A grand-total column is not a third component of the stacked chart; including it as a series would stack the total on top of its own parts and misrepresent the data. If totals are useful, calculate or display them separately.

Create the chart in Excel for Windows

Select the category labels, both series headers, and all the values you want to chart.
On the ribbon, choose Insert > Insert Column or Bar Chart.
Under 2-D Column, select Stacked Column. Do not choose Clustered Column or 100% Stacked Column unless that is the view you intend.
Check that the legend names the two series and the horizontal axis shows the categories. If Excel has interpreted the layout incorrectly, use Chart Design > Switch Row/Column.

After insertion, click the chart to reveal the chart-specific ribbon tabs. Use Chart Design > Add Chart Element to add items such as axis titles, data labels, or a chart title. The Chart Design tab also offers chart styles and color choices. The Format tab provides controls for selected chart elements, including individual series.

Excel for the web has a similar workflow: select the data and use Insert to choose a column chart type, then select the stacked option. Ribbon labels and available formatting controls can vary slightly by browser and product update. On Excel for Mac, select the data and use Insert > Column or Bar Chart, then choose a stacked column subtype; the precise gallery layout can differ from Windows. The chart concept and the need for a clean category-by-series table are the same.

Choose the right stacked chart type

Excel’s related column types answer different questions, so choosing the right one matters:

Stacked Column: Shows the actual value of each series and the combined total. Use it when totals and component amounts both matter.
100% Stacked Column: Scales every column to 100%. It emphasizes the proportion contributed by each series, but hides differences in the actual totals. A category with 20 items and one with 200 items will have columns of equal height.
Clustered Column: Places the two series side by side for each category. Use it when comparing the individual series values is more important than showing a combined total.

A common misconception is that a stacked chart automatically shows percentages. It does not: a standard stacked column displays the values supplied in the worksheet. To show shares, either choose 100% Stacked Column or calculate and chart percentage values deliberately. Do not label raw counts as percentages or infer a 100% total when the series do not represent the complete whole.

Read and format the chart clearly

The legend identifies the two series, while the category axis identifies the groups, such as months or departments. The vertical axis gives the scale for the total column height. A clear title should say what is being measured and, when needed, the period or unit. An axis title such as Orders or Revenue can prevent readers from guessing what the numbers mean.

Use contrasting but related colors so viewers can distinguish the two segments. Keep the same series colors throughout a workbook or report when charts are meant to be compared. To change colors, select a series and use the formatting controls on the Format tab, or choose a suitable option under Chart Design > Change Colors. Avoid relying on color alone if the chart will be printed in grayscale or viewed by people with color-vision differences; direct labels or a clear legend can help.

Data labels can identify segment values, but labels on every segment may crowd a chart with many categories. Select the chart, then use Chart Design > Add Chart Element > Data Labels and choose a position. For two series, labels inside each segment can work when segments are large enough. If the total is the key message, a separate total label may be more useful, but Excel does not always offer a built-in total-label choice for a stacked chart. You can create helper data or add text boxes, though text boxes may need manual adjustment when the chart changes.

Gridlines can help estimate values, but too many visual elements compete with the data. Keep the vertical scale consistent when comparing separate charts, and avoid truncating the value axis in a way that exaggerates small differences. A zero baseline is especially important for column charts because column lengths encode magnitude.

Check series order and chart interpretation

The series order determines which segment appears at the bottom and which appears above it. If the order makes the chart harder to read, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, use the series list and its move controls to change the order. This changes the stacking order and legend order, not the values in the worksheet.

For a useful visual comparison, consider placing the series that readers should track most consistently at the bottom. Its columns share the zero baseline, making its values easier to compare across categories. The upper series is still visible, but its segment begins at the height of the lower series, so comparing its segment lengths takes more effort.

Stacking also changes how negative values appear. Excel plots positive and negative values on opposite sides of the zero line rather than treating every segment as a simple positive addition. When the dataset mixes signs, inspect the chart carefully and explain what the positive and negative amounts mean. A stacked column may not communicate net totals as simply as a different chart or a table.

Common problems and how to fix them

The legend lists months instead of the two series: Excel may have read rows as series and columns as categories. Try Chart Design > Switch Row/Column, then confirm the legend and axis labels.
The chart has one column per value or unexpected categories: Check the selected range. Include one category column and exactly the two series columns, without unrelated cells or a totals column.
A series is missing: Verify that its heading and numeric cells are inside the selected range. In Chart Design > Select Data, check whether the series appears and whether its values point to the intended cells.
Numbers are treated as zero or omitted: Check for values stored as text, formulas returning empty text, or blanks. Convert text-formatted numbers to numeric values and decide whether blanks mean zero or unknown; those meanings are not interchangeable.
The chart is crowded: Reduce the number of categories, widen the chart, shorten labels, or remove unnecessary data labels. If there are many categories, a bar chart or a different presentation may be easier to read.

If the source table grows, an Excel Table can make the data easier to manage and can help a chart include new rows when the table expands. Select the source range and use Insert > Table, confirming that the table has headers. Check the chart after adding data, because chart behavior can depend on how its data range was originally created and on the workbook’s structure.

When another chart or layout is better

Choose a clustered column chart when the main question is whether online orders exceeded in-store orders in each month. Both series start from the same baseline, so their heights are easier to compare. Choose a 100% stacked chart when the composition matters more than the count, such as comparing the share of two customer types across regions.

A line chart can be more appropriate for a long time series when the focus is the direction of change rather than monthly totals. A data table may be preferable when exact values matter more than visual patterns. If the two series do not form meaningful parts of one total—for example, temperature and sales—stacking them is misleading, especially if they use different units. Use separate charts or a chart type suited to the relationship instead.

Frequently Asked Questions

Can a stacked column chart have exactly two series?
Yes. Select one category field and two series fields, then choose Stacked Column. Excel also supports more series, but extra segments can make the chart harder to interpret.

How do I show totals on top of stacked columns?
A standard stacked chart displays total height but may not add a total label automatically. You can use a helper range containing the totals and add labels or a separate series, but take care not to display that total as another stacked component. For simple charts, a nearby table may be clearer.

What is the difference between stacked and 100% stacked?
Stacked Column shows actual values, so column height represents the sum. 100% Stacked Column makes every column the same height and shows each series as a share of its category total.

Why are my two series appearing side by side?
You likely selected Clustered Column rather than Stacked Column. Select the chart, use Chart Design > Change Chart Type, and choose the stacked column subtype.

Can I change which series is on the bottom?
Yes. Open Chart Design > Select Data and change the order of the entries in the series list. Confirm that the legend order and visual stacking order communicate the chart correctly.

Should I use a stacked column chart for percentages?
Use 100% Stacked Column when each category should be compared as a complete 100% whole. Use ordinary Stacked Column for actual amounts, and verify that the values in each category genuinely add up to the whole you want to describe.

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.