Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Automatic Update of Excel Charts in PowerPoint
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?
8/22/2022 - Mon
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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
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?
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
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.
to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Hi did you have a chance to look into this?
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent