Automatic Update of Excel Charts in PowerPoint

Hello Experts,

I have a PowerPoint template where I copy paste Charts from many different Excel files.

Is there a way to automate the update of the charts in PowerPoint to avoid the manual copying and pasting?

Thank you
fitalianoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Echo_SCommented:
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.
0
fitalianoAuthor Commented:
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.
0
Echo_SCommented:
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.
0
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Harry LeeCommented:
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?
0
fitalianoAuthor Commented:
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
0
Harry LeeCommented:
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.
0
fitalianoAuthor Commented:
Hi did you have a chance to look into this?
0
Harry LeeCommented:
Have you tried my above answer?

Here is the sample files.

You insert Object from file, and pick the excel file. Make sure you check the Link box.

Go the the tab you want to include in the slide, and it would work.
Q-28235809.pptx
Q-28235809.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fitalianoAuthor Commented:
Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.