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