Excel Bar Chart Reverse Order: Steps, Options, and Fixes

Yes. Select the bar chart’s category axis, open Format Axis, and under Axis Options turn on Categories in reverse order. This reverses the displayed category sequence, so the first category in the source data appears at the bottom and the last appears at the top.

What reversing a bar chart actually changes

A standard horizontal bar chart has a vertical category axis, which lists labels such as product names or months, and a horizontal value axis, which shows the numeric scale. In Excel, the Categories in reverse order setting changes the visual order of those labels. It does not change the data in the worksheet, reverse the values, or sort the source table.

For example, suppose a table lists North, South, East, and West from top to bottom. Reversing the category order makes West appear at the top and North at the bottom. The bar lengths still represent the same values, and the series still correspond to the same data. This is useful when you want the first row of your table to appear at the top of a chart, or when a ranked chart needs its largest or most important category in a particular position.

The wording can be confusing because Excel calls the option Categories in reverse order, even though readers may describe the task as reversing the bar chart. It applies to the category labels. A separate setting controls where the numeric axis crosses the chart, and series order is controlled elsewhere.

How to reverse category order in Excel for Windows

In Excel for Microsoft 365 on Windows, you can change the order from the chart itself without rearranging worksheet rows. Use these steps:

Click the bar chart, then click one of the category labels along its vertical axis. Make sure the labels are selected, rather than the bars or the value axis.
Right-click the selected axis and choose Format Axis. The Format Axis pane opens.
In the pane, select Axis Options if it is not already active. The icon and layout can vary slightly with pane size.
Under Axis Options, select Categories in reverse order.
Check the chart. If the value axis has moved to the top and you want it at the bottom, use the axis-crossing adjustment described in the next section.

You can also select the axis and use the chart-formatting controls to open the Format Axis pane. If you repeatedly select the wrong chart element, click once on the chart and then click directly on a category label. The selected object should be the vertical axis, not an individual label or a data series.

On Excel for Mac, select or Control-click the category axis and choose Format Axis to open the formatting pane; the available controls are similar, though the pane’s appearance and menu arrangement can differ. In Excel for the web, chart formatting options may be presented differently from the Windows desktop app. If the setting is not available in your web interface, open the workbook in desktop Excel and change the axis there.

Keep the value axis at the bottom

After you reverse a horizontal bar chart’s categories, Excel may move the horizontal value axis to the top of the chart. That is a consequence of changing the order of the vertical category axis, not a change to the numeric values. The bars can be correctly reversed even if the axis location is not where you expected.

To move the value axis to the bottom, select the vertical category axis again and open Format Axis. In Axis Options, find Horizontal axis crosses and choose At maximum category. This changes where the horizontal value axis crosses the category axis. If your chart has different axis options, confirm that you selected the category axis; the crossing control is associated with that axis.

There is no need to reverse the value axis as well unless you specifically want the numeric scale to run in the opposite direction. Reversing the value axis would change the direction in which bar lengths extend and may make a chart harder to read. For a typical report, reverse categories only, then adjust the crossing location if the value axis appearing at the top is inconvenient.

Reverse the chart or sort the source data?

Changing Categories in reverse order is usually the best choice when you want to alter only how one chart looks. The worksheet remains in its existing order, so tables, formulas, other charts, and downstream uses of the data are not changed. It is also easy to undo: reopen Format Axis and clear the setting.

Sorting the source data is more appropriate when the worksheet itself should be ordered differently, or when several charts and reports should share the new order. For example, you might sort a sales table from highest to lowest before building multiple related charts. But sorting a source range can affect formulas, references, and other charts that use it, so check those dependencies first.

Use axis reversal when the current table order is useful but the chart should display it in the opposite direction.
Sort the data when the worksheet and all its dependent outputs should use a new order.
Use a separate sorted chart range when you need one chart ordered differently without changing the original data. Keep the relationship between the helper range and the source data clear so future updates do not leave the chart out of date.

A common misconception is that reversing the chart rewrites or sorts the rows. It does not. If you inspect the worksheet after changing the axis option, the data stays where it was. Likewise, sorting the source table does not necessarily set the axis-reversal option; the final visual order depends on both the source sequence and the chart’s axis settings.

Category order is different from series order

