Results 1 to 10 of 10
  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    653
    Thanks
    93
    Thanked 14 Times in 13 Posts

    Export a pie chart? (XP)

    I would like to be able to open an Excel pie chart in Photoshop and do some work on it. I cannot find any export options in Excel.
    I did find this in the Help files:

    "You can publish a chart with or without interactivity. When you publish without interactivity, an image of the chart in a picture format (.jpg) is saved and displayed on the Web page."

    But no clue on how to do it.

    Any info or any other ideas?
    Thanks

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

    Re: Export a pie chart? (XP)

    You should be able to copy a chart to the clipboard in Excel (select it, then press Ctrl+C), and paste it into PhotoShop.

    (The publish option is for web pages, not for FotoShop)

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export a pie chart? (XP)

    Select the chart. Now, hold down the shift key and click on the Edit menu. Holding down the shift key should add a "Copy Picture" option to the Edit menu. Use that to copy the chart and then go to Photoshop and paste the picture.
    Legare Coleman

  4. #4
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    653
    Thanks
    93
    Thanked 14 Times in 13 Posts

    Re: Export a pie chart? (XP)

    OK thanks -I did that and it works!

    But when I print it from Photoshop the image seems very low resolution, showing jagged lines and characters throughout. This may be something I need to address in Photoshop, but I thought I'd check with you to see if you have any more ideas.

  5. #5
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    653
    Thanks
    93
    Thanked 14 Times in 13 Posts

    Re: Export a pie chart? (XP)

    Doing it that way (actually 3 different options are available in that method) makes it a little smaller so jaggies are not as obvious, but they are still there.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export a pie chart? (XP)

    Did you use the "As shown when printed" option? That might make it look a little better.
    Legare Coleman

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

    Re: Export a pie chart? (XP)

    I don't have PhotoShop, so I don't know what would be the best way; let's hope that someone else has a good suggestion.

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Export a pie chart? (XP)

    For some mysterious reason there is no option under the File or Chart menus to create an exported image of a Chart image. Try the following VBA one liner which will export the image in GIF format. By changing th eFiltername to "jpg", a jpeg file can be exported. Change the filename extension also.<pre> Sub ChartToGif()
    ActiveChart.Export Filename:="Filename.gif", FilterName:="gif"
    End Sub</pre>

    Andrew C

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export a pie chart? (XP)

    John Walkenbach has a Chart Tools Add In available on his website that allows export ti TIF, GIF, Jpeg, or PNG file format. I have not made use of this feature yet, so cannot vouch for how well it will work for your application, but it's something you may want to look into.

  10. #10
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    653
    Thanks
    93
    Thanked 14 Times in 13 Posts

    Re: Export a pie chart? (XP)

    Now I am wondering if the problem is the resolution in the Photoshop file I am pasting into. It was only 72 dpi, I raised it to 300 dpi and pasted the image, but now the image looks very small. I will keep at it and let you know if I resolve it.

Posting Permissions

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