chart area size vba

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kaonashi@gmail.com - 06 Sep 2006 15:36 GMT

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.

Reply to this Message

Andy Pope - 06 Sep 2006 15:57 GMT

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

> How can I set the chart size of an existing active/selected chart?
>
[quoted text clipped - 9 lines]
>
> Any help is appreciated.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message