XL97: Chart in Worksheet Resized After Pasting into Word

ID: Q172098

The information in this article applies to:

• Microsoft Excel 97 for Windows

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:

   ARTICLE-ID: Q170760
   TITLE     : XL97: Embedded Chart Changes Size When Copied and Pasted

Keywords          : kbinterop kbchart
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: November 1, 1998