Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

PlotArea.InsideLeft Property (Excel)

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

expression .InsideLeft

expression A variable that represents a PlotArea object.

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.

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
© 2015 Microsoft