ID: Q41309
The information in this article applies to:
Use the following steps to perform a DDE link of an Excel chart in Microsoft Word for Windows
1. From the Chart menu in Excel, choose Select Chart.
2. From the Edit menu, choose Copy.
3. Switch to Word for Windows by pressing ALT+TAB.
4. Position the insertion point where you want to place the chart.
5. From the Edit menu, choose Paste Special.
6. In the Data Type list, select the desired format, then choose the
Paste Link button.
5. From the Edit menu, choose Paste Link.
6. In the Paste Link dialog box, select the Auto Update option if you
want Word to automatically update the chart whenever it is changed in
Excel. If Auto Update is not selected, it is necessary to select the
chart and recalculate it (by pressing F9) for new charts to appear.
After you place the chart in the Word document, you can scale or crop it.
If you use the above procedure, Word inserts one of the following fields into the document:
Data Type Field Inserted in Document
--------- --------------------------
Picture {LINK ExcelChart "Sheet1 Chart 1" "Chart" \a \p}
Chart Object {LINK ExcelChart "Sheet1 Chart 1" "Chart" \a}
Data Type Field Inserted in Document
--------- --------------------------
Picture {LINK ExcelChart "Sheet1 Chart 1" \* mergeformat \p \a}
Chart Object {EMBED ExcelChart \s \* mergeformat}
Auto Update Field Inserted in Document
----------- ----------------------------
Selected {ddeauto Excel "Sheet1 Chart 1" Chart \* mergeformat}
Not selected {dde Excel "Sheet1 Chart 1" Chart \* mergeformat}
Keywords : kbfield
Version : 1.x 2.x 6.0 6.0a 6.0c 7.0
Platform : WINDOWSLast Reviewed: July 31, 1997