chart area size vba

[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.

 

[Andy Pope]

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