Article ID: 178181
Article Last Modified on 1/22/2007
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft PowerPoint 97 Standard Edition
- Microsoft Word 97 Standard Edition
This article was previously published under Q178181
SYMPTOMS
After you link to a Microsoft Excel chart in Microsoft Word or Microsoft
PowerPoint, the chart may be truncated.
CAUSE
This problem occurs when the following conditions are true:
- You copy an Excel chart sheet.
-and-
- You switch to Word or PowerPoint.
-and-
- You click Paste Special on the Edit menu and click Paste Link in the
Paste Special dialog box.
-and-
- You are running Microsoft Windows NT version 3.51 or Window NT version
4.0.
WORKAROUND
To work around this problem use one of the following methods before you
copy the chart.
Method 1: Select Sized with Window
To use this method, follow these steps:
- In Microsoft Excel, click to activate the chart on the chart sheet.
- On the View menu, click Sized With Window.
Method 2: Move the Chart to a Worksheet as a Chart Object
To use this method, follow these steps:
- In Microsoft Excel, click to activate the chart on the chart sheet.
- On the Chart menu, click Location.
- In the Chart Location dialog box, click As Object In.
- In the box to the right of As Object In, select the worksheet in which
you want to insert the chart, and then click OK.
After you use one of these methods, the chart is not truncated when you use
the Paste Link command.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
This problem no longer occurs in Microsoft Excel 2000.
REFERENCES
For more information about charts, click the index tab in Microsoft Excel
Help, and type the following text:
and then double-click the selected text to go to the "charts" topic.
Additional query words: XL97
Keywords: kbbug kbchart kbinterop KB178181