Excel Add-in: Export Chart Feature

Jon Peliter recently wrote about the differences and advantages between saving charts as .jpg or .png files.  To test Jon’s add-in and see the difference, I included two charts from my last post saved as .png and .jpg respectively.  The Excel add-in is amazing easy to use and is going to save me so much time from having to use an intermediate graphics program.

Click here to get Jon’s export chart add-in (scroll to the bottom of his post).

.PNG

.PNG

.JPG

.JPG 

Can you see a difference?

Related:

Excel 2007 Bible

Excel 2003 Bible

Most Commented Posts




6 Responses to “Excel Add-in: Export Chart Feature”

  1. Jon Peltier Says:

    Tony -

    I see slightly more fuzziness of the text and axis lines in the JPG, but I see more in the PNG than I’d suspect. If I didn’t know this was a taste test, I may not have thought much of the difference. What version of Excel are you using?

  2. Image File Type Comparison of Exported Charts » PTS Blog Says:

    [...] so much superior to JPGs for Excel charts. So he did a quick and dirty experiment, and reported in Excel Add-in: Export Chart Feature that there was not much [...]

  3. Jon Peltier Says:

    I’ve carried out my own test:
    http://peltiertech.com/WordPress/2008/06/12/image-file-type-comparison-of-exported-charts/

    Conclusion: It’s in the eye of the beholder. It also depends a lot on the version of Excel.

  4. DSA Says:

    Jon -
    I think the Excel 2007 .pgn format renders best from your experiment. I used Excel 2003 for this chart. The .jpg file is much larger if size is an issue. Thanks for the comment and post.

  5. Jon Peltier Says:

    I have to admit that I don’t care for the antialiasing. It doesn’t matter to me if I see the individual pixels that make up a drawn line, especially if that means I can ungroup the chart and work with its constituent shapes. This ability was broken in Excel 2007, and I’d rather get it back and not have the antialiasing.

    I guess I’m more of an engineer or technician than an artist.

  6. Excel Add-in: Export Chart Feature - Learn Excel Says:

    [...] Original post by DSA [...]

Leave a Reply

Subscribe without commenting