Microsoft Office Tutorials and References
In Depth Information
Pasting Charts into Other Documents
One more way to include objects from one workbook in another Office document is to
copy the object you want to share and then paste it into its new location. You can copy
Excel charts to Word documents and PowerPoint presentations 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 current appearance of the chart to another document
without creating a link back to the chart, you right-click the chart and click Copy on the
shortcut menu that appears to copy the chart to the Microsoft Office Clipboard. Then, in
the document into which you want to paste the chart’s image, on the Home tab of the
ribbon, in the Clipboard group, click the Paste button’s arrow to display the palette of
paste options available. The last option on the right, Picture, pastes an image of the
chart in its current state.
In this exercise, you’ll copy a chart containing sales information to the Clipboard and
paste an image of the chart into a PowerPoint presentation.
Important You must have PowerPoint installed on your computer to complete this exercise.
SET UP You need the RevenueChart_start workbook and the RevenueSummary_start
presentation located in your Chapter13 practice file folder to complete this exercise.
Open the RevenueChart_start workbook and save it as RevenueChart . Then open the
RevenueSummary_start presentation and save it as RevenueSummary . Then follow
1. In the RevenueChart workbook, right-click the chart, and then click Copy .
Excel copies the chart to the Clipboard.
2. Display the RevenueSummary presentation, which contains a single, blank slide.
3. Right-click a blank spot in the visible slide, and then, in the Paste Options area of
the shortcut menu, click the Picture icon.
The chart appears as a static image.