Solved: Loop through charts
I'm pretty good in Excel VBA but this is my first foray into PowerPoint VBA and i'm getting stuck on simple object model stuff. Why did they get rid of the macro recorder??
I am trying to loop through the charts and change the chart type. I have my own chart template called (LEGO Column).
Here's the other rub. There will be different chart types and a template for each one. What I really need is a macro that will a) determine the chart type on the slide and then b) change it to the appropriate template. My guess is some kind of case select. A simple outline on how to do this is fine. I'm good enough in vba to adapt.
I would appreciate any help as i'm under a deadline.
You will have to use a proper chart object, instead of an OLE object. In this way, you will be able to change the chart type. i have included the solution.Hope that helps.
Last edited by raji2678; 02-22-2012 at 10:20 PM.
Originally Posted by raji2678