Copying a Chart as a Live Chart Linked to a Copy of the Original Workbook in Excel 2007:-

The problem with a straight copy and paste is that the PowerPoint slide and the original Excel workbook must remain on the same computer in order to maintain the link. If you plan on distributing the PowerPoint file to others, you can copy the chart along with the entire workbook.

To copy the chart, you follow these steps:

1. Open both PowerPoint and Excel.

2. In Excel, click the chart.

3. Press Ctrl+C or click the Copy icon on the Home ribbon.

4. Switch to PowerPoint by pressing Alt+Tab.

5. Paste by pressing Ctrl+V.

6. An icon appears at the lower-right corner of the pasted chart. Hover over the icon, and a drop-down arrow appears. Click the drop-down arrow. Choose Excel Chart (Entire Workbook), as shown in the Figure (given below).



(After pasting, you choose to embed the entire workbook.)

One advantage of this method is that you can send the PowerPoint presentation to any recipient whose computer has Office 2007. The recipient can right-click the chart, choose Edit, and see the entire Excel workbook. If that person makes changes to the assumptions in the workbook, the chart updates. The recipient also has full access to the Charting Tools ribbons in PowerPoint.

The main advantage of this method is also a disadvantage. Even though you paste a single chart, Office 2007 embeds the entire workbook. This can create privacy concerns if the workbook contains sensitive data on other worksheets or file size concerns if you have millions of cells on other worksheets in the workbook.