XL97: Chart Truncated After Performing Paste Link Operation

ID: Q178181

The information in this article applies to:

• Microsoft Excel 97 for Windows
• Microsoft PowerPoint 97 for Windows
• Microsoft Word 97 for Windows

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:

1. In Microsoft Excel, click to activate the chart on the chart sheet.

2. 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:

1. In Microsoft Excel, click to activate the chart on the chart sheet.

2. On the Chart menu, click Location.

3. In the Chart Location dialog box, click As Object In.

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

STATUS

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

REFERENCES

For more information about charts, click the index tab in Microsoft Excel Help, and type the following text:

   charts,

Additional query words: XL97

Keywords          : kbinterop kbtool kbchart
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: November 1, 1998