InsideWidth Property

Microsoft Excel Visual Basic

Returns the inside width of the plot area, in points. Read-only Double.

Remarks

The plot area used for this measurement doesn’t include the axis labels. The Width 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