Do you make many PowerPoint presentations throughout the year that include graphs and charts created in Excel? If you answered yes, keep reading to learn how to save yourself some precious time.

The layout of each slide is very important in order to properly brand your presentation in the mind of your viewers, and it takes time to get the layout just right. Once you get the layout how you like it, there is a really simple way to automate your PowerPoint to refresh data from Excel. It has saved me many hours of copy/paste and resizing/aligning elements on slides.

To start, you need to create an Excel file with your raw data as well as graphs. I recommend arranging the “raw data” section in a way you can easily copy and paste new data in the future. Once you have your Excel file all set up (and saved), open a new PowerPoint presentation and SAVE IT to your computer.

Now for the big reveal:

  • Copy a graph in Excel
  • In PowerPoint, click on the Home Tab – Paste Arrow

paste-in-ppt

  • Select Paste Special
  • Select the Paste Link Option

paste-link

Done!

Now let’s watch the magic in action.

Save both files again.

Close PowerPoint.

Change elements of your raw data and save.

Open PowerPoint and click Update Links when prompted. (Don’t be afraid!)

update-links-ppt

Your graph is automatically updated to reflect the new data.

wow

Leave a Comment

Kaelee Heuschkel
Kaelee Heuschkel joined 3Q Digital in October 2012. She has a bachelor's degree in Business Administration from the University of Colorado at Boulder with an emphasis in Marketing. Kaelee is passionate about digital advertising, and her professional background consists of pharmaceutical advertising, SEO, and SEM. In her free time, Kaelee enjoys taking Pilates classes, running, skiing back home in the Rocky Mountains, and most of all exploring Chicago.