Solved: Chart formatting with VBA

[leal72]

I am wanting to change the format of a data series. I have tried to record the macro to try and find the code I need that way but all that gets recorded is when I select the series. I do not want the effect the marker style, only change the line style from solid to dash

[Bob Phillips]

[vba]

With ActiveChart.SeriesCollection(1).Border
.ColorIndex = 57
.Weight = xlThin
.LineStyle = xlDash
End With
[/vba]

[leal72]

thanks again!