To reverse a chart’s horizontal axis in Excel for Microsoft 365 on Windows, right-click the axis, choose Format Axis, open Axis Options, and select Values in reverse order or Categories in reverse order, depending on the type of axis. This changes the order shown in the chart, not the order of the data in your worksheet. Before you start, select the chart and identify whether its horizontal axis shows categories, such as months, or a numeric scale, such as values from 0 to 100.
What You’ll Need
- An Excel workbook containing a chart you can edit. The steps apply to charts such as column, line, and scatter charts.
- Permission to edit the chart, and a way to select the axis itself. If you cannot select it directly, use the chart formatting controls.
- A little patience with bar charts: their categories are usually shown on the vertical axis, so reversing the horizontal numeric scale is not the same as reversing the category order.
Step-by-Step
- Select the chart. Click once inside the chart area. Excel should display its chart border and, in the ribbon, contextual chart tabs such as Chart Design and Format. If you are only selecting a cell, click the chart again or click a blank area inside its boundary.
- Identify the horizontal axis you want to change. Look at the labels along the bottom of a typical column or line chart. If they are names, dates, or other groups, you are looking at a category axis. If they are numbers on a continuous scale, you are looking at a value axis. In a scatter chart, both axes are numeric value axes. This distinction determines which reverse-order setting to use.
- Select the axis and open its formatting pane. Click the axis line or one of its labels. Right-click the selected axis and choose Format Axis. If Excel selects the plot area or a data series instead, click directly on an axis label and try again. The Format Axis pane opens on the right. You can also select the chart, go to Format > Current Selection, choose the appropriate axis from the list, and click Format Selection.
- Open Axis Options. In the Format Axis pane, select Axis Options, usually represented by a small column-chart icon. Expand the section if necessary. The available options depend on the chart type and which axis is selected, so make sure the pane is formatting the intended horizontal axis rather than the vertical axis.
- Reverse a category axis. For a horizontal category axis, such as the month labels beneath a column chart, select Categories in reverse order. Excel flips the displayed category sequence. For example, a chart whose categories run January, February, March from left to right will show March, February, January instead. Your worksheet cells and the underlying series values are not rearranged.
- Reverse a numeric value axis. For a horizontal value axis, select Values in reverse order. This reverses the scale direction. A scale that previously increased from 0 on the left to 100 on the right will run from 100 on the left to 0 on the right. This is commonly the setting needed for the horizontal axis in a scatter chart or a bar chart.
- Check where the other axis crosses. Reversing an axis can change where Excel places the perpendicular axis or its labels. If the vertical axis moves to the opposite side, look in Axis Options for the relevant crossing control, such as Vertical axis crosses or Horizontal axis crosses, and choose an appropriate position. The exact wording and available choices vary by chart and axis. Do not change the crossing setting unless the new position is actually a problem.
- Review the result and keep the chart readable. Check that the order now communicates what you intend, that the axis labels are legible, and that the data series still make sense. If you need to retain the original view, press Ctrl+Z immediately to undo the change, or save a copy before making several formatting adjustments.
For a bar chart: Excel displays the categories down the vertical axis and the numerical values along the horizontal axis. To reverse which direction the bars’ value scale runs, select the horizontal value axis and use Values in reverse order. To reverse the top-to-bottom order of the category names, select the vertical category axis and use Categories in reverse order. If you searched for a horizontal-axis setting because you want the bars or categories to appear in a different order, check which of these two effects you mean.
For Excel for Mac: The names of the controls are generally the same. Select the chart axis, Control-click it (or right-click if your mouse is configured for secondary clicks), choose Format Axis, and use the Axis Options pane. For Excel for the web, axis formatting options can depend on the chart and the version available in your browser. If the reverse-order option is missing, open the workbook in the desktop Excel app and change the setting there.
Common Mistakes
Changing the wrong axis. A chart has a horizontal and a vertical axis, and the labels can make it easy to select the wrong one. In a bar chart, in particular, the categories are vertical even though the bars extend horizontally. Confirm that the pane title or selected-axis highlight corresponds to the axis you mean to edit before changing a setting.
Using the category setting on a numeric scale, or vice versa. Categories in reverse order applies to a list of groups or labels. Values in reverse order applies to a numeric scale. If the checkbox you expect is not visible, you may have selected a different axis, or your chart type may use a different kind of axis. Check the chart type and the labels before assuming Excel has removed the option.
Sorting the source data instead. Sorting a worksheet range changes the data arrangement and may affect other tables, formulas, or charts using that range. Use the axis reversal setting when you only want to change the chart’s display order. Conversely, if you want the data itself sorted for other uses too, change the source data deliberately rather than treating axis formatting as a data sort.
Thinking the axis setting changed the underlying values. Reversing the display does not rewrite the cells or recalculate the underlying measurements. It changes how Excel lays out the axis. This matters when someone reads the chart alongside the worksheet: confirm that the visual order is intentional and, if needed, add a clear title or note to explain it.
Tips
Decide whether you want to reverse the categories, reverse the direction of the scale, or both. These are different actions. For a column chart, reversing categories changes which group is at the left and which is at the right. Reversing a numeric horizontal scale changes which end represents the larger value. For a bar chart, the category order is usually top-to-bottom, while the numeric scale is left-to-right.
Use a small test chart if the effect is hard to predict. A simple chart with three categories and easy-to-recognize values makes it clear whether Excel flipped the labels, the scale, or both. You can undo the test or close it without saving, then apply the intended setting to your main chart.
After changing the order, review axis labels and gridlines as well as the bars, columns, or points. When a numeric axis is reversed, the larger values may appear on the left, which can surprise readers accustomed to scales that increase from left to right. A descriptive axis title and an informative chart title can make that direction clear.
If your goal is only to put the earliest date on the left or the latest date on the left, the category reversal setting is usually the direct display control for a category-based chart. Date axes and text category axes can behave differently depending on chart type and axis settings, so inspect the result rather than assuming every date chart uses the same layout.
Troubleshooting
I cannot find Format Axis. Make sure the chart itself is selected, then click an axis label or line before right-clicking. If the menu offers Format Chart Area or Format Data Series, Excel has selected another chart element. Alternatively, select the axis through Format > Current Selection, then choose Format Selection. If the chart is a picture rather than an editable Excel chart, its axes cannot be formatted this way.
The reverse-order option is missing. Check that you have opened Axis Options for the correct axis. A category axis offers category-order controls, while a numeric value axis offers value-order controls. Some chart types, including charts with specialized axis behavior, may not expose the same options. Try selecting the other axis to confirm what type of axis you are working with, or open the workbook in desktop Excel if you are using the web app.
The axis reversed, but the vertical axis or labels moved. This can be a normal side effect of reversing the scale or category order. Reopen Format Axis and review the crossing and label-position settings for the affected axes. Set the crossing position to suit the chart, then check that the axis labels do not overlap the plotted data. If you are unsure which option caused the change, use Ctrl+Z and repeat the reversal first, then adjust one additional setting at a time.
The chart looks unchanged. Verify that you selected the axis that controls the feature you want to reverse. A line chart’s horizontal category labels and a scatter chart’s horizontal numeric values require different settings. Also check for another chart element or a secondary axis: a series plotted on a secondary axis may not respond to formatting the primary axis. Select the relevant axis directly and confirm its scale or labels change after you apply the option.
I changed the worksheet order by mistake. If the sort was your most recent action, press Ctrl+Z on Windows to undo it; on Mac, use Command+Z. If other edits have happened since, use the workbook’s saved version or undo history carefully. Then reverse the axis in the chart’s Format Axis pane instead of sorting the source range.
Frequently Asked Questions
Does reversing an axis change my worksheet data?
No. The reverse-order control changes the chart’s display. It does not move the source cells or change the values stored in them.
Which option reverses the horizontal axis in a column chart?
If the horizontal axis contains category labels, select Categories in reverse order. If it is a numeric value axis, select Values in reverse order. Most column charts have categories along the bottom and values on the vertical axis.
How do I reverse the order of categories in a bar chart?
Select the vertical axis containing the category names, open Format Axis, and choose Categories in reverse order. The bars will appear in the opposite top-to-bottom category sequence. To reverse the horizontal numeric scale instead, select that horizontal axis and choose Values in reverse order.
Can I reverse a scatter chart’s horizontal axis?
Yes. A scatter chart uses a numeric value axis horizontally, so select that axis and choose Values in reverse order. The numerical positions will display in descending rather than ascending direction, while the plotted data values remain unchanged.
Can I reverse the axis in Excel for the web?
Some axis-formatting options are available in Excel for the web, but availability can vary by chart and browser version. If you cannot see the required reverse-order option, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac and use Format Axis.
Why did the vertical axis move after I reversed the horizontal one?
Excel may change where the two axes cross when an axis is reversed. Review the crossing control in Axis Options and set the crossing position that best fits the chart. The axis movement affects the chart layout, not the underlying data.
Related
- How to Paste in Excel Without Changing Cell Format
- Paste in Excel With Filtered Rows: Safe Methods
- How to Paste in Excel While Skipping Rows
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Scatter Chart: Fix Common ProblemsTo fix a Google Sheets scatter chart, put numeric X values in one column and numeric Y values…
- Excel Pivot Table Totals at Top? Show SubtotalsYes. To put category subtotals above their detail rows in Excel for Microsoft 365 on Windows, click inside…
- Excel Trendline Equation: Show More Decimal PlacesTo show more decimal places in an Excel trendline equation, select the equation label, open Format Trendline Label,…
- Excel Chart Data Labels in Millions: Number FormatTo show Excel chart data labels in millions, select the labels, open Format Data Labels, then under Number…
- Resource Histogram Template Excel: Build and Use OneA resource histogram template in Excel is a time-based grid that shows how much work each person or…
- X Line on a Graph: Meaning and How to Read ItThe “X line” on a graph usually means the x-axis: the horizontal reference line that runs from left…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.