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

Share/Save/Bookmark

  • Support Analytics Consulting

  • DSA Insights Home
  • 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