Consulting

Results 1 to 4 of 4

Thread: Solved: Loop through charts

  1. #1

    Solved: Loop through charts

    Hi,

    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.

    Thanks

    Jeff

    Attached Files Attached Files

  2. #2
    VBAX Regular
    Joined
    Feb 2012
    Posts
    36
    Location
    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.
    Attached Files Attached Files
    Last edited by raji2678; 02-22-2012 at 11:20 PM. Reason: Attachment

  3. #3
    Quote Originally Posted by raji2678
    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.
    Thanks!

  4. #4
    thank you brother

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •