Exporting graphs to Word

K

kippers

Hi,

When I select a sheet full of embedded graphs in excel then try and copy and
paste special into Word, it seems to crop half of the graphs off even though
I have the papwer set at A3 landscape in both programs, am selecting the
whole graphs and have checked the page breaks in Excel. I've tried paste
special in all formats and the only one that works is Bitmap (but graphs come
out too small).

Anyone got any ideas?

cheers!,

R
 
J

John McCabe

Word does not like graphs from Excel. Had to get 3 or 4 on a Word page. 20
minutes to do the graphs in Excel. LONG time playing in Word to get all on
a page. Word tends to cover part of the graphs there. Have to shrink them,
move around, basically play with them.
PS - checked with our IT people, cannot do that many on a Word page is the
answer. Problem was I was doing it, looking for easy way. Never got it.
 
J

Jon Peltier

How do you want to arrange the charts? Do they have to be dynamically linked
to the Excel source?

Your IT guy isn't imaginative enough, or doesn't smoke enough weed. Here's a
protocol which works in Classic Office and in very limited preliminary tests
also works in Office 2007.

Step 1 - If the charts are to be arranged in a grid in Word, create a table
with the appropriate number of columns and rows.

Step 2 - If the charts do not need to be live Excel charts.

Step 2A - Embed the charts in a worksheet, and make the charts in Excel the
same size as they have to be in Word.

Step 2B - Copy each chart as a pictures Select the chart, go to Paste on the
Home tab, Paste Special (yeah, real intuitive, isn't it?), Copy Picture.*

Step 2C - Click in the table cell in Word, and Paste.

* Experiment with the Copy format to see which you like best. In 2003 the
Picture format was best (not Bitmap), but in 2007 they are equally
unattractive.

Step 3 - If the charts have to be live Excel charts.

Step 3A - Use chart sheets. Copy each chart sheet into a new workbook. If
you want it to be linked to the original workbook data, this is enough. If
you want it to stand apart from the original workbook, copy the sheet with
the data at the same time, so the new workbook has a data sheet and a chart
sheet, and the chart links to this data.

Step 3B - Make the chart sheet chart the same size as the chart has to be in
Word, by adjusting Page Setup margins.

Step 3C - With the chart sheet active, save and close this new workbook.

Step 3D - Click in the table cell in Word, and use Insert tab > Text group
(intuitive again) > Object > Create From File, then browse to the workbook
you just saved.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 

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

Top