A chart can show more than one series, such as sales for two years. Categories are the labels along the vertical axis in a bar chart; series are the data groups represented by different colors or patterns. Reversing categories changes the order of the labeled bars or bar groups. It does not change which series is listed first in the legend or the order of colored segments within a stacked bar.

To change series order, right-click the chart and choose Select Data. In the Select Data Source dialog, use the up and down controls under Legend Entries (Series) to change the series sequence. This is the relevant adjustment when the legend order is wrong or when you want one series to appear before another in a stacked chart. The exact visual effect depends on the chart type, but it is separate from reversing categories.

In a stacked bar chart, category reversal moves the whole category group to a different position on the vertical axis. The series order within each stack remains governed by the series arrangement. If the first segment in every bar is the wrong series, change series order rather than repeatedly toggling the category-axis setting.

When the option behaves differently

For a column chart, categories are usually along the horizontal axis rather than the vertical one. Selecting Categories in reverse order therefore reverses their left-to-right display, not a top-to-bottom bar order. If you want horizontal bars, change the chart type to a bar chart; if you only want to reverse a column chart’s labels, select its horizontal category axis and use the same category-order option.

Date-based charts can need extra attention. If the axis is configured as a date axis, Excel may space dates according to time rather than treat every label as an ordinary text category. The reverse-order option can still affect display order, but date-axis settings and the date range determine how labels are spaced. If dates appear in an unexpected sequence, check both the axis type and the underlying date values before assuming the reversal failed.

PivotCharts may also be governed by the associated PivotTable’s fields, filters, and sorting. A chart-axis setting can change display order, but a PivotTable sort or filter may determine which items are included and how they are organized. If the order changes back after refreshing, inspect the PivotTable field’s sort settings as well as the chart axis.

Common problems and practical checks

The bars did not reverse. The selected object may have been the value axis, a bar, or the plot area. Select the category labels on the vertical axis and check the setting again.
The numeric axis moved to the top. This can be normal after reversing categories. Set Horizontal axis crosses to At maximum category if you prefer the value axis at the bottom.
The legend did not change. The legend lists series, not categories. Use Select Data to rearrange series.
The worksheet rows did not move. That is expected. The axis option changes chart display only. Sort the source data if the table itself must be reordered.
The chart order changes after a refresh. For a PivotChart, check PivotTable sorting and filters. For a chart based on a range, check whether the source data or chart range has changed.
The labels appear upside down or on the opposite side. Review the category-axis settings and the Horizontal axis crosses option. Avoid changing the value-axis direction unless that is genuinely what the chart requires.

For a quick check, compare three things: the order of labels on the chart, the order of rows in the worksheet, and the order of series in the legend. They are controlled separately. Identifying which one is wrong makes it much easier to choose the right setting instead of changing the source data unnecessarily.

Choosing the right approach for your chart

Use the chart-axis setting for a simple visual reversal, especially when a chart is meant to follow the order of a table but Excel places the first item at the bottom. For example, a project list that reads from task one to task ten may be easier to scan if task one appears at the top. Reversing categories lets the chart match the list without rearranging the table.

Use source sorting when the order itself has meaning, such as a ranked comparison that should appear from largest to smallest everywhere. Use series reordering when the colored data groups or legend need a different sequence. If you are preparing a chart for others, check the final position of the value axis, category labels, and legend; a reversed chart can be technically correct but confusing if those elements no longer match the reading order of the report.

Frequently Asked Questions

How do I reverse the order of bars in Excel?
Select the chart’s category axis, open Format Axis, and turn on Categories in reverse order under Axis Options. For a horizontal bar chart, the category axis is vertical.

Why did my horizontal axis move to the top?
Reversing the category axis can change where the value axis crosses the chart. In Format Axis, set Horizontal axis crosses to At maximum category to place it at the bottom.

Does reversing a chart sort my Excel data?
No. It changes the chart’s display order only. To reorder worksheet rows, sort the source data separately, taking care not to disrupt other formulas or charts that depend on it.

How do I reverse the legend or stacked-bar segments?
That is a series-order issue, not a category-order issue. Right-click the chart, choose Select Data, and rearrange entries under Legend Entries (Series).

Can I reverse the order in a column chart?
Yes. Select the horizontal category axis and use Categories in reverse order. The categories will display in the opposite left-to-right sequence.

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.