Excel Graph Reverse Data Order: Flip an Axis or Series

To reverse the order of categories in an Excel graph, select the chart, right-click its category axis, choose Format Axis, and turn on Categories in reverse order under Axis Options. This changes how the chart is displayed, not the order of rows in the worksheet; reversing a value axis or the series order requires a different setting.

What reversing data order changes

In Excel, “reverse data order” can refer to a few different chart changes. The right method depends on what looks backward: the sequence of labels along an axis, the direction of the numeric scale, or the order in which data series appear. These settings affect the chart’s presentation and generally leave the source cells untouched.

For example, a chart might list months from January to December while you want December at the left. Or a horizontal bar chart might put the first item at the bottom even though you want it at the top. Those are category-axis issues. If a vertical scale runs from 0 at the top to 100 at the bottom, that is a value-axis issue. If one line or stacked bar appears in front of another, you may need to reorder the series.

It helps to identify the axis or chart element that needs changing before opening the Format Axis pane. A chart’s horizontal axis is not always its category axis: in a bar chart, categories are typically on the vertical axis, while values are on the horizontal axis.

Reverse category order on an axis

In Excel for Microsoft 365 on Windows, use these steps to reverse category labels:

Click the chart, then click the axis labels whose order you want to change. In a column chart, this is usually the horizontal axis; in a bar chart, it is usually the vertical axis.
Right-click the selected axis and choose Format Axis. The Format Axis pane opens.
In Axis Options, select Categories in reverse order.
Check the chart’s axis crossings and label placement. Adjust them if the reversal moves them to an unexpected side.

The exact setting is available for category axes, though the pane’s layout can vary slightly between Excel releases. If the wrong axis is selected, the checkbox may not appear. Click directly on the labels for the axis you want, or use the Current Selection controls on the Format tab to choose the axis.

On Excel for Mac, the same general route applies: select the chart axis, open Format Axis, and look under Axis Options for Categories in reverse order. In Excel for the web, select the chart and use its formatting pane; available controls and their placement can differ from the desktop app. If a control is missing in the web version, open the workbook in the desktop application.

How reversal behaves in common chart types

In a horizontal bar chart, the category axis is vertical. Excel often places the first category at the bottom by default. Turning on Categories in reverse order can put that first category at the top, which is useful when the list is ranked or when readers expect the first row to appear first. The numeric value axis remains a separate element.

In a column or line chart, categories usually run along the horizontal axis. Reversing their order moves the first category to the opposite end of the plot area. A sequence such as Q1, Q2, Q3, Q4 may then display from right to left. This can be helpful when matching a timeline’s direction to a particular convention, but it may be less familiar to readers than the usual left-to-right progression.

In a chart with a date axis, Excel treats dates as positions on a time scale rather than merely unrelated text labels. You can still reverse the displayed direction where the axis options permit it, but first check whether the axis is set as a date axis or a text/category axis. That choice affects spacing: a date axis can account for elapsed time between dates, while a text axis gives each label an equal position.

For an XY (scatter) chart, both axes are value axes. There is no ordinary category axis to reverse. Use the value-axis setting instead if you want the numeric scale to run in the opposite direction.

Reverse a value axis

To flip the direction of a numeric scale, select the value axis, right-click it, and choose Format Axis. Under Axis Options, select Values in reverse order. For instance, a vertical scale that normally increases upward can be made to increase downward. The setting changes the visual direction of the scale; it does not change the actual values or recalculate the series.

Reversing an axis can also affect where the other axis crosses it. In a bar chart, reversing the category axis may cause the value axis to appear on the opposite side of the plot area. Reversing a value axis can likewise move the category axis or its labels. Look in Axis Options for controls such as the setting for where the horizontal axis crosses, or the corresponding crossing option for the selected axis. Choose the desired crossing position rather than assuming the axis will stay put.

Be careful with a reversed numeric scale in reports. Readers often interpret a larger value as higher or farther to the right. If the chart must use a reversed scale—for example, to match a map orientation or another visual convention—make the direction clear with readable labels and, where appropriate, a note.

Change the order of chart series

