Skip to content

Latest commit

 

History

History
50 lines (32 loc) · 1.17 KB

Excel.PlotArea.InsideLeft.md

File metadata and controls

50 lines (32 loc) · 1.17 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PlotArea.InsideLeft property (Excel)
vbaxl10.chm618088
vbaxl10.chm618088
Excel.PlotArea.InsideLeft
193934e2-c3ca-c3cf-fb90-2dd45e17f9b8
05/09/2019
medium

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.

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

[!includeSupport and feedback]