MVP #26: Copying Charts from Excel to PowerPoint and Making Them Update Automatically

, , No Comments
Ever needed to make a PowerPoint presentation with charts/graphs already in Excel? And also have the PowerPoint one automatically update whenever you change the values for the charts in Excel?

Today's your lucky day. I'll show how to do just that.

Here is my Excel chart of all the houses in Lagos by regions: Ikeja, Lagos Island, Victoria Island...


I'll like to have this in a PowerPoint Slide. And just the chart.
To make the chart more visual friendly, I'll do some slight formatting.

And here's my better formatted one. I added a Data Table.



Now, I'll put this in a PowerPoint Slide.

Here's my PPT, already made ready.





I intend to put the chart in the 2nd slide.
So I copy the chart and paste it in the 2nd slide. Just at the lower right corner of the pasted chart, I see a CTRL icon. I click on it. It gives me extra paste options. I choose the Keep Sourc Formatting & Link Data.





And that's all. You can do this for any chart.

So let's do some testing testing.

Here's my final chart.



I'll go make some changes in the Excel chart table.

From:



To:



Let's see if the PowerPoint Slide chart changed.



Voila! It updated itself.

And that's how to make dynamic charts in PowerPoint, that will update directly from Excel.

0 comments:

Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.

Thanks!