Excel Chart: How to Change Bar Order

To change the order of bars in an Excel chart, either sort the chart’s source data, reverse the category axis, or change the order of the data series—depending on what you mean by “order.” In Excel for Microsoft 365 on Windows, sorting the source changes the categories’ sequence, while reversing the category axis flips their display direction without rearranging the worksheet.

First identify which order you want to change

“Bar order” can refer to three different things in a chart. Identifying the one you mean helps avoid changing the wrong setting:

Category order: The sequence of labels, such as North, South, East, and West. Sort the source data to arrange categories by value or name; reverse the category axis to flip their visual direction.
Series order: The order of multiple measures, such as Actual and Forecast, or the order of colored segments in a stacked bar. Change the series order in the chart’s data selection.
Bar direction: Whether bars extend from left to right or right to left. This is generally controlled by the value axis and its number format or axis settings, not by sorting categories.

This guide focuses on horizontal bar charts, but most of the same distinctions apply to column charts. In Excel, a bar chart has categories along the vertical axis and values along the horizontal axis; a column chart puts categories along the horizontal axis and values along the vertical axis.

Sort the source data to set a custom category order

If you want the chart to follow a meaningful sequence—such as highest sales first, months in calendar order, or departments in a chosen arrangement—the most reliable method is usually to sort or rearrange the data feeding it. A standard chart generally reflects the order of its source categories.

Click a cell in the data table, including its category labels and the values used by the chart.
Open Data > Sort. If your data has headers, confirm that My data has headers is selected.
Choose the column to sort by, such as Sales, and select the order—for example, largest to smallest.
Choose OK. The chart should update to reflect the new category sequence.

For example, suppose a worksheet lists apples with 42 sales, pears with 67, and oranges with 51. Sorting the complete table by sales from largest to smallest produces Pears, Oranges, Apples, and a linked chart ordinarily follows that order. Sort the whole table rather than just the sales column; sorting one column alone can disconnect values from their labels.

If the desired order is not alphabetical or numeric—perhaps the workflow must always appear as Intake, Review, Approval, Complete—rearrange the complete source rows into that sequence. You can also add a separate numeric sort key to the source table and sort by it. Keep the key in the data table, but exclude it from the chart’s selected data range unless you specifically want it charted.

Reverse the category axis to flip the display

A horizontal bar chart can show the first source category at the bottom, which may look opposite to what you expect. You can flip the displayed category order without sorting the worksheet. This changes how the chart is drawn, not the order of the underlying records.

Select the chart, then click the category labels along its vertical side.
Right-click the labels and choose Format Axis.
In the Format Axis pane, open Axis Options.
Select Categories in reverse order.

The categories will now appear in the opposite top-to-bottom sequence. This setting is useful when the chart should read from the first category at the top, or when you want the largest bar at the top but do not want to alter the worksheet’s order. To restore the prior display, clear Categories in reverse order.

Reversing categories can also move the value axis to the opposite side of the chart. Excel may place that axis at the maximum category, depending on the chart and axis settings. If the value labels or axis line appear on the wrong side, select the category axis again in Format Axis and look for the setting that controls where the horizontal axis crosses. Set it to the desired category position; the exact available choices depend on the chart’s axis configuration.

Change the order of series or stacked segments

If your chart contains multiple data series, changing category order will not rearrange the series. For example, a clustered bar chart might show one bar for 2024 and another for 2025 for each product. A stacked bar chart might use separate series for Online, Store, and Wholesale. The series order controls their sequence in the chart and often affects the legend order as well.

Select the chart.
Go to Chart Design > Select Data.
Under Legend Entries (Series), select the series to move.
Use the up or down arrow buttons to change its position, then select OK.

In a stacked bar chart, the series order determines the arrangement of segments within each bar. Depending on the chart layout, the first series may appear at the bottom or left of the stack, so check the chart after moving it. The legend order may change with it. Changing series order does not sort the category labels or change the values in the worksheet.

If you only need the legend to tell a different story, note that the legend normally follows the series order. Reordering the series can therefore affect both the legend and the plotted bars. Excel does not treat a legend as an entirely separate list in the standard chart setup.

How bar charts differ from column charts

