Copy Chart from Excel to Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using VBA, how do I copy an chart from Excel to a Word document?
I can already copy cells and place them at Word bookmarks.
 
Jonathan,

Select the chart by clicking on it (you will see the balck boxes appea
in each corner), Depress the SHIFT key and at the same time pull dow
EDIT/COPY PICTURE, select "As shown on screen" and "Bitmap". Open you
Word file and place the I-bar where you want the chart to paste, clic
once and go to EDIT/PASTE (or right click and do the same thing) - You
chart is pasted as a picture.
Pasting as a dynamic chart is slightly different - select the chart
EDIT/COPY, EDIT/PASTE SPECIAL select Paste as a Chart Object and toggl
the Paste button on.

Cheer
 
Back
Top