View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Jon Peltier has code for resizing and moving charts:

http://www.peltiertech.com/Excel/Cha...oveAChart.html

and for pasting into Word:

http://www.peltiertech.com/Excel/XL_PPT.html


sub210 wrote:
I've created a number of histograms in Excel 97 and want to paste them into a
Word 97 document.
I'd like all the histograms to be/appear the same size in the document ie
the histograms and boxes around them.
At the moment, I'm manually trying to do this by dragging on the sizing
handles for each histogram and then seeing if they look the same.
Is there a way to do this automatically?
Many thanks.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html