How to Flip a Bar Graph in Excel: Reverse Its Order

To flip the order of bars in an Excel chart, right-click the category axis, choose Format Axis, and select Categories in reverse order. If you mean changing horizontal bars to vertical columns, use Chart Design > Change Chart Type instead. The steps below explain both, along with how to swap the chart’s data series.

These instructions are for Excel for Microsoft 365 on Windows. Before changing a chart, decide what you want to flip: the top-to-bottom order of the categories, the direction of the value scale, the layout of series and categories, or the chart’s horizontal-versus-vertical orientation. These actions look similar but do different things.

What You’ll Need

An Excel workbook with data arranged in rows or columns and a bar chart, or data from which you can create one.
Permission to edit the workbook. If you are working in a protected sheet, you may need the owner to allow chart or formatting changes.
A clear idea of the intended result. For example, decide whether the first category should appear at the top or whether you want a column chart with vertical bars.

Step-by-Step

Select the chart and identify its type. Click the chart once to show the chart tabs on the ribbon. A bar chart has horizontal bars; a column chart has vertical bars. Click the chart area rather than a worksheet cell so that Excel displays Chart Design and Format. If there is no chart yet, select the category labels and values, choose Insert, and select a bar chart from the Insert Column or Bar Chart menu.
Reverse the order of categories in a horizontal bar chart. Click the category labels along the chart’s vertical edge. These are usually the names of products, people, dates, or other groups. Right-click the labels and choose Format Axis. In the Format Axis pane, select Axis Options if it is not already open, then check Categories in reverse order. Excel immediately changes which category appears at the top and which appears at the bottom. For instance, if the existing order runs from A at the top to D at the bottom, reversing categories puts D at the top and A at the bottom.
Check where the value axis and labels appear. Reversing categories can also move the value axis, gridlines, or category labels to a less convenient side. In the Format Axis pane for the category axis, find Horizontal axis crosses and choose At maximum category if you want the value axis to cross at the opposite end of the category list. The exact visual result depends on the chart and its settings, so check the preview and change the setting back if it puts the axis in the wrong place. To adjust where category names sit, use the Labels options in the same pane.
Reverse the numerical scale only if that is what you intend. If you want low values on the right and high values on the left, select the horizontal value axis, right-click it, and choose Format Axis. Under Axis Options, check Values in reverse order. This reverses the scale, not the sequence of category names. On a standard bar chart, it can make the chart harder to read, so use it only when a reversed scale is meaningful for your data. If your goal is simply to put the last category first, leave this option unchecked and reverse the category axis instead.
Swap which data appears as categories and series if needed. Click the chart, then choose Chart Design > Switch Row/Column. This changes how Excel interprets the selected data: rows may become series and columns may become categories, or the other way around. It does not simply reverse the top-to-bottom order of bars. Use it when Excel has made a separate series for each category, or when the legend and category labels are arranged the wrong way. Review the legend and axis labels after switching; undo with Ctrl+Z on Windows if the result is not what you wanted. On Mac, use Command+Z.
Change horizontal bars to vertical columns, or the reverse. Select the chart and choose Chart Design > Change Chart Type. In the dialog, select Bar for horizontal bars or Column for vertical bars, choose the specific subtype you want, and select OK. A Clustered Bar chart, for example, becomes a Clustered Column chart when you choose that column subtype. This changes the chart’s orientation, not the order of its categories. If the chart contains multiple series, check that the new type still makes the data easy to compare.
Confirm the chart uses the right data range. If categories are missing, repeated, or in an unexpected order, select the chart and choose Chart Design > Select Data. Check the Chart data range and review the entries under Legend Entries (Series) and Horizontal (Category) Axis Labels. Select Edit for the category labels if you need to point Excel to the correct cells. Changing the range can alter the chart, so verify that each category is paired with its intended value.
Review and save the result. Check the chart title, category names, value labels, axis direction, and legend. If the bars are reversed but the labels are difficult to follow, consider adding data labels or sorting the source table into the order readers expect. Save the workbook when the chart looks right. Reversing chart order normally changes the chart formatting rather than sorting or changing the worksheet data.

On Excel for Mac, the chart tabs and Format Axis pane have similar controls, although the ribbon layout can differ slightly by release. On Excel for the web, select the chart and look for chart formatting or axis options; if Categories in reverse order or another setting is unavailable in your browser version, open the workbook in the Excel desktop app to make that change.

Common Mistakes

