PasteGraphics is a tool for exporting charts and tables from Excel into Word or PowerPoint as either a graphic or as the respective object (chart/table). In this way, PasteGraphics can copy the selected chart or table and paste it where the cursor is placed in Word or into the selected placeholder in PowerPoint.
This article will elaborate on two examples of usage. The first one illustrates how a chart can be exported as a graphic from Excel into Word, while the second demonstrates how a chart can be imported as an object to PowerPoint.
Export as graphic
When a chart is finished and ready to be exported, the chart concerned must be selected. At the same time, the Word document where the chart is being exported into must be opened to be able to receive the chart.
Now, click "Export to Word" and select "Export as Graphic".
The chart are now copied from the Excel sheet and pasted as an image where the cursor is placed in Word.
When the graphic is selected, two buttons appear next to it. The first one enables the user to see the source of the graphic, while the second updates the graphic.
Imagine that the Word document is to be opened later and maybe by other users. Thus, it will be beneficial for to ensure that users are able to see the source of the graphic concerned.
This button opens a dialogue where the file name of the sheet wherein the graphic originally was created is shown as the source. Here, the user is able to rename the source.
If changes in the source are made after the chart/table has been pasted into Word or PowerPoint, Office will automatically update the inserted chart/table if it is inserted as an object. Thus, the second button allows users to update if the object is inserted as a graphic.
Let's say that the data of the chart above has been changed, we must update the graphic in the document to ensure that it corresponds to the source.
Now, the graphic will be updated according to the source.
Import as object
Besides being able to export from Excel as above, the chart/table can also be imported in Word or PowerPoint. This section exemplifies how a chart can be imported in PowerPoint. To do so, both Excel and PowerPoint must be opened. Further, the placeholder that should receive the chart must be selected, while the chart concerned also must be selected in Excel.
Now, click "Import from Excel" and select "Import as Chart/Table".
This will import the selected chart from Excel to the selected placeholder in PowerPoint.