Export charts produced in excel to specific PPT

[scruz9]

Hi All,

I created a macro that will produce 25+ graphs/charts (e.g. pie charts, line graphs, bar charts,etc.) and paste it to a specific 'Summary' tab within the excel spreadsheet.

I've spent some time searching on the internet and on this forum looking for my solution, but no luck. I want to export the graphs/charts that are produced by the macro and have them move to a specific powerpoint template. Certain graphs/charts on specific slides as well as positioned on a certain part of that slide.

I'd greatly appreciate if someone can help me with this.

Thanks in advance!

[scruz9]

So far this is the best VBA I could find; however, it still doesn't do everything I need.

Currently, this VBA will only transfer over a single selected chart at a time. I want to create a rule for each chart. So with Chart X it will go to Slide 4 (of a specific PowerPoint), positioned on this part of the screen including all of the charts formatting.

Please Login or Register  to view this content.

[scruz9]

I ended up putting the following together, please let me know if there is a better solution:

Please Login or Register  to view this content.

[dflak]

Take a look at the attached.