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
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
Last Comment
ASKER
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?
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?
ASKER
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
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.
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.
ASKER
Hi did you have a chance to look into this?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.