PlotArea.InsideHeight Property (Excel)
Returns the inside height of the plot area, in points. Read-write Double.
Syntax
expression .InsideHeight
expression A variable that represents a PlotArea object.
Remarks
The plot area used for this measurement doesn’t include the axis labels. The Height property for the plot area uses the bounding rectangle that includes the axis labels.
Example
This example draws a dotted rectangle around the inside of the plot area in Chart1.
With Charts("chart1")
Set pa = .PlotArea
With .Shapes.AddShape(msoShapeRectangle, _
pa.InsideLeft, pa.InsideTop, _
pa.InsideWidth, pa.InsideHeight)
.Fill.Transparency = 1
.Line.DashStyle = msoLineDashDot
End With
End With