Border.LineStyle Property

  • Article
Excel Developer Reference

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

Syntax

expression.LineStyle

expression   A variable that represents a Border object.

Remarks

xlDouble and xlSlantDashDot do not apply to charts.

Example

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

Visual Basic for Applications 
  With Charts("Chart1")
    .ChartArea.Border.LineStyle = xlDashDot
    With .PlotArea.Border
        .LineStyle = xlDashDotDot
        .Weight = xlThick
    End With
End With

See Also