How do I color all the series (lines) in a specific (selected/current) chart the same color?
I have the following, but it does nothing:
Sub Same_Color()
Dim Chart As Chart
Dim Series As Series
Set Chart = ActiveChart
Set Series = Chart.SeriesCollection(2)
Series.Format.Line.ForeColor.RGB = RGB(0, 255, 0)
End Sub