PlotArea.InsideTop property (Word)
Returns or sets the distance, in points, from the chart edge to the inside top edge of the plot area. Read/write Double.
expression A variable that represents a 'PlotArea' object.
The plot area used for this measurement does not include the axis labels. The Top property for the plot area uses the bounding rectangle that includes the axis labels.
The following example draws a dotted rectangle around the inside of the plot area for the first chart in the active document.
With ActiveDocument.InlineShapes(1) If .HasChart Then With .Chart 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 End If End With
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.