With DataPoint the user can create dynamic presentations where the user can have a list of products or ads in a database, Excel file, or text file. In other articles on this blog, we have already explained how the user can connect a text box or table to a database list of data. We will show how the user can enrich the data driven slides with images to accompany the texts.
Imagine for this dynamic presentation that we are working at a hospital and that we want to display the names and pictures of the doctors that are available today.
First set up a connection to the Excel file. Click DataPoint in the PowerPoint menu.
Link data to shapes
We can start to link information to our slide. Design the slide and add 3 text boxes to hold the doctor’s names. For each one of the text boxes select one and click DataPoint, Text box and set the column to Name and set the corresponding row to 1, 2 and 3 respectively. This will dynamically link the content of our Excel data to our PowerPoint text boxes.
To the left of the names we want to display the doctor’s picture. To start we insert a normal picture on our slide as we are used to do in PowerPoint. Click Insert, Pictures and browse to the folder containing the picture that the user wants to use for this presentation. As a default picture, we just use a question mark picture for now before we make it dynamic.
Select the first picture and click DataPoint, Picture. Now PowerPoint will suggest to change this static picture into a dynamic DataPoint picture for dynamic updating. Choose the Yes option here.
Set up dynamic slide show
Now we have dynamically linked the picture to our Excel data. We repeat this action for the doctors on data row 2 and 3 too. All the information remains the same as the first picture except here we increase the row.