WD: Excel Chart Size Changes When Link Edited or Updated

• Microsoft Word for the Macintosh versions 4.0, 5.0, 5.1, 5.1a, 6.0, 6.0.1, 6.0.1a

SYMPTOMS

In Microsoft Word for the Macintosh, when you use the Update Link or Edit Link command to update a Microsoft Excel chart, the chart may change size.

CAUSE

In the update process, Excel modifies the chart to use the As Shown On Screen option. Word has no control over this behavior in Excel.

NOTE: Under System 7.0, Excel (versions 3.0 and later) and Word (versions 5.0 and later) communicate with each other using object linking and embedding (OLE).

WORKAROUND

To work around this problem, follow these steps:

1. In Excel, double-click the chart to put it in its own window.

2. On the Chart menu, click Select Chart.

3. Hold the SHIFT key down and click Copy Picture on the Edit menu.

4. Click As Shown On Screen for both the appearance and size options.

5. Switch to Word and click Paste Special on the Edit menu.

6. Click Paste Link to link the chart to Excel.