PlotArea.InsideHeight Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns the inside height of the plot area, in points. Read-write Double.

expression .InsideHeight

expression A variable that represents a PlotArea object.

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.

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