How to Flip Bar Order in Excel

How-to basics · Updated November 20, 2026

To flip the order of bars in an Excel chart, right-click the category axis, choose Format Axis, then select Categories in reverse order under Axis Options. This changes how categories appear in the chart without rearranging the source data. The steps below are for Excel for Microsoft 365 on Windows; the same setting is available in many recent desktop versions.

What You’ll Need

  • An Excel workbook containing data arranged in categories and values, such as product names in one column and sales in another.
  • A bar chart, or data from which you can create one. A bar chart displays horizontal bars; a column chart displays vertical columns.
  • Access to Excel’s chart-formatting options. If you are using Excel for the web and cannot find the axis setting, open the workbook in the desktop app.

You do not need to change the order of the rows in your worksheet just to reverse their appearance in the chart. Keeping the data as it is can be useful when other formulas, tables, or charts depend on its current layout.

Step-by-Step

  1. Select the chart. Click once inside the bar chart so the chart tools become available. If you do not have a chart yet, select the category and value cells, then choose Insert > Insert Column or Bar Chart and select a 2-D Bar option, such as Clustered Bar. Make sure you have created a bar chart rather than a column chart if you want horizontal bars.
  2. Select the category axis. Click the labels running beside the bars, such as product names, months, or department names. These labels form the category axis. Take care not to select the bars themselves or the horizontal value axis, which usually shows numbers. If the labels are hard to select, click the chart, open Format on the ribbon, and use the Current Selection list to choose the category axis.
  3. Open the axis settings. Right-click the category-axis labels and choose Format Axis. The Format Axis pane opens at the side of the Excel window. On a touchpad, use the equivalent secondary click. You can also select the axis and use the formatting controls on the ribbon if right-clicking is inconvenient.
  4. Find the category-order setting. In the Format Axis pane, select Axis Options if it is not already open. Look for the checkbox named Categories in reverse order. The exact position of options can vary slightly with window size, but the setting is in the category axis options, not in the chart’s data table.
  5. Turn on reverse order. Select Categories in reverse order. Excel immediately reverses the displayed order of the categories. For a typical horizontal bar chart, the first category in the worksheet will now appear at the top instead of the bottom, and the last category will appear at the bottom.
  6. Check the value-axis position. Reversing categories can also move the horizontal value axis to the top of the chart. If you prefer it at the bottom, keep the category axis selected and look in Axis Options for Horizontal axis crosses. Choose At maximum category if that option is available. This changes where the value axis crosses the category axis; it does not undo the reversed bar order.
  7. Review labels and chart readability. Check that category names are still readable and that the bars still correspond to the right values. If axis labels or the legend overlap, widen the chart or adjust its plot area. Click outside the chart when finished; the source data should remain in its original row order.

To reverse the change, select the category axis again and clear Categories in reverse order. You can switch the setting on and off without rebuilding the chart.

Common Mistakes

  • Selecting the value axis instead of the category axis. The value axis is the numbered scale, while the category axis contains the labels beside the bars. The reverse-category option is on the category axis. If you do not see the checkbox, close the pane, click the category labels, and open Format Axis again.
  • Confusing a bar chart with a column chart. In a horizontal bar chart, categories are usually listed vertically beside the bars. In a column chart, categories run along the bottom and the columns rise vertically. The same reverse-order setting applies to the category axis, but the visual result is left-to-right for a column chart rather than top-to-bottom.
  • Reversing the worksheet rows instead. Sorting or manually moving source rows changes the data itself and may affect other calculations or charts. Use the axis setting when the goal is only to change the chart’s display order.
  • Expecting reverse order to sort by value. Reversing categories simply turns the existing sequence around. It does not arrange bars from largest to smallest. To rank bars, sort the source categories and values together by the value column, or use the chart’s underlying table or PivotTable sorting controls.
  • Changing series order by mistake. In a chart with multiple data series, the Select Data window has controls for changing series order. Series are the separate sets of bars, often identified by legend entries. Those controls are different from reversing the category labels on the axis.
  • Assuming the bars themselves were reversed individually. The axis option changes the order in which categories are displayed. It does not change values, swap a category’s label with another category, or alter the worksheet data.

