Using the default copy and paste for an Excel graph into PowerPoint results in a link back to the Excel file. If that file is on a drive you can’t access, you can’t edit the graph. If you use the Embed workbook option when pasting the graph into PowerPoint you make the PowerPoint file large, expose confidential information in other worksheets, and increasingly end up with a broken link due to problems in PowerPoint.
This video shows you a better option: Creating a PowerPoint graph using the data and formulas from Excel. Full editing, full functionality, and automatic updates to the graph when data is updated.
Dave Paradi has over twenty-two years of experience delivering customized training workshops to help business professionals improve their presentations. He has written ten books and over 600 articles on the topic of effective presentations and his ideas have appeared in publications around the world. His focus is on helping corporate professionals visually communicate the messages in their data so they don’t overwhelm and confuse executives. Dave is one of fewer than ten people in North America recognized by Microsoft with the Most Valuable Professional Award for his contributions to the Excel, PowerPoint, and Teams communities. His articles and videos on virtual presenting have been viewed over 4.8 million times and liked over 17,000 times on YouTube.