If the categories are in the right order but the series are not, change the series order rather than reversing an axis. Select the chart, then choose Chart Design > Select Data. In the Select Data Source dialog, use the Legend Entries (Series) list. Select a series and use the up or down arrow controls to move it, then confirm the change.

Series order can affect more than the legend. In a stacked column or bar chart, it can change the order of segments within each stack. In charts where series overlap, it can affect which series is drawn in front. The effect depends on the chart type, so inspect both the plot and the legend after moving a series.

Do not confuse reordering series with Switch Row/Column. That command changes whether rows or columns in the selected source range are interpreted as separate series. It is useful when Excel has assigned categories and series the wrong way around, but it is not simply a reverse-order control. It is also different from sorting the worksheet data.

Chart order versus worksheet order

A reversed chart axis does not normally reorder the underlying table. Your formulas, source records, and other charts that use the same cells remain based on the original data order. This is often the safest option when the worksheet is arranged for data entry or another report, but one chart needs a different visual sequence.

If you want the worksheet itself and every dependent output to use a new order, sort the source range instead. On the Data tab, use the sorting controls and make sure the full table is included so values stay attached to the correct labels. Sorting is a data change, not merely a formatting change; take care with formulas, references, and other charts that depend on the range.

Another option is to create a separate helper range in the desired order and base the chart on that range. This keeps the original data intact while giving the chart a source designed for its presentation. It can be a practical choice for a chart that must show a custom order, such as a ranking that is not alphabetical or a sequence that follows a business process.

Common problems and how to fix them

The order did not change: Confirm that you selected the category axis, not the value axis or the chart area. The relevant checkbox depends on the axis type.
The labels moved to the other side: Reversing an axis can change where axes cross. Review the crossing and label-position options in the Format Axis pane.
The wrong items appear to be reversed: If the legend or stacked segments are the issue, use Chart Design > Select Data to reorder the series. Axis reversal changes category or value direction, not the series list.
The chart is based on a PivotTable: PivotCharts are connected to their PivotTable, so the displayed category order may be governed by PivotTable sorting or filtering. Check the field’s sort order as well as the chart axis settings.
The chart has dates or numbers as labels: Check whether Excel is treating the axis as a date, text, or value axis. The available reversal options and spacing behavior depend on that axis type.
The first bar is still not where expected: A horizontal bar chart’s category axis is vertical, and its default visual direction can be counterintuitive. After reversing categories, inspect the chart rather than relying on the worksheet’s top-to-bottom order.

For a quick diagnosis, click the axis labels and look at the title at the top of the Format Axis pane. If it identifies the value axis when you meant to change category order, close the pane and select the other axis.

Choosing the right method

Use axis reversal when the data is correct and only the chart’s direction or category presentation needs to change. Use series reordering when the legend, stacked segments, or overlapping series need a different sequence. Use worksheet sorting when the records themselves should be rearranged, and use a helper range when the chart needs its own deliberate order without disturbing the original table.

Consider the reader’s expectations as well as the mechanics. Chronological charts are usually easiest to follow from earlier to later, and numeric scales are usually easiest to interpret when larger values move upward or to the right. Reversing those conventions can still be appropriate, but provide clear labels and avoid making a positive trend look negative—or the reverse—by accident.

Frequently Asked Questions

Does reversing a chart axis reverse the data in my Excel sheet?
No. The axis option changes the chart’s display order, not the source cells. Sort the worksheet range separately if you need to change the records themselves.

How do I put the first item at the top of an Excel bar chart?
Select the vertical category axis, choose Format Axis, and turn on Categories in reverse order. Check the axis crossing afterward because Excel may move the value axis to the other side.

Can I reverse only the legend order?
Use Chart Design > Select Data and move the series in the Legend Entries (Series) list. This may also affect the drawing or stacking order, depending on the chart type.

Why does my Excel chart have Values in reverse order instead?
You have probably selected a numeric value axis. Select the axis with category labels to find Categories in reverse order. In a scatter chart, both axes are numeric value axes, so category-order controls do not apply.

Can I reverse chart order in Excel for the web?
Excel for the web has chart formatting controls, but their availability and layout can differ from the Windows desktop app. If the axis option you need is not available in the web pane, open the workbook in desktop Excel and change it there.

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.