Including Excel Charts in WinWord Documents

ID: Q41309

The information in this article applies to:

Microsoft Word for Windows, versions 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0, 6.0a, 6.0c
Microsoft Word for Windows 95, version 7.0

Use the following steps to perform a DDE link of an Excel chart in Microsoft Word for Windows

From the Chart menu in Excel, choose Select Chart.

From the Edit menu, choose Copy.

Switch to Word for Windows by pressing ALT+TAB.

Position the insertion point where you want to place the chart.

Word for Windows Versions 7.0, 6.0, 2.0

From the Edit menu, choose Paste Special.

In the Data Type list, select the desired format, then choose the Paste Link button.

Word for Windows Version 1.x

From the Edit menu, choose Paste Link.

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.

MORE INFORMATION

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:

Word for Windows Version 6.0


 Data Type       Field Inserted in Document
  ---------      --------------------------
  Picture        {LINK ExcelChart "Sheet1 Chart 1" "Chart" \a \p}
  Chart Object   {LINK ExcelChart "Sheet1 Chart 1" "Chart" \a}

Word for Windows Version 2.0


  Data Type      Field Inserted in Document
  ---------      --------------------------
  Picture        {LINK ExcelChart "Sheet1 Chart 1" \* mergeformat \p \a}
  Chart Object   {EMBED ExcelChart \s \* mergeformat}

Word for Windows Version 1.x


   Auto Update    Field Inserted in Document
   -----------    ----------------------------
   Selected       {ddeauto Excel "Sheet1 Chart 1" Chart \* mergeformat}
   Not selected   {dde Excel "Sheet1 Chart 1" Chart \* mergeformat}

Additional query words: 1.0 1.1 1.1a 2.0 1.x 7.0 word95 winword word6 6.0 winword2 word7

Keywords : kbfield
Version : WINDOWS:2.0,2.0a,2.0a-CD,2.0b,2.0c,6.0,6.0a,6.0c,7.0
Platform : WINDOWS
Issue type :