Excel Stacked Column Chart: Set and Fix the X-Axis

Charts & pivot tables · Updated November 19, 2026

In an Excel stacked column chart, the x-axis is the horizontal category axis along the bottom: it shows the categories being compared, such as months, regions, or products. The colored sections within each vertical column are data series, while the column’s total height is measured on the vertical value axis.

What the X-Axis Represents

A stacked column chart combines two kinds of information. Each position along the x-axis represents one category, and each colored segment represents a series that contributes to that category’s total. For example, a chart of monthly sales might have January, February, and March along the x-axis; separate segments for online, retail, and wholesale sales; and a vertical axis showing the sales values.

The x-axis is sometimes called the horizontal category axis. It does not usually show the series names: those appear in the legend. Nor does it show the total for each column; the height of the full stack conveys that total, read against the vertical value axis. Keeping these roles distinct makes it easier to diagnose a chart that seems to have the wrong labels.

In a standard column chart, the categories are arranged horizontally and values rise vertically. A stacked column chart keeps that arrangement but places the series values on top of one another within each category. This is useful when you want to compare both the total and the parts that make up the total.

Arrange the Source Data

Excel needs to know which cells contain category labels, series names, and values. A clear layout puts the category names in the first column, series names across the first row, and numeric observations in the cells between them. For example, a table could use A1 for Month, B1 for Online, C1 for Retail, and D1 for Wholesale; A2:A4 could contain January through March, with the corresponding sales values in B2:D4.

When you select the complete table, including the headings, Excel generally treats the first column as the x-axis categories and each remaining column as a separate series. The resulting chart has one column for each month, with three stacked segments per column. The legend identifies Online, Retail, and Wholesale.

Before making the chart, check that:

  • Every category has a label in the first column, and each series has a meaningful heading in the first row.
  • The value cells contain numbers, not numbers stored as text. Text values may be ignored or plotted unexpectedly.
  • The selected range includes the headings and category labels, but not unrelated totals or notes.
  • Each row represents one category and each series column represents one comparable component.

You can also arrange series in rows and categories in columns. Excel can often infer that structure, but a column-oriented table is usually easier to inspect and maintain.

Create a Stacked Column Chart

In Excel for Microsoft 365 on Windows, select the data range, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Avoid selecting 100% Stacked Column unless you want each category normalized to the same total height. Excel creates the chart with category labels along the bottom, a value scale on the left, and a legend for the series.

If the chart already exists, select it and use Chart Design > Change Chart Type, then choose the stacked column option under Column. The chart’s data source and series arrangement can be reviewed through Chart Design > Select Data.

The same basic chart type and data concepts apply in Excel for Mac and Excel for the web, although ribbon layout and available formatting controls can differ. If a web or Mac interface does not expose a particular chart option shown in Windows, opening the workbook in the desktop version of Excel for Microsoft 365 is a practical way to access the full set of chart controls.

Set or Correct the Category Labels

If the x-axis shows numbers such as 1, 2, and 3, or displays the wrong range of labels, you can assign the category range directly. Select the chart, choose Chart Design > Select Data, and find Horizontal (Category) Axis Labels in the dialog. Choose Edit, select the cells containing the intended labels, and confirm. For the example table above, that range would be A2:A4.

In the same dialog, the series list is separate from the horizontal-axis label range. Use the series controls to add, remove, or edit series; use the category-label control to specify what appears along the x-axis. This distinction matters: changing a series name changes the legend entry, not the category labels at the bottom.

If Excel has interpreted the rows and columns in reverse, select the chart and choose Chart Design > Switch Row/Column. This changes which direction Excel reads as categories versus series. It is a quick correction when, for example, each month appears in the legend and each product appears on the x-axis even though you intended the opposite. Check the legend and labels afterward, since switching orientation changes both roles.

Format Axis Labels and Titles

Axis labels and an axis title are different things. Labels are the individual category names, such as January or West; an axis title is an optional description such as Month or Region. To add a title, select the chart and choose Chart Design > Add Chart Element > Axis Titles > Primary Horizontal. Click the title box that appears and type a concise description. Do not type a title into the category-label range unless you intend it to become one of the plotted categories.

To change how category labels look, right-click the horizontal axis and choose Format Axis. Depending on the data and chart, Excel provides options for label placement, text direction, and the way it treats categories. A long list of labels may be easier to read if you widen the chart, shorten category names, or rotate the label text. Reducing the number of displayed labels can help with a dense axis, but it can also make individual categories harder to identify.

