Copy Chart from Excel to Word

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.
 
J

Jon Quixley

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Chart from Excel to Word using VBA 6
formattig word paragraphs from excel 5
writing excel data into word document 1
Copy chart from EXCEL into Word 1
Excel VBA - Easy way to paste chart to word document ? 6
XL Charts to Word 6
Saving a Word document as PDF from en Excel macro 2
Copy from Excel to Word 2

Top