In a horizontal bar chart, category labels run down the side and the bars extend across the chart. In a column chart, category labels run along the bottom and the columns extend upward. That difference changes which axis setting to select: for a bar chart, format the vertical category axis; for a column chart, format the horizontal category axis.

Sorting the source table works similarly for both chart types. If you reverse categories in a column chart, the first and last categories swap positions along the bottom. Excel may also shift where the vertical value axis crosses the categories. If your goal is simply to make a column chart display values from largest to smallest, sorting its source data by the value column is generally easier to interpret than reversing the axis.

One common misconception is that a bar chart’s first row must always appear at the top. Its on-screen position depends on the axis direction and chart settings. If the sequence is correct in the worksheet but looks upside down in the chart, use the reverse-category option rather than moving rows unnecessarily.

PivotCharts and charts linked to tables

A PivotChart gets its categories and series from a PivotTable. In that case, sort the relevant labels or values in the PivotTable, or use the PivotTable’s sort controls, rather than expecting the regular chart data-selection dialog to control the entire arrangement. The PivotChart follows the PivotTable’s layout, and refreshing it can update the displayed categories based on its source.

Charts built from an Excel table usually respond when the table is sorted, while the table’s structured range can also expand as new rows are added. If a chart uses a fixed cell range rather than a table, newly added records may not be included automatically. Check the chart’s source range through Chart Design > Select Data if new categories do not appear.

For a one-off presentation, consider whether the chart should reflect the current worksheet order or a carefully chosen display order. Sorting a shared table changes how its records appear to other users, even though it does not change the underlying values. Reversing the chart axis changes only the chart’s display and may be the less disruptive choice.

Fix common ordering problems

The first category is at the bottom: Select the category axis and turn on Categories in reverse order.
The bars are not sorted by their lengths: Sort the source rows by the value column. Reversing the axis only flips the existing sequence; it does not rank values.
Labels no longer match the bars: Undo the change if possible, then sort the entire dataset together. Never sort only the values or only the category names.
The legend or stack is in the wrong order: Use Chart Design > Select Data to move the series, not the categories.
The value axis moved to the opposite side: Review the crossing-position options in Format Axis after reversing categories.
A new item is missing: Check whether the chart’s data range includes the new row. For a PivotChart, refresh the PivotTable or PivotChart and check its source.

Also check for blank rows, hidden data, or labels stored in an unexpected part of the chart range. Those can make a chart appear to skip or misorder a category. If the chart changes in an unexpected way after sorting, inspect the selected data range and confirm that each label remains paired with its corresponding values.

Excel for Mac and Excel for the web

In Excel for Mac, the main approach is the same: select the chart, use the chart design controls to select its data, or open the axis-formatting pane to change category direction. Ribbon names and the pane layout can vary slightly by release, so look for Chart Design, Select Data, and the axis options for reversing categories.

Excel for the web has chart editing and formatting controls, but the available options can differ from the Windows desktop app. If you cannot find the specific axis or series control you need, open the workbook in the desktop version of Excel. Sorting the source data remains an alternative when the chart is linked to that data and the sort does not disrupt other worksheet needs.

Frequently Asked Questions

How do I make the largest bar appear at the top in Excel?
Sort the chart’s complete source data by its value column from largest to smallest. If the bars are ranked correctly but the largest is at the bottom, select the category axis and turn on Categories in reverse order.

Can I change bar order without changing the worksheet?
Yes. Reversing the category axis flips the chart’s displayed category sequence without rearranging source rows. However, that setting only reverses the existing order; it does not sort categories by value.

Why does Excel put the first bar at the bottom?
Horizontal bar charts use a vertical category axis, and its direction may place the first source category at the bottom. Use Format Axis > Axis Options > Categories in reverse order to flip the display.

How do I reorder bars in a stacked bar chart?
If you mean the colored segments, select the chart and go to Chart Design > Select Data. Move the relevant series up or down under Legend Entries (Series). If you mean the categories down the side, sort the source data or reverse the category axis instead.

Does sorting a chart change the original data?
Sorting the worksheet changes the order in which records are displayed, but it does not change their values. Reversing the category axis changes only the chart’s display. If the worksheet order matters to other users, use axis reversal rather than sorting the shared source table.

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.