To reverse the order of categories in an Excel graph, select the chart axis, open Format Axis, and turn on Categories in reverse order under Axis Options. For a numeric axis, choose Values in reverse order instead. These settings change how the chart displays its data without rearranging the source cells.
The exact option depends on which axis or chart element you want to reverse. The steps below are for Excel for Microsoft 365 on Windows, with notes for other versions. Before changing anything, identify whether you mean the category labels, numeric scale, or order in which data series are drawn.
What You’ll Need
- An Excel workbook containing a chart and its source data.
- Permission to edit the chart. If the sheet is protected, you may need the password or permission to unprotect it.
- A clear idea of what should appear first or last: categories, values on an axis, or plotted series.
Step-by-Step
- Select the chart. Click once inside the chart area so Excel displays the chart tabs on the ribbon. If the chart is an embedded object, make sure you select the chart rather than a cell behind it.
- Choose the axis whose order you want to change. Click one of its labels. For a column chart, the category axis is usually along the bottom and the value axis is usually on the left. For a horizontal bar chart, categories are usually listed vertically on the left and values run horizontally. If labels are crowded, click an axis label once to select the whole axis, rather than clicking only a single label.
- Open the axis settings. Right-click the selected axis and choose Format Axis. Alternatively, with the axis selected, go to Chart Format > Format Selection. Excel opens the Format Axis pane, usually at the right of the window. Check its heading to confirm that you are formatting the intended axis.
- Expand Axis Options. In the Format Axis pane, select Axis Options (the icon that looks like a small column chart). Look for the checkbox or setting named Categories in reverse order when you selected a category axis. Turn it on to display the categories in the opposite order. Excel updates the graph immediately.
- Check the result and the axis position. Compare the first and last category labels with the order you want. Reversing a category axis can also move the value axis to the opposite edge of the chart. If that happens in a bar chart, keep the category axis selected and find Horizontal axis crosses in Axis Options. Choose At maximum category if you want the horizontal value axis at the bottom of the plot area. The wording and available controls can differ slightly with chart type.
- Reverse a numeric scale when that is what you mean. If you want values such as 0, 10, 20, 30 to run in the opposite direction, select the numeric axis instead. In Format Axis > Axis Options, turn on Values in reverse order. This reverses the scale; it does not reorder category names or the source rows. Check the minimum, maximum, and where the other axis crosses, because those placements may change too.
- Change the drawing order of chart series separately. If you mean that one plotted series should appear in front of another, click the chart and choose Chart Design > Select Data. In Legend Entries (Series), select a series and use the up or down arrow to change its position, then click OK. This changes series order, not the order of category labels. In some chart types, the series listed later may be drawn over earlier series, so inspect the chart after moving them.
- Review the legend and labels. Confirm that the labels, legend, and any data labels still make sense. Save the workbook when the chart looks right. If you want to preserve the original appearance as a fallback, duplicate the chart before making changes by copying and pasting it.
For example, suppose a horizontal bar chart lists January at the top and December at the bottom, but you want December first. Select the vertical category axis and turn on Categories in reverse order. If the horizontal value axis then appears at the top and you prefer it at the bottom, set Horizontal axis crosses to At maximum category. This changes the chart display; the January-to-December rows in the worksheet stay as they were.
On Mac, select the chart axis, Control-click or right-click it, and choose Format Axis. Use the Axis Options in the formatting pane to find the reverse-order setting. Ribbon labels or pane layout may vary slightly by Excel release. In Excel for the web, select the axis and open its formatting options; if the needed axis control is unavailable in your browser version, choose Open in Desktop App and make the change in Excel for Windows or Mac.
Common Mistakes
- Reversing the wrong axis. Category order and numeric scale are controlled independently. If months or product names are in the wrong sequence, select the category axis. If the number scale runs from high to low, select the value axis. The pane heading helps confirm which one you chose.
- Assuming the worksheet rows will move. Axis reversal is a chart-display setting. It does not sort the source table, change formulas, or reorder the underlying data. If you need the worksheet itself in a different order, sort the data separately and consider how that will affect other charts and formulas.
- Confusing axis order with series order. A chart can contain multiple series, such as actual and forecast values. Moving a series up or down in Select Data affects its plotting or legend order; it does not reverse the categories on the axis.
- Ignoring the axis crossing position. A reversed category axis can move the value axis to the other side. This is a layout change, not a sign that the data has been reversed incorrectly. Adjust the axis-crossing option if the new position is inconvenient.
- Expecting alphabetical or chronological sorting. The reverse-order option flips the current plotted sequence; it does not sort labels alphabetically or arrange dates by calendar logic. If the source sequence is irregular, reversing it will leave that irregular pattern in reverse.
- Changing a chart that is based on a PivotTable without checking its source. PivotCharts can follow PivotTable field sorting and filtering. If the displayed order is being controlled by the PivotTable, changing the field’s sort order there may be more reliable than trying to treat the chart like a standard chart.
Tips
- Use the chart type to identify the category axis. In a column chart, categories commonly run left to right. In a bar chart, they commonly run top to bottom. Line charts usually show categories or dates along the horizontal axis. A scatter chart uses numeric axes, so its horizontal and vertical axes are value axes rather than category axes.
- For a scatter chart, reverse the relevant numeric axis. Select the horizontal or vertical axis and use Values in reverse order. This can be useful for a scale that should decrease from left to right, but it can make familiar coordinate positions look unusual. Verify that the direction supports the intended reading of the chart.
- Check date axes and gaps. A date axis may space dates according to elapsed time, while a text category axis treats each label as a separate entry. Reversing the display direction does not fix missing dates or uneven source data. Confirm that the chart uses the axis type and source range you intended.
- Keep the source sequence understandable. If other people will edit the workbook, add a short note near the chart or use a clear chart title so they know the displayed order is intentionally reversed. This is especially helpful when the worksheet rows still run in the opposite direction.
- Use Undo for a quick correction. Immediately after an unwanted change, press Ctrl+Z on Windows or Command+Z on Mac. If you have made several other edits since then, reopen Format Axis and switch the setting back instead of undoing unrelated work.
Troubleshooting
- The reverse-order option is missing. Make sure the axis itself is selected, not the chart area, a data series, or a single data label. Reopen Format Axis and check the pane heading. A category axis offers category-order controls; a numeric axis offers value-scale controls. If the chart is a PivotChart or an unusual chart type, check whether its source or chart type limits the available options.
- The chart reverses but the axis moves to the top or right. This can be expected. Select the category axis again and look for the axis-crossing setting. For a bar chart, choose At maximum category under Horizontal axis crosses when you want the value axis along the bottom. For other chart types, the crossing control may be presented differently, so inspect the axis labels after changing it.
- The labels still appear in an unexpected order. Check the series of source rows or columns and any filters, sorts, or PivotTable field settings. The reverse option flips the sequence currently supplied to the chart; it cannot turn a custom order into a chronological or alphabetical one automatically. Correct the source or PivotTable order first if needed.
- Only one series seems to change. You may have selected a series rather than an axis, or the chart may use a secondary axis. Click the axis labels themselves and verify the Format Axis pane heading. If different series use primary and secondary axes, inspect both axes and make the intended setting on the correct one.
- The option does not stay changed. A PivotChart may refresh from its PivotTable and restore the field’s sort or filter order. Set the desired order in the PivotTable, then refresh and inspect the chart. Also check whether another user, macro, or workbook refresh process is rebuilding the chart.
- You are using Excel for the web and cannot find the control. Try selecting the axis and opening its format pane. If your current browser build does not expose the reversal option, open the workbook in the desktop app. The exact web controls can change over time, while the desktop Format Axis pane provides the full set of standard axis options.
Frequently Asked Questions
Does reversing an Excel graph change my source data?
No. The axis setting changes the order in which the chart displays the existing categories or values. It does not move worksheet rows, edit cells, or change formulas.
How do I put the first category at the bottom of a bar chart?
Select the vertical category axis, open Format Axis, and turn on Categories in reverse order. If the value axis moves to the top, set Horizontal axis crosses to At maximum category to place it at the bottom.
Can I reverse only the legend order?
Use Chart Design > Select Data, select a series under Legend Entries (Series), and move it with the up or down arrow. If you also want to change the plotted series order, this is generally the relevant control; category-axis reversal is a different setting.
Can I reverse a chart without reversing the axis labels?
It depends on what you mean by reverse. Reversing a category axis necessarily changes the displayed category sequence. If you want to change which series is drawn in front while keeping category labels in place, reorder the series in Select Data instead.
Why does my scatter chart show no “Categories in reverse order” option?
A scatter chart uses numeric value axes rather than a text category axis. Select the horizontal or vertical value axis and choose Values in reverse order to change that scale’s direction.
Will reversing a date axis change the date values?
No. It changes only the display direction. The chart still uses the same dates from the source. If the dates are not in the order you expect, check the source data, filters, and whether the chart is using a date axis or treating dates as text categories.
Related
- Password Protect an Excel File to Open on Windows PC
- Open Excel for the Web in the Desktop App
- Open Power Query in Excel for the Web: Step-by-Step
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Can You Cluster a Stacked Bar Chart in Excel?Yes, but Excel does not offer a built-in chart type that both clusters and stacks bars. In Microsoft…
- Basic Pivot Table: Create and Use One in ExcelA basic pivot table is an interactive summary of source data: in Excel for Microsoft 365 on Windows,…
- Excel Pivot Var: What It Means and How to Read ResultsIn an Excel PivotTable, Var means sample variance: it measures how spread out the numeric values are around…
- Chart Labels in Google Sheets: Add, Edit, and FormatTo add chart labels in Google Sheets, open the chart, choose Customize in the Chart editor, then use…
- 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 Chart Error Bars: How to Add and Format ThemTo add error bars in Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.