setting a chart size

[Guest]

How do you set a chart size? I tried

sub foo(
charts.ad
....
ActiveChart.ChartArea.Height = ..

end su

but this property is read-only

Thank

 

[Jon Peltier]

Julio -

The chart area of a chart sheet is read only, unless you go to the Page
Setup command on the File menu, click on the Chart tab, and choose the
Custom printed chart size.

The chart area of an embedded chart is always read only. You change its
size and position by resizing the parent chartobject:

ActiveChart.Parent.Height = ...

- Jon