Changing the Colour of a Line with VBA?

[baconcow]

Another thing I have just been stumped by is how to change the colour of the
main line with visual basic. I figured out how to change the marker fill
colour. I know how to use the RGB( x, y, z) command, but I do not know what
comes before this.

The equivalent:

Format Axis -> Line Color -> Solid Line -> RGB( x, y, z)

Thanks again

 

[baconcow]

I found the answer from one of Jon Peltier older archived post. This is the
code I ended up using.

ch111.SeriesCollection(1).Border.Color = RGB(31, 73, 125) 'dark blue, text 2

Thanks for the help Jon!