I have a line graph that can have a variable number (currently 31) of lines in it, some of which will be same colour. The macro currently reads:
Sub InterestG1()
Sheets("InterestG").Activate
With ActiveChart
' 1 - 5
.SeriesCollection(1).Format.Line.ForeColor.RGB = RGB(192, 192, 192)...