Microsoft KB Archive/191022

= XL98: How to Reverse the Axis on a Bar Chart =

Article ID: 191022

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q191022





SUMMARY
When you create a bar chart with the ChartWizard, the category labels are arranged from bottom (the first label) to top (the last label) instead of from top to bottom as expected. This order of arrangement occurs because labels are plotted from the zero reference point (usually the lower-left corner of the 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.

Additional query words: XL98

Keywords: kbhowto kbchart KB191022

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.