title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
PlotArea.InsideTop property (Excel) |
vbaxl10.chm618089 |
|
|
33d609cd-8764-ef95-2864-10aee1e161b1 |
05/09/2019 |
medium |
Returns the distance from the chart edge to the inside top edge of the plot area, in points. Read/write Double.
expression.InsideTop
expression A variable that represents a PlotArea object.
The plot area used for this measurement doesn't include the axis labels. The Top 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 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]