Saylor URL: http://www.saylor.org/books
When creating a link to an Excel chart in Word or PowerPoint, you must keep the Excel workbook in its
original location on your computer or network. If you move or delete the Excel workbook, you will get an
error message when you try to update the link in your Word or PowerPoint file. You will also get an error
if the Excel workbook is saved on a network drive that your computer cannot access. These errors occur
because the link to the Excel workbook has been severed. Therefore, if you know in advance that you will
be using a USB drive to pull up your documents or presentation, move the Excel workbook to your USB
drive before you establish the link in your Word or PowerPoint file.
Skill Refresher: Pasting a Linked Chart Image into PowerPoint
Activate an Excel chart and click the Copy button in the Home tab of the Ribbon.
Click in the PowerPoint slide where the Excel chart will be pasted.
Click the down arrow of the Paste button in the Home tab of the Ribbon.
Click the Keep Source Formatting & Link Data option from the drop-down list.
Click the Refresh Data button in the Design tab of the Ribbon to ensure any changes in the Excel file
are reflected in the chart.
KEY TA KEAWAY S
When pasting an image of an Excel chart into a Word document or PowerPoint file, use the Picture option
from the Paste drop-down list of options.
When creating a link to a chart in Word or PowerPoint, you must refresh the data if you make any
changes in the Excel workbook.
When pasting an image of an Excel chart into a Word document, which of the following commands
would you use?
Click the Paste button in the Home tab of the Ribbon.
Click the down arrow below the Paste button in the Home tab of the Ribbon, and select the
Picture option from the drop-down list.