Here's the best way to do what you want. Select the chart in Excel. Hold
Shift while selecting Copy Picture from the Edit menu (Shift changes Copy to
Copy Picture). Select the On Screen and Picture options. Switch to Word, and
do a normal paste.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"xppuser" wrote in message
...
hi all,
Office 2003 SP1, Windows XP Pro SP2,
i have created some charts in excel worksheets. what i want to do is to
copy
and paste the chart into my Word document. additionally, i want to paste
it
as a Windows Metafile picture not as MS Office Drawing Object or Picture
(Enhanced Metafile).
now, i seem to only be able to get (in Word) Edit - Paste Special -
Picture (Windows Metafile) option if i had selected (and copied) at least
two or more charts to be pasted in the Word document. had i only selected
a
single chart then the only option available to me is Edit - Paste
Special -
Picture (Enhanced Metafile) or MS Office Drawing Object. the problem with
having to copy multiple charts is i have then have to crop them in the
word
document.
can anyone explain to me why is the particular behaviour and whether there
is a work-around this? any advice, help and information is appreciated.
thank you,
jes