chart area size vba
 

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.

chart area size vba
 

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

wrote:
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, Microsoft MVP - Excel
http://www.andypope.info