setting a chart size
 

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

setting a chart size
 

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______


julio wrote:

How do you set a chart size? I tried

sub foo()
charts.add
.....
ActiveChart.ChartArea.Height = ...

end sub

but this property is read-only.

Thanks