Excel Reverse X-Axis Order: Fix Categories and Dates

Charts & pivot tables · Updated November 19, 2026

To reverse the order of an Excel chart’s horizontal category axis, right-click the axis, choose Format Axis, then under Axis Options select Categories in reverse order. If the horizontal axis is a numeric value axis, such as in an XY scatter chart, select Values in reverse order instead. The right setting depends on what the chart’s axis represents.

First identify what the x-axis represents

In an ordinary column chart, the horizontal axis usually lists categories such as months, product names, or regions. Reversing its categories changes the order in which those labels appear; it does not rearrange the worksheet cells. Excel may also move the vertical axis to the opposite side of the chart as a consequence of reversing the categories.

In a scatter chart, the horizontal axis is a numeric value axis: its positions correspond to numbers rather than a simple list of labels. A chart can also use dates on a category axis, where the date labels are spaced according to categories, or on a value axis, where dates are treated as serial numbers. These differences matter because Excel offers different reversal controls for category and value axes.

  • Category axis: usually labels in a column chart, line chart, or bar chart. Look for Categories in reverse order.
  • Value axis: a numeric scale, often in a scatter chart. Look for Values in reverse order or the minimum and maximum bounds.
  • Date axis: a category axis configured to use dates, or a value axis containing date serial numbers. Use the setting that matches the axis type shown in Format Axis.

One naming wrinkle: in a horizontal bar chart, the category labels appear vertically, while the numeric value axis runs horizontally. People may call the visible horizontal line the x-axis, but the category axis is not horizontal in that chart type. Select the axis whose order you actually want to change.

Reverse categories in a standard chart

For a typical column or line chart in Excel for Microsoft 365 on Windows, reverse a category axis this way:

  1. Click the chart, then click the axis labels whose order you want to change. In a column chart, these are usually along the bottom.
  2. Right-click the selected axis and choose Format Axis. The Format Axis pane opens.
  3. In the pane, select Axis Options and check Categories in reverse order.
  4. Close the pane or click elsewhere in the worksheet to see the result.

The labels should now run in the opposite direction. For example, a chart whose categories run January, February, March, April will show April, March, February, January. The data values remain connected to their original categories; Excel is changing the display order, not assigning March’s value to February.

If it is difficult to select the axis, click the chart and use the Format tab’s Current Selection controls to choose the horizontal or vertical axis, then open Format Selection. The available axis names depend on the chart type. You can also click the axis labels once to select the axis, rather than clicking an individual label twice, which may select only that label.

Reverse a numeric or scatter-chart x-axis

For an XY scatter chart, the horizontal axis is generally a numeric value axis. Select that axis, open Format Axis, and under Axis Options check Values in reverse order. The plotted points keep their x-values, but the scale runs in the opposite direction. A point at x = 2 remains at x = 2 in the data; it appears toward the opposite side of the plot area because the scale has been reversed.

You can also control the visible range using the Bounds fields for minimum and maximum values. For example, a scatter chart with an x range from 0 to 100 can be made to run from 100 on the left to 0 on the right by reversing the value axis. Setting bounds is useful when you need a fixed range, but it is not the same as reversing the axis: bounds crop or expand the displayed scale, while reversal changes its direction.

Be cautious when changing bounds. If the data extend outside the chosen range, some points may no longer be visible. If you want the scale to include all points, use bounds that cover the full data range, or restore the automatic bounds. A reverse axis does not change the underlying x-values or recalculate the chart data.

Reverse dates and understand date-axis behavior

Excel may display dates on a category axis or a value axis. In a line chart, dates are often categories. Select the date axis and use Categories in reverse order to show the latest date first. In an XY scatter chart, dates used as x-values are represented numerically, so the relevant control is usually Values in reverse order.

To check how Excel is treating an axis, open Format Axis and inspect the options available. A category axis may offer Axis Type choices such as Automatically select based on data, Text axis, and Date axis. A value axis instead provides numeric scale options, including bounds. The exact options vary with the chart type and selected axis.

A date axis can space dates according to elapsed time, unlike a text axis, which spaces each listed category evenly. Reversing the order does not turn one axis type into the other. If dates look unevenly spaced and you expected equal spacing, check whether the chart uses a date axis and whether that is appropriate for your purpose. Conversely, if elapsed time matters, evenly spaced text categories may give a misleading impression.

Why the other axis or labels may move

When you reverse a category axis, Excel may reposition the value axis so that the axes still intersect at the appropriate end of the chart. This can make the vertical axis appear on the right instead of the left, or shift the horizontal axis in a bar chart. That movement is usually a chart-layout effect, not a change to the data.

