asked on

Macro that copies charts from a worksheet in excel to different slides in PowerPoint (MAC 2011)

I have a number of charts on a worksheet, i want to create a macro that copies each of the charts into a separate slide in a already existing powerpoint. If this macro is able to open the presentation and copy over these charts, that would be ideal. I am currently working with a MAC on Excel for Mac 2011.

ASKER CERTIFIED SOLUTION

Jamie Garroch (MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

AckeemK

ASKER

Hi Jamie,

To be more specific, I am looking to update the charts in the existing powerpoint presentation which I attached. The charts within this presentation are the charts within the 'Charts of SR' tab in the Excel file. The user will adjust the charts based on the data and pivot tables and would click "Create Presentation" to open this presentation and have the charts in the PowerPoint match the ones in their carelog. The charts in the PowerPoint start from slide 14 through slide 23. I've tried copying and pasting special of the charts as "Microsoft Excel Chart Object" but not sure how to write the code for linking these. Essentially it should go "Open SRs by Month", and then "Closed SRs by Month" and so on within the PowerPoint basically following how it is shown as you scroll down the 'Charts of SRs' tab within the excel file.
DSE-Carelog-Report-V1.xlsm
DSE-Carelog-Slidedeck-Quarterly-Business

Jamie Garroch (MVP)

That's a completely different question AckeemK. Could you accept the solution above to the original question which was "Macro that copies charts from a worksheet in excel to different slides in PowerPoint (MAC 2011)" and open a new question regarding linking and updating charts?

AckeemK

ASKER

I apologize for that but I've asked this question multiple times and have not received no answer. It is currently open still and can be found here:

https://www.experts-exchange.com/questions/28664971/Macro-to-open-presentation-and-update-charts.html

Jamie Garroch (MVP)

OK - thanks - I'll take a look tomorrow as it's a bit late in the UK now.