XL5: Chart Legend Text Truncated Using Zoom Command

ID: Q111667

5.00 WINDOWS kbusage

The information in this article applies to:

SYMPTOMS

In Microsoft Excel, if you clear the Chart Sizes With Window Frame check box on the Chart tab of the Options dialog box, when you use the Zoom command, the text in your chart legend may be truncated at the edge of the legend.

CAUSE

This behavior occurs because the legend is scaled exactly with the window zoom factor, but the fonts are not. When you use the Zoom command, the legend text does not fit in the legend the way it does when you view the chart at 100 percent. The size of the legend scales with the window zoom factor instead of sizing to accommodate the legend text. This is most noticeable when you select a zoom magnification option of around 50 percent.

Note that this behavior only occurs when you view the chart. The chart text is printed correctly.

WORKAROUND

To avoid having your chart legend text appear truncated, do either of the following:

Note that the last workaround affects the way the chart is printed. Because this problem only affects the way the chart appears on the screen, the first workaround is the best.

MORE INFORMATION

When you select the Sizes With Window Command from the View menu, the size of the chart sheet depends on the size of the window. With this option selected, you cannot use the Zoom command to size the chart.

REFERENCES

For more information about Sizing A Chart Sheet With The Window, choose the Search button in Help and type:

   Sizing Chart Sheets

KBCategory: kbusage KBSubcategory:

Additional reference words: 5.00 truncated clip

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996