Share via

PlotArea.InsideLeft Property

  • Article
Excel Developer Reference

Returns the distance from the chart edge to the inside left edge of the plot area, in points. Read-only Double.

Syntax

expression.InsideLeft

expression   A variable that represents a PlotArea object.

Remarks

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

See Also