Border.LineStyle Property (Excel)

Returns or sets the line style for the border. Read/write XlLineStyle, xlGray25, xlGray50, xlGray75, or xlAutomatic.

expression .LineStyle

expression A variable that represents a Border object.

xlDouble and xlSlantDashDot do not apply to charts.

This example puts a border around the chart area and the plot area of Chart1.

With Charts("Chart1") 
 .ChartArea.Border.LineStyle = xlDashDot 
 With .PlotArea.Border 
 .LineStyle = xlDashDotDot 
 .Weight = xlThick 
 End With 
End With
© 2014 Microsoft