copy graphs from excel

[lennert]

hi,

ok i tried several times but no luck so far.

I generated several pivot graphs in excel. I want to put them into MS
word. I tried copy. But then excel overflows, probably because it also
copies the underlying data. I just want to copy the graphs into word
without waiting for a very long time and the memory of my computer
floating over. Is there any way?

thanxs in advance

cheers len

 

[Ed]

If you select your area to copy in Excel and hold the Shift button, the Edit
menu will have the Copy as Picture command available. In Word, you can then
simply Paste (CTRL+V), and it will paste in a scaleable, non-editable
graphic of your chart or table.

HTH
Ed

 

[michael.amon1]

Alternately, you could select the graph in Excel, go to Word, select
Edit - Paste Special - then select Picture.

A more complex method which works across different platforms quite well
(Mac and PC, as well as other programs) involves copying the graph from
Excel (Ctrl C), then paste into a PowerPoint presentation (Ctrl V).
Then simply "Save As" and select .jpg file. This will save the graph
as a jpeg and then you can go back to Word, select "Insert", "Picture",
"From File", and then navigate to the jpg of the graph. This method is
guaranteed to work, and if you e-mail the doc to someone else, they
will be able to open it without problems. I have to do this regularly
when writing papers, it's a little more work, but depending on your
audience, well worth the effort.

Good luck!
Mike