XL98: Unexpected Font or Color Formatting Applied to Chart

Last reviewed: February 2, 1998
Article ID: Q178504
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you use the Chart Wizard in Microsoft Excel 98 Macintosh Edition to create a new chart or to edit an existing chart, the chart may contain formatting you do not expect. For example, the chart may use a background color or fill that you did not specify, or labels in the chart may use a font you did not specify.

CAUSE

This problem occurs when either of the following conditions is true:

  • When you use the Chart Wizard, you do the following:

        1. In step 1 of the wizard, you click the Custom Types tab, click a
           custom chart type (for example, B&W Column or Blue Pie), and click
           Next.
    

        2. In step 2 of the wizard, you click Back.
    

        3. In step 1 of the wizard, you click the Standard Types tab and
           click a standard chart type.
    

        4. You then click Finish, or click Next and proceed through the
           the Chart Wizard.
    

    -or-

  • You click Custom Type as the default format for new charts and you click a Standard Type in the Chart Wizard when you create a new chart.

The problem occurs because Microsoft Excel fails to remove all of the formatting that is applied by the Custom Type format when you switch from a Custom Type to a Standard Type format.

WORKAROUND

To work around this problem, reset the chart to the default format. To do this, follow these steps:

  1. On the Chart menu, click Chart Type. Click the Standard Types tab.

  2. Click to select the Default Formatting check box. Then, click OK.

Note that you can also manually reformat parts of the chart by selecting them and pressing COMMAND+1.

To prevent this problem from occurring, do not click Next in step 1 of the wizard until you are sure that you have selected the correct chart format. The Custom Type formatting is not applied to the chart until you click Next.

NOTE: If you already proceeded to step 2 of the wizard, clicking Cancel prevents the changes from being applied to the chart.

You can also prevent this problem from occurring by setting the default chart type to a non-Custom Type.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

If you want to see what the chart will look like when you use the Chart Wizard to create or edit the chart, click the Standard Types tab in step 1 of the wizard, and then click "Press and hold to view sample."


Additional query words: XL98 chartwizard
Keywords : xlchart xlformat xlui
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug
Solution Type : kbworkaround


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