VBA: Formatting a series line in chart

[Will_B]

In VBA, how do I access the line object of a chart's SeriesCollection? Excel's Help frightens me with "There’s no object that represents a single series line...". My immediate need is to make Series1 and Series2 be dotted lines (xlDot) for a great number of charts. Hence my desire for a VBA solution. I thought it might be something like:

myChart.SeriesCollection(1).Format.Line = xlDot
myChart.SeriesCollection(2).Format.Line = xlDot

Is there a solution?

 

[Sal Paradise]

myChart.SeriesCollection(1).Border.LineStyle = xlDot
myChart.SeriesCollection(2).Border.LineStyle = xlDot

I believe (try recording macros to see how to make things change -- I selected my chart and changed series 1 and 2 to dot, and got this code):

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/11/2009 by ------
'

'
    ActiveChart.SeriesCollection(1).Select
    With Selection.Border
        .ColorIndex = 57
        .Weight = xlThin
        .LineStyle = xlDot
    End With
    With Selection
        .MarkerBackgroundColorIndex = xlAutomatic
        .MarkerForegroundColorIndex = xlAutomatic
        .MarkerStyle = xlAutomatic
        .Smooth = False
        .MarkerSize = 5
        .Shadow = False
    End With
    ActiveChart.SeriesCollection(2).Select
    With Selection.Border
        .ColorIndex = 57
        .Weight = xlThin
        .LineStyle = xlDot
    End With
    With Selection
        .MarkerBackgroundColorIndex = xlAutomatic
        .MarkerForegroundColorIndex = xlAutomatic
        .MarkerStyle = xlAutomatic
        .Smooth = False
        .MarkerSize = 5
        .Shadow = False
    End With
End Sub

 

[Will_B]

Thanks, Sal. However, I can't get this to work in my code just yet, but at least now I get no error message. I'll post the solution once I get my code working. Thanks!

 

[Sal Paradise]

Try recording a macro to do what you want, and see what the results are. It may have different syntax depending on graph type.