Microsoft KB Archive/115311

= 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 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 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.