How to Copy an Excel Chart to Word
You can use the "Paste Special" command in Microsoft Word 2007 to paste a copied Microsoft Excel 2007 chart into a word document. With this option you can create a linkable chart in Word that will update when the original Excel chart is changed. Follow the steps below to find out how you can copy an Excel chart to Word.
Things You'll Need
- Microsoft Excel 2007
- Microsoft Word 2007
Start Microsoft Excel 2007 and open a workbook from your files that contains a chart you want to copy into Word 2007.
Click to select the chart. The chart should now be surrounded by a light blue border. Right-click on the chart and choose "Copy" from the shortcut menu.
Start Microsoft Word 2007 and open an existing document that you would like to copy the Excel chart into or create a new, blank document for the chart.
Point and click to place the insertion point in the place in the document where you want to insert the Excel chart.
Choose the "Home" tab, if necessary, and click the "Paste" button from the "Clipboard" group to display a drop-down list of options. Choose "Paste Special" to open the "Paste Special" dialog box.
Select "Microsoft Office Excel Worksheet Object" from the "As" list to paste the chart that will continue to be updated if you change the original chart in Excel. Choose "Microsoft Office Graphic Object" from the "As" list to paste the chart as it is without leaving it to be updated in Excel in the future.
Use the "OK" button to close the "Paste Special" dialog box and insert the copied Excel chart into Word.