View Single Post
  #4   Report Post  
John Mansfield
 
Posts: n/a
Default

Radixa,

I don't quite understand your request. If your looking for the plot height
and width, this macro will extract it:

Sub PlotSize()
ActiveChart.PlotArea.Select
MsgBox "Plot Height: " & Selection.Height & _
" Plot Width: " & Selection.Width
End Sub

If you're looking for the maximum and minimum for the X and Y axis, the X
and Y axis labels should tell you that.

Maybe you can post back if this doesn't work.

----
Regards,
John Mansfield
http://www.pdbook.com


"Radixa" wrote:

Hi all,

I want to get the max value for the Y and X axes on a plotArea, not the max
values for series on this chart.

Is it possible with VBA ?

TIA
Rad