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

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!


"baconcow" wrote:

> 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