Minor Tick Marks Do Not Appear on Value Axis in Excel

 Last reviewed: November 3, 1994
Article ID: Q69209
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

SUMMARY

When you select the value axis and make a change to the Minor Unit box under the Scale command of the Format menu, the changes do not appear to have any effect on the appearance of charts.

MORE INFORMATION

As a default, Microsoft Excel sets the Tick Mark Type for Minor Units under the Patterns command of the Format menu to Invisible if you are using Microsoft Excel version 2.1, and to None if you are using Microsoft Excel version 3.0 or 4.0. When a change is made to the Minor Unit under the Scale command of the Format menu, the change does not appear on the chart because of this formatting.

To show the tick marks on the chart, choose Patterns from the Format menu and set the Minor Tick Mark Type to either Inside, Outside, or Cross.

REFERENCES

"User's Guide 1," version 4.0, pages 469-471 "Microsoft Excel User's Guide," version 3.0, pages 463-468 "Microsoft Excel for Windows Reference Guide," version 2.1, pages 336-338

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.1 2.10 3.0 3.00 4.0 4.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 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.