Avatar of fitaliano
fitalianoFlag for United States of America asked on

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
Microsoft ExcelMicrosoft PowerPoint

Avatar of undefined
Last Comment
fitaliano

8/22/2022 - Mon
Echo_S

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.
ASKER
fitaliano

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.
Echo_S

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!
Walt Forbes
Harry Lee

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?
ASKER
fitaliano

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
Harry Lee

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
fitaliano

Hi did you have a chance to look into this?
ASKER CERTIFIED SOLUTION
Harry Lee

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
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
ASKER
fitaliano

Thank you