How to Copy a Chart from Excel into a Word Document?

There may be times when you want to present your Microsoft Office Excel chart that you created in Excel, in a Microsoft Office Word document. You can simply copy selected charts in Excel and then use the Paste or Paste Special commands in Word to insert the charts into a document.

Step by Step Tutorial - How to Copy a Chart from Excel into a Word Document?

Step 1. In Excel, select the embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.) or chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) that you want to copy to a Word document.

Step 2. On the Home tab, in the Clipboard group, click Copy

Keyboard shortcut You can also press CTRL+C.

Step 3. In the Word document, click where you want to paste the copied chart.

Step 4. On the Home tab, in the Clipboard group, click Paste.

Keyboard shortcut You can also press CTRL+V.

Step 5. Click Paste Options next to the chat, and then do one of the following:

• To paste the chart with a link to its source data, click Chart (linked to Excel data).
• To paste the chart and to include access to the entire workbook in the document, click Excel Chart (entire workbook).
• To paste the chart as a static picture, click Paste as Picture.
• To paste the chart in its original format, click Keep Source Formatting.
• To paste the chart and format it by using the document theme that is applied to the document, click Use Destination Theme.
  

Notes

*The Paste Options button is not available when you paste a chart in a document that is opened in Compatibility Mode in Word. In Compatibility Mode, the chart is pasted as a static picture.

Tips

• To paste a chart in another format, click the arrow on the Paste button, and then click Paste Special. In the As list, select the format that you want to use.
• To paste a chart as an embedded object (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.) that can be edited by using Excel, click Microsoft Office Excel Chart Object. To insert a file icon that you can click to open the chart, you can select Display as icon.
• To paste the chart as an Object Linking and Embedding (OLE) (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) Word application icon (rather than pasting the actual chart), click Microsoft Office Excel Chart Object, and then select the Display as icon check box. You can click the icon to open the application and then view the chart.
• To paste a chart as a static picture, click any Picture or Bitmap option. Picture format generally provides better display quality than Bitmap format.
• Click Microsoft Office Graphic Object to paste a chart as a graphic object that can be edited by using the chart tools in Word. To insert a file icon that you can click to open the chart, select Display as icon. Microsoft Office Graphic Object is not available when you are using Compatibility Mode in Word
• Click Paste link to paste a chart that is linked to the source data of the original Excel chart so that the pasted chart is updated when the source data changes. This option is not available when you are using Compatibility Mode in Word.
• You can also create a Microsoft Office Excel 2007 chart directly in Microsoft Office Word 2007 by clicking the Chart button on the Ribbon (Insert tab, Illustrations group), and then by using the chart tools to modify or format the chart. Charts that you create in Word will be embedded in the Word document, and their source data is stored in an Excel worksheet that is incorporated in the Word file. In Compatibility Mode, you can create a chart in Word by using Microsoft Graph.

Related Software Step by Step Guides and Tutorials: