Microsoft Excel Webinar

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
      To view attachments your post count must be 0 or greater. Your post count is 0 momentarily.

  2. #2
    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
      To view attachments your post count must be 0 or greater. Your post count is 0 momentarily.
    Last edited by raji2678; 02-22-2012 at 10: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

Posting Permissions

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