Knowledge Base

XL97: Chart in Worksheet Resized After Pasting into Word

Article ID: 172098

Article Last Modified on 10/22/2000

Microsoft Excel 97 Standard Edition

This article was previously published under Q172098

SYMPTOMS

If you copy a chart in a Microsoft Excel 97 worksheet, and then paste the chart into a Microsoft Word 97 document, the chart may change size in Excel.

CAUSE

This problem occurs if you set the Excel worksheet to a zoom level other than 100 percent (100%).

RESOLUTION

To restore the chart to the correct size, click the worksheet in Excel that contains the chart, or click the name of the worksheet on the Window menu.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

When you zoom a worksheet in Excel, the actual size of objects contained in the worksheet does not change; only the displayed size changes. Therefore, if you copy a chart contained in a zoomed worksheet and then paste the chart into Word, the pasted chart is displayed at the zoom level of Word. This behavior is by design.

For more information about problems copying charts in zoomed worksheets, please see the following article in the Microsoft Knowledge Base:

170760 XL97: Embedded Chart Changes Size When Copied and Pasted

Additional query words: XL97 WD97 clipboard zooms

Keywords: kbinterop kbchart kbprb KB172098