Excel: Using Color Tool Changes Weight of Graphic Lines

 Last reviewed: November 30, 1994
Article ID: Q93559
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a
  • Microsoft Excel for the Macintosh, version 4.0

SYMPTOMS

In version 4.0 of Microsoft Excel, when you use the Color tool to change the color of a graphic line or arrow, the weight (thickness) of the line or arrow may be changed as well; the weight of the line or arrow will revert to the default line weight when the color tool sets the color of the object to the first color in the color palette.

WORKAROUND

To work around this problem, reformat the line to the desired thickness.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in a later version of Microsoft Excel.

MORE INFORMATION

The Color tool changes the foreground color of a selected object or cell. When you choose the Color tool, it cycles through the sixteen colors currently assigned to the worksheet. When you cycle through the first color, Microsoft Excel resets the line format to Automatic which results in your line being reset to the default weight.

To reformat your line

  1. Select the line.

  2. From the Format menu, choose Patterns.

  3. In the Patterns dialog box, choose the Custom option and select the desired line color and weight.

  4. Choose the OK button.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 508-509 "Microsoft Excel Tools Quick Reference," version 4.0, page 8

KBCategory: kbprb
KBSubcategory:

Additional reference words: 4.00 palette

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 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.