Pasting EXCEL Charts into Word

[Markjsr]

I have pretty complex Word documents with a ton of Excel charts and tables
pasted into the document.

There are several options in the PASTE SPECIAL when pasting from EXCEL, but
I don't know the Pros/Cons of each. I've generally used Enhanced Metafile,
but tried pasting as JPG. The Enhanced Metafile seems to have better image
resolution, but I don't see any explanation of the benefits and shortcomings
of each of these PASTE alternatives.

Is there a way to use JPG where you can preserve the image clarity, and is
there a general document which describes the pros/cons of different formats?

 

[Keith Howell]

Hi Mark,

For what its worth I was told that jpeg uses some kind of pixel averaging
so you will tend to get a 'messy' edges on flat colour and line drawings such
as Excel graphs (better for pictures). I am told that gif format is better
for flat charts as its compression does something like calculating the number
of following equal pixels. If you have access to something like Photoshop
where you can change formats you can also compress to your hearts content
which will cut down the size of your doc.

I hope it helps

 

[Keith Howell]

Just a thought but you could paste your chart into a Powerpoint page and then
save it as a different format eg *.gif before loading it into you Word Doc.
Very laborious but might just give you what you want

 

[Markjsr]

The document I work with (a weekly newsletter I publish) has a LOT of EXCEL
charts and tables pasted. 40-50. For many of these, I have to execute a
query or refresh a pivot prior to cutting and pasting the document. So any
alternatives involving saving the image to disk or going through another
program would be WAY too labor intensive. I also don't want the document to
become larger. The Word documents already are in the 5M-6M range.

I've observed that when my Word document gets really large, I start getting
other weirdness going on (pages that suddenly don't want to print landscape
for example).

Thanks for the news about JPG, however. That seems to match my experience.