Will this work for you?

ActiveChart.PlotArea.Width = ???
ActiveChart.PlotArea.Height = ???

Replace the ???s with whatever numbers you need.


Mark


Freddie Mac wrote:
I have a problem when using a macro to set size of a chart. I acnnot use the
macro recorder so I want to be able to set size in code. My code is:

Charts.Add
ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:="Standard"
.......
ActiveChart.Shapes.ChartArea.Height = 1000

As you may see the last line is faulty..I just dont know how to write it.
What I want to do is to set the size (height and width) in the code. If you
know how to solve this please help me.