To reverse the order of the colored sections in an Excel stacked column chart, select the chart and choose Chart Design > Select Data, then move the series up or down in the Legend Entries (Series) list. To reverse the left-to-right order of the columns instead, format the horizontal category axis and select Categories in reverse order; these are two different settings.
What “reverse order” can mean
A stacked column chart displays categories along the horizontal axis and combines multiple data series into each vertical column. Because “order” can refer to either dimension, first decide what you want to change:
- Stack order: Changes which series appears at the bottom, middle, or top of each column. It can also change the order of the series in the legend.
- Category order: Changes where the columns appear from left to right, such as reversing the sequence of months or products.
- Legend order only: Excel’s standard chart controls generally link the legend to the plotted series order. Reordering the series changes both; the legend is not an independent stack-order control.
Neither operation reverses the values within a series, changes the worksheet’s source data, or turns a stacked chart into a different chart type. If you want the tallest category first, for example, that requires sorting the source data or otherwise arranging categories—not reversing the stack.
Reverse the order of the stacked series
In Excel for Microsoft 365 on Windows, use the chart’s data-source controls. This changes the plotting order of the series without requiring you to rearrange the worksheet cells.
- Click the stacked column chart to show the chart tabs on the ribbon.
- Choose Chart Design > Select Data.
- In the Select Data Source dialog, find Legend Entries (Series).
- Select the series you want to move, then use the up or down arrow buttons beside the list to change its position.
- Choose OK and check the resulting stacks and legend.
For a typical stacked column chart, the first series in the list forms the bottom section of each column, and later series are placed above it. Moving a series earlier in the list therefore moves it closer to the bottom; moving it later puts it higher. If you want the top and bottom series to exchange places while keeping the middle series in place, move one series at a time and verify the result rather than assuming that a single “reverse” command exists.
The same series-order idea applies to a 100% stacked column chart: the columns still show each series as a proportion of the category total, but the series’ vertical placement changes. The total and each segment’s proportion do not change merely because the series order changes.
Reverse the left-to-right category order
If the stack colors are already in the right order but the columns run from newest to oldest, reverse the category axis instead. In a column chart, the categories are on the horizontal axis at the bottom of the chart.
- Click the horizontal category-axis labels, such as the month names, to select that axis.
- Right-click and choose Format Axis. You can also use the contextual Format tab when the axis is selected.
- In the Format Axis pane, open Axis Options.
- Turn on Categories in reverse order.
- Review the chart and adjust the value-axis crossing if its position is no longer suitable.
This setting reverses the displayed category sequence; it does not sort or move the original worksheet rows. For example, a chart with January, February, and March can display March, February, and January while the source table remains in its original order. That distinction matters if formulas, other charts, or reports depend on the table’s current arrangement.
Keep the value axis on the side you expect
After reversing categories, Excel may place the vertical value axis on the opposite side of the chart. This can be surprising, but it is a consequence of where the axes cross after the category direction changes. The chart’s values have not been reversed.
To adjust the crossing, select the horizontal category axis again and inspect Format Axis > Axis Options for Vertical axis crosses. Depending on the chart and Excel’s displayed options, setting the crossing to At maximum category can put the value axis back on the left. Check the chart after changing it: the best setting depends on whether the first displayed category should sit beside the vertical axis or at the far end of the plot area.
Axis labels and gridlines can also look different when the crossing point changes. If labels overlap or appear on an unexpected side, use the axis-formatting pane to review label position and crossing options rather than changing the series order. These controls affect chart layout, not the underlying values.
Understand the relationship to worksheet data
Excel builds the chart’s categories and series from the selected source range. The Select Data dialog separates the two: the Legend Entries (Series) list controls series, while the category-axis labels are specified separately. This is why moving an item in the series list is the right fix for stack order, whereas formatting the category axis is the direct fix for left-to-right direction.
You can also change the order by rearranging series columns or rows in the source table, but that changes the worksheet layout and may affect other workbook content. Use that approach when the data itself should be stored in the new order. Use Select Data when the existing table order is useful and only this chart needs a different presentation.
Switch Row/Column, available from the chart design controls, is not a reverse-order command. It swaps which dimension Excel treats as the series and which it treats as the categories. The chart may change substantially, so use it only when Excel has interpreted the rows and columns the wrong way around.
A concrete example: monthly product sales
Suppose a worksheet has months in rows and three product columns: Basic, Plus, and Pro. Each month appears as one column in the chart, with the three product values stacked. If Basic should be at the bottom, Plus in the middle, and Pro at the top, arrange those series in that order in the Select Data Source list. If the chart currently stacks Pro at the bottom, move Pro down the list or move Basic above it, then inspect the chart and legend.
Now suppose the stack itself is correct but the month labels run from December at the left to January at the right. Select the horizontal axis and enable Categories in reverse order. The products remain stacked in their previous sequence. If the vertical scale shifts to the right, change the category-axis crossing option as described above.
These are independent choices: a chart can have a reversed series order, a reversed category order, both, or neither. Changing one setting does not automatically correct the other. This is useful when a report needs the latest month first while keeping a consistent color-to-product mapping.
Common problems and practical checks
- The wrong thing reversed: If the colors moved but the columns did not, you changed series order. If the columns changed direction but the stack did not, you changed category order. Return to the relevant control rather than repeating the other operation.
- The legend now reads differently: The legend normally follows the series order. Check it after moving series, especially if readers use the legend to identify segment colors.
- The chart looks unchanged: Verify that you selected the chart or the category axis, not a data point. In the Select Data dialog, make sure you moved an entry under Legend Entries (Series), not changed the axis-label range.
- The colors seem inconsistent: Confirm the series names and color-to-series mapping after reordering. Do not infer a product’s identity from its vertical position alone; use the legend and, if needed, data labels.
- The source table appears unchanged: That is expected when you reorder series through Select Data or reverse the axis. Those chart settings do not rearrange worksheet cells.
- The order returns after editing: Recheck the chart’s source range and series list. If the chart is based on a changing range or refreshed data, confirm its series are still present and ordered as intended after the update.
Before sharing a report, inspect at least one category with values in every series. A series with a zero or blank value may not show a visible segment, which can make a stack order appear different from what it is. Also verify that colors, legend labels, and any data labels remain readable in the reversed layout.
Excel for Mac and Excel for the web
The instructions above target Excel for Microsoft 365 on Windows. Excel for Mac also provides chart design and axis-formatting controls, although ribbon arrangement and dialog presentation can differ by release. Look for the chart’s Select Data command to reorder series and the Format Axis pane for category direction. Keyboard shortcuts are not needed for either change, so no Windows-to-Mac shortcut substitution is necessary.
Excel for the web can edit many chart properties, but available chart controls may vary. If you cannot find the series-order arrows or the category-reversal option in the browser, open the workbook in the desktop Excel app and make the change there. The chart should then retain its formatting when saved to the workbook.
Frequently Asked Questions
Can I reverse only the order of the colors in a stacked column chart?
Yes. Reorder the series in Chart Design > Select Data. This changes the stack order and ordinarily the legend order, but it does not reverse the category sequence along the horizontal axis.
Does “Categories in reverse order” reverse the stack?
No. It reverses the order of the category labels and columns along the horizontal axis. To move segments from top to bottom or bottom to top, reorder the series in the Select Data Source dialog.
Why did my vertical axis move to the right?
Reversing the category direction can change the axes’ crossing point. Select the category axis, open Format Axis, and review the Vertical axis crosses setting. Choose the crossing position that places the value axis where you want it.
Can I reverse the chart without changing my worksheet data?
Yes. Use Select Data to move series or Format Axis to reverse categories. Both changes affect the chart display rather than sorting or rearranging the source cells.
Is Switch Row/Column the same as reversing the order?
No. Switch Row/Column swaps the chart’s interpretation of rows and columns, changing which data groups are categories and which are series. Use it only when Excel has assigned those roles incorrectly.
Related
- Excel Shortcut to Select to the Bottom of a Column
- Excel Shortcut to Select All Rows in a Column at Once
- Excel Shortcut to Change Lowercase to Uppercase Text
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Make a Linear Graph in Google SheetsTo make a linear graph in Google Sheets, put your data in columns, select the range, and choose…
- Excel Pivot Table Dates: How to Group and Sort by WeekTo sort PivotTable dates by seven-day periods in Excel for Microsoft 365 on Windows, right-click a date in…
- Excel Pivot Table Won’t Sort? Fixes for Common Sorting ProblemsIf an Excel PivotTable will not sort, select an item in the field you want to reorder, right-click…
- Pivot Chart Colors by Value in Excel: Setup GuideExcel PivotCharts do not automatically change each data point’s color according to its value, and worksheet conditional formatting…
- Excel Pie Chart With Other Category: How to Group SlicesTo make an Excel pie chart with an Other category, select the data and choose Insert > Insert…
- Add a Line to a Waterfall Chart in ExcelExcel for Microsoft 365 does not provide a supported Combo Chart option for adding a data-driven line series…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.