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.

Visual Basic for Applications
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
find out inside height plot area chart height area inside chart not including axis labels Inside inside height Inside Height Property InsideHeight insideheight property return inside height

See also: