Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

PlotArea.InsideWidth Property (Excel)

Published: July 16, 2012

Returns the inside width of the plot area, in points. Read-write Double.

expression .InsideWidth

expression A variable that represents a PlotArea object.

The plot area used for this measurement doesn’t include the axis labels. The Width 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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.