Accessing a different line in Excel graph

[mellen]

Currently, I have a line graph with two lines. Line 1 is green and I don't need to change anything. Line 2 is black and I gotta change it to a thin blue line.
How do I get access to it?
I thought I could just change the index of series collection to (2) but it gives me an error.
ActiveChart.SeriesCollection(1).Select

Below is my code for my subroutine.

Sub EAChangeColorGasStorage()
'
' EAChangeColorGasStorage Macro
' November 10, 1999. Change color to pink
'
' Keyboard Shortcut: Ctrl+Shift+E
'
ActiveWindow.Visible = False
Windows("New Storage Graph.xls&quot.Activate
Range("G32&quot.Select
Sheets("New Charts&quot.Select
ActiveSheet.ChartObjects("Chart 5&quot.Activate
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.ColorIndex = 10
.Weight = xlThin
.LineStyle = xlContinuous
End With
Selection.Shadow = False

With Selection
.Fill.Visible = True
.Fill.ForeColor.SchemeColor = 10
.Fill.BackColor.SchemeColor = 10
End With

ActiveWindow.Visible = False
Windows("New Storage Graph.xls&quot.Activate
Range("G37&quot.Select
End Sub

 

[RobBroekhuis]

Your code should work. You don't actually have to select the series - try:

with ActiveChart.SeriesCollection(2).border
.ColorIndex = 10
.Weight = xlThin
.LineStyle = xlContinuous
End With

Where are you getting the error? After selecting the chart, in the immediate window, do some debugging, such as
?activechart.seriescollection.count
to see how many series Excel recognizes on the chart.

Rob