To flip an axis in an Excel chart, select the axis, right-click it, choose Format Axis, and turn on Categories in reverse order or Values in reverse order under Axis Options. Which setting you need depends on the chart: category axes contain labels such as months or names, while value axes contain numbers. If you mean swapping what is plotted on the X and Y axes, the steps are different and depend on the chart type.
These instructions are for Excel for Microsoft 365 on Windows. A flipped axis can put the most recent date first, move the largest value to the bottom, or make a chart easier to read alongside other material. Before changing anything, decide whether you want to reverse the order along an existing axis or change which data is assigned to each axis; those are separate operations.
What You’ll Need
- An Excel workbook with data and a chart. If you do not have a chart yet, select the data, then use Insert and choose an appropriate chart type.
- A clear idea of what you want to change: the order of categories, the direction of a numerical scale, or the X and Y data assignments.
- Access to the chart’s formatting options. The desktop app has the fullest set of controls; some chart options may be limited in Excel for the web.
Step-by-Step
- Select the chart and identify the axis. Click the chart once, then click the axis whose direction you want to change. Click the labels or tick marks, not the chart title or a data series. The selected axis should show handles. If it is difficult to select, click the chart and use the Format tab’s Current Selection list to choose the horizontal or vertical axis.
- Open the axis settings. Right-click the selected axis and choose Format Axis. Excel opens the Format Axis pane, usually on the right. Select Axis Options in the pane if it is not already active. The available controls depend on whether the selected axis is a category axis or a value axis.
- Reverse a category axis when you want labels in the opposite order. For a chart with categories such as weekdays, product names, or dates displayed as labels, select the category axis and check Categories in reverse order. The first category will move to the opposite end of the chart. This is often the setting people need for a horizontal bar chart, where category labels appear vertically along the left or right side.
- Check where the crossing axis appears. Reversing category order can move the other axis to the opposite side of the chart. If that makes the chart awkward, select the category axis again and look in Axis Options for Vertical axis crosses. Choose At maximum category if that option is available and puts the value axis where you want it. The exact wording and choices can vary by chart type. Check the result rather than assuming the axis will stay in its original position.
- Reverse a value axis when you want the scale to run backward. Select the numerical axis, such as one labeled 0, 20, 40, and 60. In Format Axis, check Values in reverse order. A scale that previously increased from bottom to top or left to right will now run in the opposite direction. This changes the display order, not the underlying values in your worksheet.
- Move the crossing axis if it jumps to an unexpected edge. When a value axis is reversed, the category axis may appear at the top or right instead of its previous location. In the value-axis settings, find the option for where the horizontal axis crosses and select At maximum value or the equivalent choice offered for that chart. For a chart with a horizontal value axis, the corresponding crossing control may be worded differently. Use the preview and chart labels to confirm the position.
- For a scatter chart, reverse the horizontal or vertical scale separately. A scatter chart has numerical values on both axes. Click the horizontal axis and check Values in reverse order to reverse X; select the vertical axis and use the same setting to reverse Y. If an axis moves to the other side, adjust its crossing setting in the Format Axis pane. Do not use Categories in reverse order for a numerical scatter axis.
- If you mean swap X and Y, edit the series instead of reversing an axis. This is most direct in an XY (Scatter) chart. Right-click the chart, choose Select Data, select a series, and choose Edit. In the Edit Series dialog, exchange the ranges in Series X values and Series Y values, then choose OK. Repeat for each series as needed. For a line or column chart, the horizontal axis is generally a category axis, not a numerical X scale; change to a scatter chart if you need numerical X and Y coordinates.
- Review the chart and keep the change only if it improves readability. Confirm that the labels, data points, and axis titles still make sense, and that the scale has not become misleading. Close the Format Axis pane when finished. If you want to compare versions, duplicate the chart first or use Ctrl+Z on Windows immediately after a change to undo it.
Common Mistakes
Reversing the wrong axis. In a column chart, the categories are often along the bottom and values on the left. In a horizontal bar chart, categories are typically on the vertical axis and values on the horizontal axis. Select the axis by its labels and tick marks, rather than relying on the words horizontal and vertical alone.
Confusing reversal with swapping X and Y. Reversing an axis changes which end of that same scale comes first. It does not move a series’ X values into the Y field or change the chart’s data structure. For scatter charts, use Select Data and edit the series ranges to exchange X and Y assignments.
Changing the worksheet data to compensate. Sorting the source table may also change chart order, but it affects the data itself and can change other calculations or charts. Use Format Axis when you only need a different display order. If the chart must follow a specific custom order, deliberately arrange the source categories or use a helper range rather than repeatedly sorting unrelated data.
Assuming reverse order changes the values. The option changes how the scale or labels are drawn; it does not rewrite cells or reverse the data series. Read the axis labels after the change, especially when the chart is used to compare magnitudes or show a trend over time.
Ignoring axis crossing and labels. Excel may move the crossing axis when you reverse a scale. This can put labels at the top, right, or a less convenient edge. Adjust the crossing option if available, then check that the axis title and tick labels remain visible and do not overlap the plotted data.
Tips
- Use Categories in reverse order for a label sequence you want read from the opposite end; use Values in reverse order for a numeric scale you want to run backward.
- For a horizontal bar chart, reversing the vertical category axis is a common way to put the first listed item at the top. If the result is upside down relative to your goal, turn the option off and check the other axis instead.
- Keep axis titles explicit when a reversed scale might surprise readers. A clear title and visible endpoint values help explain the direction at a glance.
- When comparing two charts, use the same axis direction and scale where possible. A reversed scale on only one chart can make similar patterns look different or make comparisons confusing.
- Excel for Mac has a similar Format Axis pane: Control-click or right-click the axis and choose Format Axis. Names and pane placement can differ slightly. On Mac, Command+Z undoes a recent change; on Windows, use Ctrl+Z.
- In Excel for the web, select the chart and look for chart formatting options for the axis. If you cannot find the reverse-order or crossing controls, choose Open in Desktop App and make the adjustment there.
Troubleshooting
The axis setting is missing or disabled. Make sure you selected an axis, not the chart area, a gridline, or a data series. Click directly on axis labels or numbers and reopen Format Axis. Some chart types do not provide the same controls, and a chart with no visible axis may require turning that axis on before you can format it. If the chart is a picture rather than an editable Excel chart, its axes cannot be changed.
The wrong labels are reversed. Close the pane, select the other axis, and check its settings. A bar chart and a column chart orient categories and values differently, so use the contents of the axis to identify it: labels such as names indicate categories, while a graduated numeric scale indicates values.
The axis moved to the top or right. This is a side effect of changing the order, not necessarily a failed setting. Return to Format Axis and adjust the crossing option for the selected axis. If the control is unclear, toggle the reverse option off and on while watching the chart, then choose the crossing position that leaves the axis and labels easy to read.
The chart still looks unchanged. Check that the axis actually selected has a visible reversal option enabled. A category sequence may appear unchanged if it has only one category, while a value axis may be hard to judge if its endpoints are similar or labels are hidden. Temporarily turn on axis labels or inspect the two endpoint values, then restore the desired display.
The X and Y values will not swap as expected. Confirm that the chart is an XY (Scatter) chart and that you edited the intended series. Select Data, choose the series, and inspect the X and Y ranges in Edit Series. A line chart may treat its horizontal entries as categories, so changing chart type to Scatter may be necessary for numerical X coordinates.
The chart looks misleading after reversal. Verify the minimum and maximum values, units, and any axis title. Reversing a scale can be appropriate, for example to show a ranked list from top to bottom, but make the direction apparent to readers. If the chart is for reporting, explain an unusual axis direction in a note or subtitle.
Frequently Asked Questions
How do I reverse the order of categories in an Excel chart?
Select the category axis, right-click and choose Format Axis, then check Categories in reverse order under Axis Options. Check the crossing axis afterward because its position may change.
How do I make the numbers on an Excel chart axis go from high to low?
Select the numeric value axis, open Format Axis, and check Values in reverse order. The chart’s display changes, but the cell values and source data stay the same.
Can I flip just the horizontal axis?
Yes. Select the horizontal axis and use its reverse-order setting. On a scatter chart this reverses the numerical X scale; on many other chart types the horizontal axis is a category axis, so the category labels reverse instead.
Can I swap the X and Y axes in a line chart?
Not as a simple axis-reversal setting. Line charts commonly use category labels horizontally. If both dimensions should be numerical, change the chart to XY (Scatter), then edit the series’ X and Y value ranges in Select Data.
Will flipping an axis change my data?
No. Reversing an axis changes the chart’s visual order or direction, not the worksheet values. Editing the series ranges to swap X and Y changes which data is plotted on each scatter-chart axis, but still does not rewrite the source cells.
Why did my axis labels move after I reversed the scale?
Excel may reposition the crossing axis when the order changes. Use the crossing controls in Format Axis to place it at the preferred edge, then confirm that the labels remain readable.
Related
- How to Enable Freeze Panes in Excel
- Forecast Sheet in Excel 2007: What You Can Do Instead
- How to Enable Merge and Center in Excel: Quick Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Histogram in Excel: How to Create One From Your DataTo make a histogram in Excel, put your raw numeric observations in one column, select the values, then…
- Excel Chart Title From Cell: Link, Format, and FixesTo link an Excel chart title to a cell, select the chart title, click the formula bar, type…
- Stacked Waterfall Chart in Excel: How It WorksExcel does not offer a built-in stacked waterfall chart: its native Waterfall chart plots one series, not a…
- Gauge Chart in Excel: Build and Format OneTo make a gauge chart in Excel for Microsoft 365 on Windows, create a doughnut chart from three…
- Excel Line Chart Smooth Curve: Setup, Limits, and TipsYes. In Excel for Microsoft 365 on Windows, select a line in the chart, open Format Data Series,…
- Excel: How to Move a Pie Chart Within the Chart AreaTo move a pie chart within its chart frame in Excel for Microsoft 365 on Windows, select the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.