I have a macro that creats chart. Now I want to be able to set the size of
the plot area exactly. The code I am using is:

With ActiveChart
.PlotArea.Width = 10000
.PlotArea.Height = 10000
...............
End With

However this does not seem to work. I dont know if it is only the relative
size between height and width that can be set this way or..How do you set the
size of the plot area (recording a marco is not useful for me since it does
not give exact size). Do you have to set the size of the whole chart first?
If so how? Please assist me if you have any idea!

Hi,

The plotarea is restrained by the chartarea. The chart will not increase
in size to accommodate the plotarea, you will need to check and modify
the chartarea size first.

Cheers
Andy

Nick London wrote:
I have a macro that creats chart. Now I want to be able to set the size of
the plot area exactly. The code I am using is:

With ActiveChart
.PlotArea.Width = 10000
.PlotArea.Height = 10000
..............
End With

However this does not seem to work. I dont know if it is only the relative
size between height and width that can be set this way or..How do you set the
size of the plot area (recording a marco is not useful for me since it does
not give exact size). Do you have to set the size of the whole chart first?
If so how? Please assist me if you have any idea!


--

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