WD: Excel Chart Size Changes When Link Edited or Updated

Last reviewed: November 17, 1997
Article ID: Q41608
The information in this article applies to:
  • 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.


Additional query words: xl
Keywords : macword macword5 word6 kbinterop
Version : MACINTOSH:4.0,5.0,5.1,5.1a,6.0,6.0.1,6.0.1a
Platform : MACINTOSH
Issue type : kbinfo


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 17, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.