How to Make a Chart in Excel Run From Right to Left

To make an Excel chart read from right to left, select the axis you want to reverse, right-click it, choose Format Axis, then open Axis Options and select Categories in reverse order or Values in reverse order, depending on the chart. These settings do different things: one reverses category order, while the other reverses the numeric scale. The steps below explain how to choose the right one in Excel for Microsoft 365 on Windows.

What You’ll Need

Excel for Microsoft 365 on Windows. The same general axis-formatting options are available in many recent desktop versions of Excel.
A worksheet with the data you want to chart, arranged in columns or rows with clear labels.
A chart type that supports the axis you want to reverse. Bar, column, line, and scatter charts offer different axis controls.
Optional: a copy of the workbook if you want to preserve the original chart settings before changing them.

Step-by-Step

Decide what you mean by right to left. There are two common goals. If you want the categories to appear in the opposite sequence—for example, to put the first item at the bottom of a horizontal bar chart—reverse the category order. If you want the horizontal numeric scale to descend from left to right, so bars extend toward the left, reverse the value order. For a line chart, you may want the earliest date at the right and the latest at the left; that means reversing the horizontal axis order. Choose the outcome before changing settings, because reversing the wrong axis can make the chart confusing.
Check the source data and select it. Make sure labels and values line up in the same rows or columns, and include the header cells if they identify your series. For example, a table might have month names in A2:A13 and sales figures in B2:B13, with headers in A1 and B1. Select the full range, including headers. Avoid selecting blank rows or unrelated columns, which can add empty categories or extra series to the chart.
Insert a suitable chart. Select Insert on the ribbon, then choose a chart type from the Charts group. For horizontal comparisons, use Insert Bar Chart and choose a clustered bar chart. For values across time, use a line chart or column chart. For two numeric variables, use a scatter chart. If a chart already exists, select it and continue. A bar chart is often easiest to read when category names are long.
Open the Format Axis pane for the axis you need. Click the chart, then click the axis labels or numbers you want to change. Right-click the selected axis and choose Format Axis. Excel opens the Format Axis pane, usually on the right. Confirm that the pane title refers to the intended axis; clicking a label, gridline, or data series can select a different chart element. In the pane, choose Axis Options, represented by the small column-chart icon if the icons are shown.
Reverse category order when you want to change the item sequence. In a horizontal bar chart, click the vertical axis that lists the category names. Under Axis Options, select Categories in reverse order. The first category in the source data will move to the bottom and the last will move to the top. This changes the vertical list; it does not make the bars grow from right to left. For a line or column chart with categories along the bottom, select the horizontal category axis and use the same option to reverse the order along the chart.
Reverse the value scale when bars should extend from right to left. For a horizontal bar chart, click the horizontal axis with the numeric scale, such as 0, 20, 40, and 60. In Format Axis under Axis Options, select Values in reverse order. Excel flips the numeric scale so larger values appear on the left and the bars extend leftward from the right side of the plot area. The value-axis crossing point may move as well. If the vertical category axis now appears on the opposite side, adjust its crossing setting in the axis options, or leave it if that placement suits the chart.
Reverse a line or column chart’s horizontal sequence if needed. Select the horizontal category axis, right-click it, and choose Format Axis. For an ordinary category axis, select Categories in reverse order. The plotted sequence will run in the opposite direction. If the chart uses dates, Excel may treat the horizontal axis as a date axis but still expose the category-order option. Check the result carefully: reversing dates makes the chronology run backward, which is useful for some layouts but less familiar to many readers.
Reverse a scatter chart’s horizontal numeric axis. Scatter charts use numeric axes rather than category axes. Click the horizontal numeric axis, open Format Axis, then select Values in reverse order under Axis Options. The x-values will run from larger on the left to smaller on the right. If you instead want to reverse the vertical scale, select the vertical numeric axis and change its value-order setting. Reversing an axis changes the display, not the values in the worksheet.
Check axis crossing and labels after reversing. Reversing an axis can move the other axis, its labels, or the zero point. In the Format Axis pane, look for the crossing controls under Axis Options and choose a position that keeps labels readable. For a bar chart, you might prefer the category labels to stay beside the bars rather than far from them. You can also use the axis label position options to move labels if they overlap or appear on the wrong side.
Review and save the chart. Confirm that categories appear in the intended order, values increase or decrease in the intended direction, and the title and axis labels explain the chart clearly. Check that the reader can tell whether a larger value is farther left or farther right. If the chart is meant to show time, make the reversed chronology explicit in the title or a note. Save the workbook after reviewing the chart at its normal viewing size.

On Excel for Mac, select the axis and use the contextual menu’s Format Axis command; the Format Axis pane has similar Axis Options controls, though the pane layout can differ. In Excel for the web, select the chart and look for axis formatting in the chart formatting pane. If the reverse-order option is not available for your chart there, open the file in the Excel desktop app and make the change in that version.

