JPG is a poor choice for an image comprised of discrete objects such as
a chart. The JPG format was designed to compress images like photographs
which have continuously varying shades and hues. PNG (or GIF) is a
better choice for line art like charts and screen shots.

In general PNG does a good job of reproducing what is shown on screen.

However, Excel 2007 does not give as nice results as its predecessors.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



theLuggage wrote:
Hi,

I have a chart I've created in Excel 2007 which includes a pie chart and
some tabular data that has been formated the way we want it on a regular
worksheet, then we copy it as a picture and paste that picture onto the
chartsheet next to the pie chart.

When I export the chart as a jpg, using this code:
ActiveChart.Export "C:\test.jpg", "JPG" true

The text in the tabular picture is getting screwed up. All the text gets
bolded and the text is bitmapped and jagged. It doesn't look like that in
the ChartSheet.

Any ideas?

I can send the Workbook so you can see what the Char t looks like, but I
don't see a way to attach it here.

Thanks in advance for your help.