In this post I will share with you how to link an Excel chart to a PowerPoint presentation. This is helpful when you expect changes to be made to the Excel chart and you want to have your audience view those changes from in one of your PowerPoint slides.
- Right click the edge of the Excel chart and select copy.
2. Navigate to PowerPoint slide and select the Paste Special menu from the clipboard group.
3. Select Paste Link as Microsoft Excel Chart Object
4. Click File >Info and then click “Edit Links to Files” which is in the bottom right corner of PowerPoint 2010, 2013, and 2016 versions. Check box for “Automatic Update” in the Links box.
Note: It is important that the Excel file is saved to a location in which the PowerPoint can read the link otherwise the update cannot work. Typically you would save the Excel file with the chart to a network drive that is accessible to the file from which the PowerPoint is saved.
Click here to download my PowerPoint shortcuts.