Pasting Charts into Other Documents

A final way to include objects from one workbook in another workbook is to copy the object you want to share and then paste it into its new location. Copying Excel 2007 charts to Word 2007 documents and PowerPoint 2007 presentations enables you to reuse your data without inserting a worksheet into the file and re-creating your chart in that new location.

When you want to copy the image of the chart in its current form to another document, you just right-click the chart, click Copy from the shortcut menu that appears, and then paste the image into the other document. After the other Microsoft Office system program completes the paste operation, it displays the Paste Options button. Clicking the Paste Options button enables you to choose whether to paste the chart as a chart that remains linked to the worksheet that provides its data, to paste the entire workbook, or to paste an image of the chart in its current state.