chart area size vba

  • Thread starter Thread starter kaonashi
  • Start date Start date
K

kaonashi

How can I set the chart size of an existing active/selected chart?

I tried this withing a sub routine:

With ActiveChart.ChartArea
.Width = 5
.Height = 3
End With


And get the error message: Unable to Set the Width Property of the
ChartArea Class

Any help is appreciated.
 
Hi,

If the chart is on a worksheet this will work, although your chart will
be very small.

With ActiveChart.Parent
.Width = 5
.Height = 3
End With

Cheers
Andy
 
Back
Top