Tips

  • Use a small test chart if the result is unclear. A chart with three categories in a known order makes it easy to see which axis you selected and what the reversal does. Once the setting is clear, apply it to the full chart.
  • Keep category names and values together when sorting. If you want the largest bar first, sort the entire source range by its values, not the value column alone. Sorting only one column can pair the wrong name with each number.
  • Consider labels for ranked charts. If you sort values from largest to smallest and want the largest bar at the top, you may also need to reverse the category axis. The data sort sets the ranking; the axis option controls which end of that sequence appears at the top.
  • Use the chart type that matches the comparison. Horizontal bars are often easier to read when category names are long. A column chart may suit short labels or a sequence where the horizontal direction is meaningful, such as dates.
  • Remember that the setting is stored with the chart. Saving the workbook preserves the chart’s axis order. If you copy the chart to another workbook, check the setting there as well, particularly if the chart’s source range or type changes.
  • On Mac, use the same axis option. In Excel for Mac, select or Control-click the category axis and choose Format Axis, then look for Categories in reverse order in the axis options. Ribbon layout and pane placement differ from Windows, but the chart setting is substantially the same.

Troubleshooting

I cannot see “Categories in reverse order.” Confirm that the selected object is the category axis, not the chart area, a data series, or the value axis. In the Format Axis pane, select Axis Options. If the chart type does not use a category axis in the way you expect, try selecting the labels directly. In Excel for the web, chart-formatting controls can be more limited or arranged differently; use Open in Desktop App if the option is not available.

The bars changed order, but the horizontal number axis moved to the top. This can happen when Excel reverses categories. Select the category axis and check its Horizontal axis crosses setting. Choose At maximum category to place the value axis at the other end of the category axis when that choice is offered. The wording or available options can depend on the chart type and version.

The chart still looks unchanged. Check that the chart has more than one category and that you changed the axis used for those categories. A chart with one category has no visible order to reverse. Also check whether the chart is a PivotChart: its category order may be controlled by the associated PivotTable or field sorting, so change the field order there if the chart setting does not give the intended result.

The order is reversed, but it is not largest-to-smallest. That is expected if the source data was not sorted by value. Reverse order flips the existing category sequence; it does not calculate a ranking. Sort the source table or PivotTable by the value field, then decide whether the first or last category should appear at the top.

Only the legend or colored series changed. You likely selected a series or altered series order rather than the category axis. Reopen the Format Axis pane after clicking the category labels. For a multi-series chart, use the legend to identify series and the axis labels to identify categories.

The first worksheet row appears at the bottom, even after I reversed order. That is the usual default appearance for many horizontal bar charts, not evidence that your data was changed. Selecting Categories in reverse order should move that first category to the top. If you wanted the last source row at the top instead, leave the option unchecked.

Frequently Asked Questions

Does reversing the bar order change my worksheet data?

No. The option changes the chart’s category-axis display. The source cells stay in their existing order, and formulas that use those cells are not rearranged.

How do I put the first category at the top of a horizontal bar chart?

Select the category labels, open Format Axis > Axis Options, and select Categories in reverse order. In the usual default layout, this moves the first category from the bottom to the top.

How do I make the longest bar appear at the top?

Sort the source categories and values together from largest to smallest, then reverse the category axis if needed to put the first sorted category at the top. The axis option alone does not sort by bar length.

Can I reverse the order in a column chart?

Yes. Select the category axis along the bottom and use Format Axis > Axis Options > Categories in reverse order. The categories then run in the opposite left-to-right direction.

Will this work for a stacked bar chart?

Yes, the setting can reverse the category order in a stacked bar chart as well. It changes the order of the category rows, not the order of the colored series within each bar.

Can I reverse the bars without moving the value axis?

You can reverse the categories and then adjust where the axes cross. For a horizontal bar chart, check the category axis’s Horizontal axis crosses option and select At maximum category if available. The axis placement controls can vary by chart type and Excel version.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.