Edit

Share via

PlotArea.InsideHeight property (Excel)

  • Article

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 on 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.