setting a chart size

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top