If the crossing position is not what you want, select the other axis and review its crossing options in Format Axis. Depending on the chart and axis type, Excel may offer controls such as crossing at a particular category or at the maximum category. For a value axis, a crossing option may refer to the axis’s maximum value. Choose the option that places the crossing line where it is useful, and check the chart after changing it: the setting can affect which side displays the axis and its labels.

Axis labels can also be moved independently from the axis line. In Format Axis, look for label-position options if the labels overlap the plot area or become awkwardly placed. Reversing the order does not require you to move labels, so adjust that setting only if the new layout is hard to read.

Axis reversal versus rearranging worksheet data

Reversing an axis changes how the chart displays its existing categories or scale. It does not sort the source table, reverse the rows, or change formulas. This is often the safest choice when the chart should show a different reading direction while the worksheet remains in its original order.

Rearranging the source data is a different approach. Sorting the table itself can affect other calculations, filters, or charts that use the same cells. A helper range can be useful when you need a separately ordered chart source, but it creates another range to maintain. For a simple display reversal, use the axis option first. If the intended order is a custom sequence rather than a complete reversal, sort or prepare the chart’s source data in that desired sequence instead.

For example, suppose a monthly report table is stored oldest to newest because that is convenient for data entry, but a particular chart should emphasize the latest month at the left. Reversing the category axis can achieve that chart presentation without moving the records. If the report instead needs months in a business-specific order, such as a fiscal year starting in July, a plain reverse setting will not create that custom sequence; the source categories need to be arranged accordingly.

Common problems and fixes

  • The checkbox is missing: You may have selected a value axis instead of a category axis, or the chart type may use a different axis structure. Select the intended axis and check whether Excel offers category or value options.
  • The labels reverse but the axis line moves: This is often expected. Review the crossing setting on the other axis if its new position is inconvenient.
  • The bars appear in the opposite order from expected: In a bar chart, categories are usually on the vertical axis. Format that category axis, not the horizontal numeric axis.
  • The data seem mismatched: Check the category labels and series values in the source range. Reversing an axis should not detach values from their categories; a mistaken source selection or manual sort may be the real cause.
  • A chart based on a PivotTable does not keep a manual order: PivotCharts follow the arrangement and sorting of their PivotTable fields. Set the field’s order in the PivotTable or use a supported custom sort rather than relying on a one-time chart display change.
  • The result differs in another chart type: A line, bar, column, and scatter chart do not use axes in exactly the same way. Confirm whether the selected axis is categorical or numeric before applying a reversal option.

If you are unsure what changed, select the axis again and inspect its current settings. You can uncheck the reversal option to restore the original direction. Because the source data are not rearranged by this setting, undoing it normally restores the prior chart order without requiring you to repair the worksheet.

Excel for Mac and Excel for the web

In Excel for Mac, the same general method applies: select or Control-click the chart axis, choose Format Axis, and use the relevant reversal option in the formatting pane. The pane layout can differ slightly by release, but the category-versus-value distinction remains important. If a right-click behaves differently on your Mac, Control-click the axis or use the chart-formatting controls to open the axis pane.

Excel for the web also provides chart formatting, but the available controls can vary with the chart and current web version. If you cannot find the reversal option or need a crossing control that is not available in the browser, open the workbook in the desktop Excel app and make the change there. The chart remains part of the workbook when saved.

Frequently Asked Questions

How do I make the x-axis go from right to left in Excel?
For a category axis, select it, choose Format Axis, and check Categories in reverse order. For a numeric x-axis, such as in a scatter chart, use Values in reverse order.

How do I reverse the x-axis without changing my data?
Use the reversal setting in the Format Axis pane. It changes the chart’s display direction, not the order of the worksheet rows or the values assigned to categories.

Why did my y-axis move to the right?
Excel may move the value axis when categories are reversed so that the axes cross at the corresponding end of the chart. Select the other axis and adjust its crossing option if you want a different placement.

Can I reverse dates on an Excel chart?
Yes. If the dates are categories, select Categories in reverse order. If they are numeric x-values in a scatter chart, reverse the value axis instead. Check Format Axis to see which kind of axis the chart uses.

Does reversing the axis sort the chart data?
No. It changes the display order on that axis. To sort the worksheet or create a custom category sequence, change the source-data order or the relevant PivotTable sorting instead.

How do I put the oldest date back on the left?
Open Format Axis for the date axis and clear Categories in reverse order, or reverse the value axis if the dates are plotted as numeric values. Excel returns to the normal direction for that axis.

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.