Common Mistakes

Reversing categories when you mean to reverse the numeric direction. On a bar chart, the category names are on the vertical axis and the values are on the horizontal axis. Use the category option to flip the top-to-bottom list; use the value option to make the numeric scale run in the opposite direction.
Assuming every chart uses the same kind of axis. Line and column charts commonly use category axes, while scatter charts use numeric axes on both dimensions. The wording in the pane can differ accordingly. Select the axis itself and check its labels before choosing an option.
Thinking the worksheet data has been rearranged. Reversing the display order does not sort, move, or edit the source cells. The chart reads the same values; it simply draws them in a different visual order.
Leaving the title or axis labels misleading. A chart with values increasing toward the left can surprise readers. Add a clear title and retain readable tick labels so the direction is obvious.
Changing the wrong axis or chart element. Clicking a gridline, legend, or data series can open a different formatting pane. Right-click a visible axis label or tick mark, then verify the pane identifies the axis before changing its options.
Reversing the order without considering chronology. A reversed date axis may make the newest value appear first, but it can also make a trend harder to follow. Use it only when that reading direction is intentional.

Tips

For a horizontal bar chart that lists the first source item at the top, reverse the category order. Excel may also shift the value axis to the opposite side; check the crossing controls if you want to reposition it.
For bars that should grow from the right edge toward the left, reverse the horizontal value axis, not the vertical category axis. Consider whether a descending scale will be clear to your audience.
Test the setting with a small sample chart before applying the same approach to a dashboard or report with many charts.
Keep the source data in the order that makes sense for calculations and maintenance. You usually do not need to sort the worksheet just to change the chart’s display order.
If you need to show a familiar time progression, keep older dates on the left and newer dates on the right unless the design has a specific reason to do otherwise.
After changing the axis direction, inspect data labels, gridlines, and the legend. These can still be technically correct but visually awkward in the new layout.

Troubleshooting

The chart still looks left to right. Check whether you selected the category axis or the value axis. On a horizontal bar chart, reversing the category order only changes which item is at the top; it will not reverse the direction in which bars extend. Select the horizontal numeric axis and turn on Values in reverse order if the scale itself needs to flip.

The categories are upside down, but the bars point the way I want. That is the expected result when category order is reversed. If the first item should be at the top, keep Categories in reverse order selected and review where the value axis crosses the category axis. Adjust the crossing option if the axis line or labels moved to an inconvenient position.

The reverse option is missing. Confirm that you selected an axis, not the chart area or a data series. Then inspect the chart type: a pie chart, for example, has no horizontal axis to reverse. Some chart options are also limited in Excel for the web. Open the workbook in the desktop version of Excel, or choose a chart type with the axis you need.

The labels move to an unexpected side. Axis reversal can change where Excel places the other axis. In the Format Axis pane, inspect the axis crossing controls and label-position options. Try a different crossing position, then check that the labels do not overlap the plotted data or disappear beyond the chart edge.

The order changes when I update the data. The chart may be set to reverse its displayed axis order, so new categories can appear at the opposite end from where you expect. Review the source range and axis settings after adding data. If the chart is based on a table, confirm that new rows are included in the chart’s source data.

The dates look out of sequence. Check whether the date axis is intentionally reversed and whether the source cells contain actual Excel dates rather than text that resembles dates. If you want the usual chronology, turn off the reverse-order option. If you want newest-to-oldest presentation, keep it and label the chart so the direction is clear.

Frequently Asked Questions

Can I make only the bars run from right to left?
Yes. In a horizontal bar chart, select the horizontal value axis and choose Values in reverse order. The category list can remain in its existing order, although you may also reverse it separately.

How do I put the first category at the top of a bar chart?
Select the vertical category axis, open Format Axis, and select Categories in reverse order. Excel moves the first source category to the bottom, so check the resulting list and adjust the axis crossing position if needed.

Will reversing an axis change my source data?
No. It changes how Excel displays the chart. The values and their order in the worksheet remain unchanged, and formulas that use the source cells are unaffected.

Can I reverse the horizontal axis in a scatter chart?
Yes. Select the horizontal numeric axis, open Format Axis, and choose Values in reverse order. This makes higher x-values appear to the left and lower x-values to the right.

Can I make an Excel chart read right to left because my worksheet is right to left?
Worksheet direction and chart axis direction are separate settings. Reversing a chart axis changes the order of its plotted categories or values; changing a worksheet’s reading direction does not necessarily reverse each chart’s data axis. Set the chart axis directly for the layout you need.

Can I reverse a pie chart?
A pie chart has no horizontal or vertical axis, so the axis-reversal controls do not apply. To change the slice sequence or starting position, select the pie and use its data-series formatting options, or reorder the source data if you want a different category sequence.

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.