Excel 2007 Chart.Export Poor Quality

[Tom]

Since moving to 2007 the quality of charts exported as GIF files is markedly
worse. JPG and PNG files both suffer same qulaity degradation.

Does anyone know how to use Chart.export to produce a WMF or EMF file?

Does anyone know how to get back the qulaity of files exported under 2003 in
2007?

this is the line of code I have been using that does the exporting in 2003
and produces poor results under 2007.

TempChartObject.Chart.Export FileName:=FileSaveName, Filtername:="GIF"

 

[Jon Peltier]

This is a known problem which has been reported since beta testing. I
honestly don't know what to do to improve the quality of exported charts,
either image files or shape objects pasted into another program (e.g.,
PowerPoint). I don't use 2007 for real work.

- Jon

 

[pninen]

I am experiencing the same fuzzy chart graphics generated from Excel 2007.

The charts coming out of Excel 2003 were wonderful. Now they're all spoiled.

The problem is some sort of anti-aliasing issue. The charts look good in Excel, but the .GIF files are junk. I believe this is due to sloppy arithmetic. This is exactly how a GIF chart looks in a web browser if you set the HTML to display it at the wrong size, like 1 pixel too small for example. I think Excel 2007 has rounding errors in their width and height calculations, and the fuzzy GIF is the result.

Quite a problem for me, as I use charts generated from Excel heavily.