Excel: Reversing the Order of Values on an Axis

 Last reviewed: November 2, 1994
Article ID: Q24333

SUMMARY

The values displayed on an axis in Microsoft Excel can be reversed. For example, if the value axis displays 0 at the bottom and 10 at the top, the values can be reversed to display 10 at the bottom and 0 at the top.

To reverse the order of values on an axis, do the following:

  1. Click on the axis to be reordered. Two white squares will appear at each end of the axis to indicate that it is selected.

  2. From the Format menu, choose Scale if you are using Excel version 3.00 or 2.20. If you are using Excel version 1.50 or earlier, choose Axis from the Format menu.

  3. Select the check box labeled "Values in Reverse Order".

KBCategory: kbother
KBSubcategory:

Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.