Excel Stacked Bar Chart: Reverse Series or Category Order

Charts & pivot tables · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, you can reverse the order of the colored segments by rearranging the chart’s data series, or reverse the top-to-bottom category order by formatting the category axis. These are separate settings, so choose the one that matches what looks wrong.

What “reverse order” means in a stacked bar chart

A stacked bar chart displays categories as horizontal bars and divides each bar into segments for the data series. For example, a chart of quarterly sales might show one bar per quarter, with segments for Online, Retail, and Wholesale. There are two different orders to consider: the order of the segments within each bar, and the order of the bars from top to bottom.

Excel controls segment order through the chart’s series list. Category order is controlled through the vertical category axis. Changing one does not automatically change the other. A third setting, the legend order, is usually tied to the series order, so rearranging series can also rearrange the legend entries.

  • Segments are in the wrong sequence: reorder the series.
  • Categories are upside down: reverse the category axis.
  • The legend is in the wrong sequence: reorder the series, then check the legend.

These directions apply to regular stacked bar charts and 100% stacked bar charts. The percentage version changes how Excel scales the bars, but not the basic distinction between series order and category order.

Reverse the stacked segments by reordering series

Use this method when you want the colored sections to stack in a different sequence. In a standard horizontal stacked bar, the first series begins at the value axis, normally on the left, and the next series continues from the end of the first. Moving a series in the list changes where it appears in the stack.

  1. Select the chart so the chart tabs appear on the ribbon.
  2. Go to Chart Design > Select Data.
  3. In the Select Data Source dialog, find the Legend Entries (Series) list.
  4. Select the series to move, then use the up or down arrow controls to change its position.
  5. Select OK and review both the bars and the legend.

For example, suppose the current series order is Online, Retail, Wholesale, and you want Wholesale to be the segment nearest the zero baseline. Select Wholesale in the series list and move it to the top. Excel redraws the stacks using the new series order. If you need Online nearest the baseline instead, put Online first.

The list position, rather than the series name or numerical size, determines the sequence. Excel does not sort series by value when it builds a stacked chart. You can repeat the move controls to arrange several series, and the chart updates without changing the order of rows or columns in the worksheet.

Reverse the category order from top to bottom

If the correct categories appear in the wrong vertical sequence—for example, January is at the bottom but you want it at the top—reverse the category axis. This changes where category labels are placed, not which colored series begins each stack.

  1. Click the vertical axis labels on the left side of the chart. These are the category names, such as months, products, or departments.
  2. Right-click and choose Format Axis. The Format Axis pane opens.
  3. Under Axis Options, select Categories in reverse order.
  4. Close the pane or click elsewhere, then check the category sequence and the value axis placement.

This setting is especially useful when your worksheet lists categories in a natural order from top to bottom, but Excel displays the first category at the bottom of a horizontal bar chart. Reversing the category axis puts the first category at the top while retaining the same data values and series stacking.

When the categories reverse, Excel may move the horizontal value axis to the top of the plot area. That is a consequence of which end of the category axis is now considered the maximum. If you prefer the value axis at the bottom, select the category axis again and look in Axis Options for the Horizontal axis crosses setting. Choosing At maximum category can put the value axis at the opposite edge; check the result because the best choice depends on the chart layout and labels.

Reverse both orders without changing the data

You can reverse segment order and category order independently. First use Chart Design > Select Data to arrange the series. Then use Format Axis > Axis Options > Categories in reverse order for the category axis. This lets you, for instance, put the oldest month at the top and move a particular series nearest the baseline.

It is usually safer to change the chart settings rather than physically rearrange the worksheet just to make the picture look right. Sorting or moving source rows and columns can affect formulas, other charts, and downstream reports. The chart’s series and axis options change its presentation while leaving the underlying table intact.

Before making changes, note the intended order in plain language: which category should be at the top, and which series should be closest to zero? This avoids the common mistake of fixing one order and assuming the other has changed too. For a 100% stacked chart, the same controls apply, although segment lengths represent shares of each category total rather than raw totals.

Why the chart order may differ from the worksheet

Excel reads a chart’s categories and series from the selected source range, but the chart can display them in an orientation that is not immediately obvious. In a typical table, category names are in the first column and series names are in the top row. Excel uses those labels to create the category axis and legend entries. The order in the Select Data Source list is the useful reference for segment sequence.

