How to Reverse the Axis on a Bar Chart

MORE INFORMATION

To place the first label on the top of the chart, use the following appropriate steps to flip the chart from top to bottom:

Microsoft Excel 97

1. Click the bar chart to select it.
2. Double-click the category axis (vertical axis) to display the Format Axis dialog box.
3. Click the Scale tab, and click the Categories In Reverse Order check box.

Microsoft Excel 5.0 and 7.0

1. Double-click the bar chart to select it.
2. Double-click Axis 2 (vertical axis) to display the Format Axis dialog box.
3. Click the Scale tab, and click the Categories In Reverse Order check box.

NOTE: This option changes both the displayed order of the categories on the y-axis and the location of the x-axis labels from the bottom of the chart to the top of the chart.

To retain the x-axis labels at the bottom of the chart in the above example, click the Value (Y) Axis Crosses At Maximum Category check box.