How to Reverse the Axis on a Bar Chart

This article was previously published under Q141103
This article has been archived. It is offered "as is" and will no longer be updated.
  • Microsoft Excel for Windows 5.0c|5.0c
  • Microsoft Excel for Windows 95 7.0a|7.0a
  • Microsoft Excel for Windows NT 5.0|5.0
  • Microsoft Excel for the Macintosh 5.0|5.0
  • Microsoft Excel for the Macintosh 5.0a|5.0a
SUMMARY
When you create a bar chart with the ChartWizard, the category labels arearranged from bottom (the first label) to top (the last label) instead offrom top to bottom as expected. This order of arrangement occurs becauselabels are plotted from the zero reference point (usually the lower-leftcorner of the chart).
MORE INFORMATION
To place the first label on the top of the chart, use the followingappropriate 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 onthe y-axis and the location of the x-axis labels from the bottom of thechart to the top of the chart.

To retain the x-axis labels at the bottom of the chart in the aboveexample, click the Value (Y) Axis Crosses At Maximum Category check box.
XL5 XL7 97 5.0 XL97 XL
Properties

Article ID: 141103 - Last Review: 12/04/2015 12:36:09 - Revision: 1.3

Microsoft Excel 97 Standard Edition, Microsoft Excel 95 Standard Edition, Microsoft Excel 5.0 Standard Edition

  • kbnosurvey kbarchive kbinfo kbualink97 KB141103
Feedback