Results 1 to 4 of 4
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Paste Chart as Picture in XL (XL97)

    Is there a way to PasteSpecial a chart object as a PICTURE directly in EXCEL? If so, HOW?

    I have only been able to make a copy of the excel chart object not a "picture" of it.

    I know of a couple "workarounds" (there are probably others), but nothing direct:

    If you copy a chart object in excel, you can open word (or powerpoint) pasteSpecial picture to get a "picture" of the chart in the OTHER program, then copy and paste this picture into excel, but there seems to be NO direct way to do this in excel.

    The other workaround is to use the camera to take a picture of the cells AROUND the chartobject on a worksheet page, and this gives a picture, but again not directly. (But at least you don't have to open up another program, but your chart has to be sized correctly to fit into the cells as desired).

    Am I missing something easy, or is this just one of the PITA things about excel?

    Steve

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Paste Chart as Picture in XL (XL97)

    Steve,
    I can't remember if this worked in 97, but in 2002, if you select the chart, press and hold Shift, then choose Edit from the menu, there's a Copy Picture option. Does this work in 97?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste Chart as Picture in XL (XL97)

    Works in 97 and I think even in XL5/95.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Paste Chart as Picture in XL (XL97)

    Yes simple. The VB property for macro code is to use:

    Activechart.CopyPicture

    which was ultimately where I wanted to go

    Thanks
    Steve

Posting Permissions

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