| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Chart from Excel to Word
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 Allen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Chart from Excel to Word
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 -- Jon Quixle ----------------------------------------------------------------------- Jon Quixley's Profile: http://www.excelforum.com/member.php...fo&userid=2580 View this thread: http://www.excelforum.com/showthread.php?threadid=56532 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy an Excel chart into Word does not look the same | Excel Worksheet Functions | |||
| Copy chart from Excel to Word | Charts and Charting in Excel | |||
| How do I copy paste from excel to word without getting a chart | Excel Discussion (Misc queries) | |||
| copy an excel chart to word | Charts and Charting in Excel | |||
| How do I copy a table from Excel to Word or a chart to Ppt in a ma | Excel Programming | |||
Hybrid Mode
