Embedding an Excel Chart in a Word DocumentMost of the time, Microsoft Office applications work fairly well together. For instance, Word allows you to embed a chart directly from Excel into a document. Here is how:
- Select the Excel chart you wish to embed in your Word document. (Make sure you select the entire chart, and not just a portion of it.)
- Press Ctrl+C to copy the chart to the Clipboard.
- Switch to the Word document.
- Position the insertion pointer where you want the chart placed.
- Display the Home tab of the ribbon.
- Click the down arrow under the Paste tool, and then choose Paste Special. Word displays the Paste Special dialog box. (See Figure 1.)
Figure 1. The Paste Special dialog box
- Select the Microsoft Excel Chart Object as the preferred method of pasting.
- Make sure the Paste Link radio button is selected.
- Click on OK. Word inserts the linked chart in your document.
#TipOfTheWeek