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
_______
