To reverse an Excel chart’s category order, right-click the category axis, choose Format Axis, then under Axis Options select Categories in reverse order. To flip a numeric axis instead, select Values in reverse order. These options change how the chart is displayed; they do not rearrange the worksheet data.
What “reverse order” means in an Excel chart
Excel charts have different kinds of order, so the right setting depends on what you want to flip. A category axis contains labels such as months, product names, or task names. A value axis contains a numerical scale, such as dollars or percentages. Reversing one axis does not automatically reverse the other.
For example, a bar chart may show product names vertically and sales values horizontally. If the first product appears at the bottom but you want it at the top, reverse the category axis. If the values should run from high on the left to low on the right, reverse the value axis instead. A line chart usually places categories along the bottom and values up the side, so reversing the category axis changes the left-to-right sequence.
There is also a separate kind of order: the order of the chart’s data series. A chart with separate lines for North and South, for example, can have those series reordered without changing the category or value axes. These are three distinct adjustments: category order, numeric scale direction, and series order.
Reverse category order step by step
In Excel for Microsoft 365 on Windows, use the chart’s category axis—the axis showing labels rather than a numerical scale:
- Click the chart, then click the category-axis labels you want to reverse.
- Right-click the selected axis and choose Format Axis. Excel opens the Format Axis pane.
- In Axis Options, select Categories in reverse order.
- Check the chart’s axis position and label placement. If necessary, adjust the crossing option as described below.
For a column chart, the category axis is usually horizontal along the bottom. For a bar chart, it is usually vertical at the left. The setting applies to the axis you selected, so confirm you have the category labels—not the value scale—selected before opening the pane.
In Excel for Mac, select or Control-click the axis and choose Format Axis; the corresponding reverse-order option is in the axis formatting controls. The pane’s layout can differ slightly between platforms and builds. Excel for the web has chart-formatting controls too, but if the option is unavailable in your current web interface, open the workbook in the desktop app.
Reverse a value axis
To make a numerical scale run in the opposite direction, select the value axis and open Format Axis. Under Axis Options, choose Values in reverse order. This can be useful for a chart where the largest values should appear at the bottom or where a reversed scale is meaningful to the presentation.
Consider a horizontal bar chart with a value axis running from 0 on the left to 100 on the right. Reversing that value axis places 100 on the left and 0 on the right. It does not sort the bars, change their values, or make the data negative; it reverses the direction in which Excel displays the scale. Use the option carefully because a reversed scale may surprise readers if it is not clearly labeled.
For a scatter chart, both axes represent numerical values, rather than one being a list of categories. Select the particular horizontal or vertical value axis you want to flip, then use Values in reverse order. Reversing the horizontal axis changes the left-to-right direction; reversing the vertical axis changes the bottom-to-top direction.
Keep the axis in a useful position
Reversing categories can also change where the other axis crosses the chart. For example, when you reverse the categories in a bar chart, the horizontal value axis may move from the bottom to the top. This is not a change to the values; it is a consequence of the axes’ crossing point following the reversed category arrangement.
If that happens, select the category axis and look in Format Axis under Axis Options for Horizontal axis crosses. Choosing At maximum category can put the horizontal axis at the opposite edge, such as the bottom of a reversed bar chart. The exact available controls depend on the chart type and which axis is selected, so check the result rather than assuming the same setting applies to every chart.
Axis labels can also move. The labels might appear on the far side of the chart, or the axis line may cross the plot area in a different place. Use the axis-label position and crossing controls in the Format Axis pane to make the layout readable. These presentation adjustments do not reorder the underlying worksheet rows.
Reorder chart series separately
If the category sequence is correct but the lines, bars, or legend entries are in the wrong order, change the series order instead. Select the chart, then choose Chart Design > Select Data. In the Legend Entries (Series) list, select a series and use the up or down controls to change its position. The legend and plotted series order update accordingly.
This distinction matters especially in a stacked bar or column chart. Moving a series can change where that series appears within the stack, as well as its position in the legend. It does not reverse the categories along the axis. In a line chart, moving series can change the order in which lines are drawn, which may affect which line appears in front where lines overlap.
If you want categories to appear in a different order because the data itself should be sorted, use the worksheet or table’s sorting tools instead. That changes the source order and can affect other formulas, charts, or reports that use the same data. Reversing the axis is usually the safer choice when you only want a different visual orientation.
What changes—and what does not
Axis reversal changes the chart’s display, not the meaning or stored sequence of the source cells. A worksheet listing January through June remains in that order if you reverse the chart’s category axis. The chart simply presents the categories in the opposite direction. This is useful when you want a timeline to read from recent to earlier, or when a horizontal bar chart should put the most important category at the top.
That does not mean the chart’s appearance is always independent of its source. If you sort the source data, the chart will generally reflect the new order. And if you reverse the axis, Excel may alter the apparent placement of the crossing axis or labels. Keep these separate questions in mind:
- Only change how labels appear: reverse the category axis.
- Change the direction of a numeric scale: reverse the value axis.
- Change which series is plotted first: reorder series in Select Data.
- Change the actual record sequence: sort the source data.
A common misconception is that reversing a chart also sorts the worksheet from largest to smallest. It does not. If you need the underlying records sorted—for instance, so a separate report or calculation uses the same order—sort the source range or table explicitly.
Chart types and common limitations
Most standard charts with axes offer a way to reverse the displayed order, but the wording depends on the axis type. Category axes use Categories in reverse order; numerical axes use Values in reverse order. A date axis may be treated as a date or category axis depending on the chart setup and axis settings. If you do not see the option you expect, first verify the selected axis and the chart type.
Pie and doughnut charts do not have category and value axes in the same way a bar or line chart does. To change their slice order, you generally need to change the source category order or adjust the series settings available for that chart, rather than look for an axis-reversal checkbox. Likewise, a chart without visible axes may still have an axis setting, but selecting the correct axis can be harder; click the plot area or use chart selection controls to identify chart elements.
PivotCharts can be tied to the order of their PivotTable fields and items. If the chart follows a PivotTable’s sorting or filtering, adjust the relevant field or item order in the PivotTable when you need the source presentation to change. An axis reversal may change the chart’s display, but it does not replace PivotTable sorting or filtering.
Troubleshooting a chart that looks wrong
If the reverse-order checkbox appears to do nothing, or the chart changes in an unexpected way, work through these checks:
- Confirm the selected axis. Category and value axes have different controls. Click an axis label and check the selection before opening Format Axis.
- Check whether the chart is a bar or column chart. Their category and value axes run in different directions, so it is easy to select the wrong one.
- Look at the crossing point. The axis may have moved to the opposite edge. Adjust the crossing option if you want it at the top, bottom, left, or right.
- Check label position and readability. Reversal can move category labels, and long labels may become harder to read at the new edge.
- Distinguish axis order from series order. If the legend or stack is wrong but the category labels are right, use Select Data to reorder series.
- Consider the source range. If data was sorted or rearranged, the chart may be reflecting that change rather than an axis setting.
When the chart is meant to communicate a ranking, make sure readers can still interpret it. A reversed numerical scale is particularly easy to mistake for an ordinary low-to-high scale. Clear axis titles, readable tick labels, and a sensible crossing position help prevent that confusion.
Frequently Asked Questions
How do I reverse the order of bars in an Excel chart?
Right-click the category axis, choose Format Axis, and select Categories in reverse order under Axis Options. In a bar chart, the category labels are usually on the vertical axis.
Can I reverse an Excel chart without changing the data?
Yes. Reverse the category or value axis in the Format Axis pane. That changes the chart’s displayed direction without rearranging the source cells.
How do I make the horizontal axis stay at the bottom?
After reversing the categories, select the category axis and check Horizontal axis crosses in Format Axis. For many reversed bar charts, At maximum category places the horizontal axis at the bottom.
How do I reverse the order of legend items?
Select the chart and choose Chart Design > Select Data. In Legend Entries (Series), select a series and move it up or down. This changes series order, not category order.
Does reversing a chart sort the worksheet data?
No. It changes the chart’s display. To reorder the actual records, sort the worksheet range or table separately.
Related
- Conditional Formatting Excel Dates Before a Date Rule
- Excel 3-Color Scale: How It Works and When to Use It
- Excel Conditional Formatting Based on Color: How It Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart Gridline Interval: How to Set ItIn Excel for Microsoft 365 on Windows, set a chart’s gridline interval by formatting the axis that the…
- Excel Stacked Bar Chart With Two Data Sets ExplainedTo make an Excel stacked bar chart with two data sets, arrange categories in the first column and…
- Excel Chart Creation: Steps, Choices, and FixesYes—Excel makes chart creation straightforward: select your data, choose Insert > Recommended Charts, pick a chart, and select…
- Excel Pivot Table Won’t Sort? Fixes for Common Sorting ProblemsIf an Excel PivotTable will not sort, select an item in the field you want to reorder, right-click…
- Create an Org Chart in Excel From a ListYes. Put each person in a list with their manager, then use Insert > SmartArt > Hierarchy >…
- Excel Graph Sparklines: Create and Customize Mini ChartsExcel sparklines are tiny charts placed inside worksheet cells, giving you a compact view of a data series…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.