Reversing the wrong axis: The category axis contains the names or groups. The value axis contains the numbers. Reversing the value axis changes the direction of the numeric scale; it does not put the categories in reverse order.
Using Switch Row/Column to reverse the list: This command changes how Excel groups the data into series and categories. It can make a chart look very different, but it is not the control for flipping the order of category names.
Changing the worksheet sort when only the chart needs changing: Sorting the source table rearranges the data itself and can affect other calculations or tables. Use the axis setting when your aim is only to change the chart’s display order.
Clicking a bar instead of the category axis: Selecting a single bar may open options for a data point or series, not the category axis. Click the category labels, then right-click and choose Format Axis. If it is hard to select the axis, use the chart formatting selection list on the Format tab to choose the category axis.
Assuming flipping changes the values: Reversing the category order changes the chart’s presentation, not the underlying numbers. Still, check that the source data is paired correctly; a chart can faithfully display an incorrectly selected data range.

Tips

Sort the source data when you want a reusable ranking. If the chart should always show the highest value first, sorting the table by its value column may be a better approach than manually adjusting categories. Decide whether the table itself should be reordered before sorting.
Use a horizontal bar chart for long labels. Long category names are often easier to read beside horizontal bars than beneath vertical columns. Flipping the category order can place the most important or most recent item at the top.
Keep the chart’s meaning clear. If you reverse the value scale, make sure the axis labels and chart title make that choice obvious. A reader may otherwise assume values increase in the usual direction.
Check more than the bars. Legends, data labels, error bars, and axis titles can become less intuitive after switching rows and columns or changing chart type. A quick visual review prevents a technically correct chart from being confusing.
Undo promptly when a command changes too much. Ctrl+Z on Windows or Command+Z on Mac restores the previous state for many chart edits. If you have made several changes since then, use Format Axis to adjust the specific setting rather than undoing unrelated work.

Troubleshooting

The category order did not change. Make sure you selected the category axis, not the value axis or a bar. In Format Axis, verify that Categories in reverse order is checked. If that option is unavailable, check whether the chart type supports category ordering; switching to a standard bar or column chart can help you confirm whether the issue is chart-specific.

The value axis moved to the top. This can happen when categories are reversed. Select the category axis again and try setting Horizontal axis crosses to At maximum category. If that moves the value axis to the wrong place for your chart, restore Automatic or choose the alternative crossing option and inspect the result.

The bars point in the wrong direction. You may have reversed Values in reverse order on the numerical axis. Select the horizontal value axis, open Format Axis, and clear that setting. Then select the category axis and use Categories in reverse order if you want the list flipped instead.

The chart changed into an unexpected grouping. You may have selected Switch Row/Column. Undo the action, or use Chart Design > Select Data to check the series and category label assignments. Switch Row/Column is appropriate when the series and categories are transposed, not when the category sequence alone needs reversing.

Some labels or values disappeared. Open Chart Design > Select Data and inspect the chart data range. Make sure the selected range includes the full set of category labels and the corresponding numeric values, and check that the first row or column is being used as labels where appropriate. If the source data includes blanks or extra headings, adjust the range to exclude them.

You cannot edit the axis. Confirm that the sheet or workbook is not protected and that you have selected a chart axis rather than the chart background. If a workbook opened in a browser does not expose the control you need, choose Open in Desktop App and make the change in Excel for Microsoft 365.

Frequently Asked Questions

How do I make the first bar appear at the top?
For a horizontal bar chart, select the category axis, choose Format Axis, and check Categories in reverse order. Depending on the chart’s current order, you may need to clear the box instead to put the first category at the top.

Can I flip a bar chart without changing my data?
Yes. Reversing the category axis changes the chart’s display order without rearranging the source worksheet. Changing the chart type or switching rows and columns also changes the chart setup, but does not by itself rewrite the data cells.

What is the difference between a bar chart and a column chart?
A bar chart displays bars horizontally, while a column chart displays them vertically. Choose Chart Design > Change Chart Type to move between them. Reversing the category axis is a separate setting.

Can I reverse only one series in a chart?
The category order belongs to the chart axis and generally affects all series that share that axis. To display series in a different order, use Chart Design > Select Data and adjust the series order in the Legend Entries (Series) list, if that is the change you mean.

Will new data keep the chart’s reversed order?
Usually, the axis setting remains applied as the chart range updates. However, adding categories or changing the source range can affect the displayed result, so check the chart after expanding its data range or refreshing connected data.

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.