Automatic Update of Excel Charts in PowerPoint

Which version of PPT?

2010 look in File | Info, and if there are links to the Excel file, you'll see an option to "edit links to files" there. You can set them to update automatically there.

Or are you asking how to link them in the first place? As of PPT 2007, when you paste a chart from an Excel file, PPT automatically links to the data rather than embedding it the way it did in PPT 2003 and prior.

It's 2010. Links work well but I have text in the charts, so I would need an automated update to copy paste everything included in the text.

Oh, yeah, that's not something available in PPT. I mean, if the text changes in the Excel file and that's part of the chart (like the axis labels and chart titles and the like), that will update. But if it's manual textboxes you added in PPT, then those won't update.

fitaliano,

Which text do you mean? There maybe ways to do it. Can you upload a sample or capture a screenshot of what text you want automatically updates?

Hi HarryHYLee,

Please find attached the sample files. If I group and copy past the link option is not available. I think I would need some sot of vba
Book1.xlsx
Presentation1.pptx

If you really want the Text Box to be updated together with the Excel Chart, instead of pasting Link, you can considered inserting the Excel File as Object onto the Power Point Slide.

To manage the Chart and Text Box easier, you can consider grouping the Chart and Textbox together.

I'm currently on a work trip out of town and I only have Excel 2003 with me and cannot create a sample file for you at the moment. I'll get one done as soon as I get back in town tomorrow.

Hi did you have a chance to look into this?

Thank you