When you insert a horizontal bar chart in PowerPoint, the first row in your data table may appear at the very bottom of the chart by default. To reverse the order in a PowerPoint bar chart, simply select the category axis and check the Categories in reverse order box in the Axis Options panel.
In this guide, you will learn how to adjust axis order without altering your data source, control the orientation of horizontal and vertical axes, and manage the plotting order of data series.
Why bar charts display categories in reverse order
When a bar chart is created in PowerPoint, the data is stored and processed in an underlying Excel worksheet. As explained in the Microsoft Official Support Documentation, categories in bar charts typically appear in the opposite direction of what users initially expect. The first category in the top row of the data table (for example, Category 1) is plotted at the very bottom of the chart's vertical axis.
Some users try to resolve this by entering the data directly in reverse order in the table (for example, starting from the fourth quarter instead of the first quarter). However, if chart axes are visible, reversing the plotting order directly using axis formatting options instead of manually entering data backwards is the officially supported and far more practical approach.
Prerequisites and preparation
Before modifying the order setting, ensure that your chart meets the following conditions:
- Chart type: In bar charts, categories are placed along the vertical axis as a rule, while values are placed along the horizontal axis.
- Axis visibility: The chart must display its axes in order to change the plotting order via the axis.
- Version support: The function to reverse plotting order is provided within the Format Axis options across Microsoft 365 and PowerPoint Desktop Versions (PowerPoint 2016, 2019, 2021, 2024, and Microsoft 365).
When your chart is selected on the slide, the Chart Design and Format tabs become active on the ribbon.
Step-by-step: Reversing the vertical axis order
To reverse the category order in a PowerPoint bar chart, follow these official steps:
- Click on the bar chart on your slide to select it.
- Identify the axis you want to edit. In a bar chart, categories are located on the vertical axis. You can click directly on the axis or switch to the Format tab that appears on the top ribbon.
- In the Current Selection group on the Format tab, open the arrow next to the Chart Elements box and select the relevant axis from the list.
- Click the Format Selection command, also located in the Current Selection group.
- In the panel that opens, check the Categories in reverse order box under the Axis Options category.
When this checkbox is selected, the category in the top row of the table moves to the very top of the chart, and the order is reversed. Similarly, if you want to configure numerical axis intervals, you can also consult the steps on adjusting the scale in a PowerPoint bar chart.
Verifying horizontal and vertical axis settings
When you reverse the axis order, it is recommended to observe the overall chart layout and verify the following details:
- Category vs. value distinction: The category axis setting is used to list categories in reverse order. If you select the value axis and check the Values in reverse order box, the numerical direction in which the bars extend will reverse (for example, from right to left instead of left to right).
- Visual check of intersection points: When categories are reversed, the visual position of the horizontal axis displaying values may change. Review the axis options in your version of PowerPoint to visually confirm that axis labels and lines remain appropriately positioned for your slide design.
- Radar chart exception: According to Microsoft support documentation, the plotting order of values cannot be reversed in radar charts; however, this limitation does not apply to standard bar charts.
Changing data series order and row/column layout
If your chart contains more than one series or you want to alter the distribution of data across series, two additional methods are outlined in official resources:
- Changing the order of data series: After selecting the chart, open the Select Data Source dialog box. In the Legend Entries (Series) box, select the data series whose order you wish to change. Then use the Move Up or Move Down arrows to position the series as desired.
- Changing row and column layout: To change how your data is emphasized in the chart, you can use the Switch Row/Column command on the Chart Design tab. This command is only available when the chart's underlying Excel data table is open and for supported chart types.
Worked example: Annual project phases slide
To see how this works in practice, let us set up a project chart using hypothetical values:
Sample Data Table (Hypothetical Values):
- Phase 1: Planning - 10 days
- Phase 2: Development - 25 days
- Phase 3: Testing - 15 days
- Phase 4: Go-Live - 5 days
When the chart is first inserted, the Phase 1 bar from the top row of the Excel table appears at the base of the chart, while Phase 4 appears at the very top. When the audience is expected to read the project chronologically from top to bottom, this layout can cause confusion.
Execution:
Select the chart, identify the category axis from the Chart Elements list on the Format tab, and click Format Selection. In the Axis Options section, check the Categories in reverse order box. As a result, Phase 1 moves to the top of the chart, and Phase 4 moves to the bottom. For schedule-based presentation setups, you can also explore the steps for creating a Gantt chart in PowerPoint.
Potential errors and troubleshooting
If you encounter unexpected behavior during the process, perform the following checks:
- Axis cannot be clicked with the mouse: The chart title, legends, or data labels may be covering the axis. Instead of clicking with the mouse, go to the Format tab on the ribbon, manually select the axis from the dropdown list in the Current Selection group, and click the Format Selection button.
- Bars extend in the reverse direction: The horizontal value axis may have been selected by mistake instead of the category axis, with the Values in reverse order box checked. In this case, the bars will be plotted in reverse direction. Select the horizontal axis, uncheck this box, and reverse the order on the category axis only.
- Switch Row/Column button is inactive: This button is only enabled when the underlying Excel data table for the chart is open. Recheck the Chart Design tab after opening the data table.
Final checklist
Review the following items before finalizing your presentation:
- Is the category in the first row of your data table positioned where you want it on the chart (for example, at the top)?
- Was the correct axis reversed (categories or numerical values)?
- Are the start and end directions on the numerical value axis aligned as expected?
- If using a multi-series chart, has the legend order of the series been verified in the Select Data Source panel?
Frequently Asked Questions
Does writing rows in reverse order in Excel produce the same result?
Yes, entering data into the Excel table starting from the last category can make the first category appear at the top of the bar chart. However, as noted in Microsoft documentation, if the chart has visible axes, using the Categories in reverse order setting in axis options is the direct and practical way to change the order without disrupting the source data structure.
Can the order also be reversed in vertical column charts?
Yes. The ability to reverse the plotting order is not limited to horizontal bar charts. Because the category axis in column charts is located horizontally, selecting the horizontal axis and checking Categories in reverse order will reverse the left-to-right plotting order of the columns.
← Back to blog
