Changing the Colour of a Line with VBA?
 

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

Changing the Colour of a Line with VBA?
 

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