Microsoft Office Tutorials and References
In Depth Information
Importing an Excel chart into MS Graph
3. Activate PowerPoint and select a slide.
4. Choose Edit
The Excel chart is copied to the slide, and everything appears perfect.
But wait! You may not realize it, but the preceding steps cause a copy of your
entire Excel workbook to be embedded in the PowerPoint presentation. If the chart
you’re copying happens to be contained in a 10-megabyte workbook file, all 10 of
those megabytes come along for the ride. Even worse, if you copy and paste
another chart from that workbook into your presentation, another copy of the
entire workbook is embedded!
To demonstrate that your entire workbook is embedded, double-click the pasted
chart in PowerPoint. This will activate the Excel workbook object and you can
examine it. You’ll also discover that if you pasted an embedded chart, it is
converted to a Chart sheet in the embedded workbook.
If you use Office XP, you may see a SmartTag at the lower-right corner when
you paste the chart into your PowerPoint slide. Click the SmartTag and you’ll
see the options shown in Figure 10-4. These options provide you with two
ways to paste: embed the entire workbook, or paste a picture of the chart.
Figure 10-4: In Office XP, a SmartTag lets you
choose how the Excel chart is pasted.
It’s important to understand that the Excel workbook that’s embedded in the
PowerPoint presentation is not linked to the original Excel workbook. It’s a
completely separate copy, stored inside your PowerPoint file. Consequently, if you
modify the chart in your workbook, those changes will not be reflected in the
PowerPoint slide. You can, however, double-click the Excel object in the
PowerPoint slide, and you can work with the Excel embedded object using all of