XL98: 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 steps to flip the chart from top to bottom:

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.

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.