Hi

I have a large number of charts of the same size in excel, all on chart sheets. The pagesetup ! chart ! printed chart size ! property is set to custom, and I use a macro to set an identical chartarea height and width for each chart, so they have the same dimensions and proportions when pasted into Word or PowerPoint.

When pasting a chart from Excel into Word, I find that unless I paste as a picture, the original chart's size and proportions change to very large in excel. Furthermore, I'm unable to restore the chart area size to its original, and an attempt to do this with code (activechart.chartarea.height = ###) yields runtime error 1004 "unable to set height property of the chartarea class"

Any ideas on

a) why this happens, and
b) how I can restore my original chart to its proper size