If the graphs you want to use in your Power Point presentation will change regularly, it can be a hassle to create them from scratch every time there is an update to the data.
It is likely that the data used to create the graph is coming from an Excel worksheet, so why not link the graph on the slide directly to the Excel data. I will describe each method, and then show a table that summarizes the differences.
This article shows you the step by step procedure for importing linked data from an Excel spreadsheet into a Power Point slide (works in Power Point 2003, 2007, 2010, 2013, 2016).
If you want to learn about the three approaches to using Excel data in Power Point and the different methods for each approach, check out my After the Analysis e-course.
Type = mso Embedded OLEObject Then Set g Chart = s. I have been looking forever to find an answer to this and finally managed to get it to work with a ton of reading and trial-and-error.
I’ll end with some recommendations of when each method should be used.
Each method starts with you creating the graph in Excel first, because we will be copying the graph created in Excel into the Power Point slide.
Step 1: Create the table in Excel The first step is to create the table of data in Excel so that it looks exactly the way you will want it to look on the slide, including titles, row labels, column labels, gridlines, text and background colors and text formatting.
Step 2: Copy the table in Excel Using your mouse or arrow keys, highlight the table of data in Excel. The slide layout with a title only is usually a good choice if the imported table will be the main focus of the slide.