If a chart seems to have the wrong interpretation altogether—for example, each product is a segment when you wanted each month to be a segment—the issue may be whether rows or columns are plotted as series. In Chart Design > Switch Row/Column, Excel changes which dimension of the source range becomes the series. This is not the same as reversing a sequence. Use it only when the chart has grouped the data in the wrong direction; otherwise, reorder the specific series in Select Data.

Also distinguish the category axis from the value axis. In a horizontal bar chart, category names are on the vertical axis and numerical values run along the horizontal axis. This differs from a column chart, where categories run along the horizontal axis. If you format the value axis by mistake, you may find number-scale settings rather than the category-reversal checkbox.

Common problems and how to fix them

  • The bars reverse, but the segments do not. You changed the category axis. To alter segments, reorder the series in Select Data.
  • The colored stack changes, but categories stay put. You changed the series list. Format the vertical category axis to change top-to-bottom order.
  • The legend also changes. This is expected when you move series. The legend generally follows the series list, so inspect it after reordering. If you need a different legend arrangement without changing the stack, Excel’s legend formatting options may offer a layout change, but they do not redefine the data series.
  • The axis labels look reversed but the data did not change. Category-axis reversal changes display order; it does not sort the worksheet or alter values.
  • The categories look backward after reversing. Check the Horizontal axis crosses option. Excel may relocate the value axis, making the chart feel inverted even though the category order is as intended.
  • The series arrows are unavailable or unclear. Confirm that the chart is selected and that you are in Select Data Source. If necessary, select the chart and use the Chart Design ribbon tab again.

For a quick diagnosis, click a bar segment and identify whether the selected item is a series or a category. Selecting a legend entry typically highlights that series across the chart; selecting an axis label targets a category. This can help you confirm which control you need before changing the chart.

Excel for Mac and Excel for the web

In Excel for Mac, select the chart and use the chart design tab’s Select Data command to reorder series. To reverse categories, select or Control-click the category axis and open Format Axis, then look for the reverse-category option in Axis Options. Ribbon labels and pane placement can vary slightly by release, but the underlying distinction between series order and axis order remains the same.

Excel for the web has chart editing tools, but some chart formatting controls can differ from the Windows desktop app and may not be available for every chart or workbook. If you cannot find the category reversal setting or series reorder controls in the browser, choose Open in Desktop App and make the change in Excel for Microsoft 365 on Windows or Mac. The workbook’s source data does not need to be converted to use the desktop controls.

Which order should you choose?

Choose the setting based on the story the chart should tell, not merely on the order Excel picked automatically. Keep a consistent series order across related charts so readers can compare the same color in each one. A common convention is to put the most important or foundational component nearest the baseline, then stack the remaining components in a deliberate sequence. For categories, chronological order is often easiest to scan, with the earliest or latest period at the top depending on the report’s convention.

For example, if each bar shows a team’s completed, pending, and blocked tasks, you might place Completed nearest zero and keep the legend in that same order across several charts. If the bars represent years, you might put the earliest year at the top and subsequent years below it. Neither arrangement is inherently correct for every chart; consistency, readable labels, and the purpose of the comparison matter more.

When the category labels contain dates, numbers, or a meaningful progression, verify that reversing the axis produces the intended visual order. It is a display choice, not a replacement for sorting source data when the table itself also needs to be ordered. For a chart that will be copied into a presentation or report, check that axis labels, legend, and any data labels remain readable after the change.

Frequently Asked Questions

How do I reverse the order of bars in an Excel stacked bar chart?
Right-click the vertical category axis, choose Format Axis, and select Categories in reverse order under Axis Options. This reverses categories from top to bottom.

How do I reverse the order of stacked segments?
Go to Chart Design > Select Data, select a series under Legend Entries (Series), and use the up or down controls to move it. The series list determines the segment order.

Can I reverse the legend without reversing the stack?
Moving a series in Select Data generally changes both its stack position and its legend position. You can change the legend’s visual layout, but a different legend sequence does not change which data series each segment represents.

Why did my value axis move to the top?
Reversing the category axis can change where Excel places the horizontal value axis. Check the category axis’s Horizontal axis crosses setting and choose the placement that fits the chart.

Does reversing the chart change my worksheet data?
No. Reversing series order or category-axis order changes the chart’s display settings. It does not sort, move, or recalculate the source values.

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.