Microsoft Knowledge Base

XL: Only Legend Is Displayed in Chart Sample Area
Last reviewed: March 27, 1997
Article ID: Q115311
5.00 5.00c 7.00 7.00a | 5.00 5.00a WINDOWS | MACINTOSH kbusage

The information in this article applies to:

  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel, if you increase the size of a chart legend, the size of the legend is proportionately too large in the chart sample area in the User-Defined Autoformats dialog box, and the Format <charttype> Group dialog box. Additionally, if you increase the size of the legend to approximately one-fourth the size of the chart plot area, only the legend appears in the sample area in these dialog boxes.

CAUSE

This behavior occurs because a chart legend is not scaled with the chart plot area when you view a sample of the chart in the User-Defined Autoformats dialog box, or the Format <charttype> Group dialog box. Therefore, when you size a chart legend, the legend displays proportionately larger on the chart sample in these dialog boxes.

WORKAROUND

The only way you can avoid this behavior is by not scaling your chart legend. If you have scaled your chart legend, you can restore the legend to the default size with the following steps:

  1. Select the chart legend.

  2. From the Format menu, choose Selected Legend.

  3. Select the Placement tab, and under Type, select one of the placement options. Choose OK.

Note however that this behavior does not affect printing or viewing the chart in print preview.

REFERENCES

For more information about Adding A Custom Autoformat To the Formats List, choose the Search button in Help and type: 

   autoformats, custom
For An Overview Of Formatting Data Series And Chart Type Groups, choose the Search button in Help and type: 

    chart type groups

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 5.00a 5.00c 7.00 7.00a
Keywords : kbusage
Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0
Platform : MACINTOSH WINDOWS

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: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.