Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    12 Charts - 1 Slide! (XP)

    Hi,

    I have an excel spreadsheet with 12 Charts in it, each of which need to be displayed in a powerpoint slide.

    The first way I did this was to manually copy and paste each chart to the slide, but it is now evident that the presentation needs to be done monthly...

    I have found if I make a chart the front sheet in excel, and from within powerpoint do Insert | Object... and link to the Excel file, then I can have this chart in the slide and it is updated automatically, which is great. The thing is I need to be able to do this for 11 other charts!! There doesn't seem a way to specify the sheet number for the linked chart when I do Insert | Object, so other than creating 12 workbooks, each linked to the main one, and then using each of these 12 to be the source of the linked chart within powerpoint, I am not sure hwo to achieve my goal.

    Is it possible, through VBA or otherwise, to do what I want from the one excel spreadsheet containing all the charts?
    Thanks,

    pmatz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 12 Charts - 1 Slide! (XP)

    You can copy each chart in Excel, then use Edit | Paste Special..., Paste Link in PowerPoint.

    If you really want to include multiple charts on one slide, as the subject of your post seems to imply, you can arrange the charts on a worksheet in Excel, then select the area, copy it, and paste special as a link in PowerPoint.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 12 Charts - 1 Slide! (XP)

    Thanks, of course, Paste Special - Paste Link. I don't know why, but when I looked at that i must have thought of hyperlink <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15> ...

    Thats great anway, thanks for the tip about selecting and copying the area as a link [img]/forums/images/smilies/wink.gif[/img]
    Thanks,

    pmatz

Posting Permissions

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