Dates deserve special attention. Excel may treat date labels as a date axis, spacing them according to time, or treat them as text categories, spacing each entry evenly. In the Format Axis pane, look under Axis Options for the axis-type choices when they are available. A date axis can be useful for a continuous timeline; a text axis is often better when every listed period should occupy an equal category position, even if dates are missing.

For grouped labels such as Year and Quarter, putting those fields in adjacent columns before the values may allow Excel to show multi-level category labels. Review the result carefully: nested labels use more space and can become crowded when there are many categories.

Common X-Axis Problems

A chart can be stacked correctly but still be difficult to interpret if Excel has read the source range differently than expected. The following checks address frequent causes:

  • The axis displays 1, 2, 3: Open Select Data and edit the Horizontal (Category) Axis Labels range. Confirm that the selected cells contain the intended text or dates.
  • Categories appear in the legend: Try Switch Row/Column, then confirm the series names and category labels. The table’s orientation may not match Excel’s initial interpretation.
  • A heading appears as a category: Check that the selected range starts with the intended header row and column. If necessary, correct the axis-label range so it excludes the header.
  • Labels are missing or clipped: Expand the chart, adjust label orientation or placement in Format Axis, or simplify the displayed category names. Check whether the selected range includes all categories.
  • Bars do not match the expected totals: Inspect the source values and series range, and check for numbers stored as text, blank cells, or unintended extra rows and columns.
  • The category order looks backward: In Format Axis, check the category order options. Reversing category order changes the display order, not the underlying values.

Blank cells and zeros can have different meanings. A zero is a measured value of zero; a blank may mean no value was supplied. In the chart’s Select Data dialog, Excel offers a Hidden and Empty Cells setting that controls how empty cells are represented. Choose an interpretation that matches the data rather than filling gaps with zeros merely to make the chart look complete.

Negative values also affect the stack. Excel plots negative contributions below the zero line and positive contributions above it. That can be appropriate for gains and losses, but the positive and negative portions should not be read as though they form one ordinary positive total.

Choose the Right Stacked Chart Type

A standard stacked column chart preserves the actual values and lets readers compare the total height as well as each segment’s contribution. It works best when there are a modest number of categories and series, and the total matters to the question being answered.

A 100% stacked column chart converts each category’s total to 100%. Its x-axis still contains the categories, but the vertical scale represents proportions rather than the original totals. This makes the mix of series easier to compare when category totals differ substantially. It also hides differences in total size: two equal-height columns may represent very different amounts.

A clustered column chart places series side by side rather than stacking them. This can make the same series easier to compare across categories, especially when segment values are similar, but it makes the overall category total less immediate. If the x-axis variable is a true numeric measurement, such as temperature or elapsed time, and the horizontal spacing must reflect numerical distance, use an XY scatter chart instead. A column chart treats its horizontal positions as categories, not as a continuous numeric scale.

Make the Chart Easier to Read

Useful design choices begin with the question the chart is meant to answer. If readers need to compare totals, keep the standard stacked chart and make the vertical scale readable. If they need to compare the composition of categories with different totals, consider 100% stacking. Keep the number of series manageable; many thin segments and similar colors make the legend difficult to follow.

Use series names that are short but clear, and keep the legend order consistent with the stack where possible. If a category has a very long label, wrapping or angled text may be preferable to shrinking the chart until the labels are unreadable. A descriptive horizontal axis title can clarify what the categories represent, but it should not repeat every label or substitute for a useful chart title.

Finally, verify the chart against the source table. For a sample month, add the segment values and check that the resulting total corresponds to the full column height. That simple check can reveal an omitted series, an incorrect data range, or an accidental inclusion of a summary row.

Frequently Asked Questions

What goes on the x-axis of a stacked column chart?
The x-axis shows categories, such as months, departments, or product names. The stacked segments represent separate data series, which are usually identified in the legend.

How do I change the x-axis labels in Excel?
Select the chart and choose Chart Design > Select Data. Under Horizontal (Category) Axis Labels, choose Edit and select the cells that contain the labels you want.

Why does my stacked column chart show 1, 2, 3 on the x-axis?
Excel may not have included or recognized the category-label cells. In Select Data, set the Horizontal (Category) Axis Labels range to the cells containing your actual category names.

Can I put numbers on the x-axis of a stacked column chart?
Yes, numbers can be used as category labels, but Excel spaces column categories as categories rather than according to numeric distance. Use an XY scatter chart when the horizontal values need a true numerical scale.

What is the difference between stacked and 100% stacked columns?
A standard stacked chart shows actual values and totals. A 100% stacked chart scales every category to 100%, making proportions comparable while concealing differences in total size.

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.