View Single Post
  #2   Report Post  
Posted to microsoft.public.word.vba.general,microsoft.public.excel.charting
Hari Hari is offline
external usenet poster
 
Posts: 46
Default Pasting charts to Word from Excel as picture

Hi,

I have some more queries.

My colleague has pasted the charts (manually) from excel to PPT as
picture. When I do rightclick on these charts then :-

a) There is a circular green handle on top centre of the object (along
with 8 white circles on corner and rest centres)

b) If I select format picture from right click then Layout tab has the
option "In front of text" for wrapping style. Consequently, the
advanced button in layout tab has further options available for the
Picture position tab.

On the other hand, when I paste charts from excel to Word (whether
manually or through code) then, the pasted chart has these properties
when I right click on it:-

a) There is NO green handle, rather clicking gives me 8 black square
handles.

b) If I select format picture from right click then Layout tab has the
option "In line with text for wrapping style. Consequently, the
advanced button in layout tab has NO further options available for the
Picture position tab.

My question is how do I ensure that when I paste chart from excel to
word (using code) then it gets pasted as "In front of text" wrapping
style option.

Regards,
HP
India