Changing the Colour of a Line with VBA?

B

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
 
B

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Series Colour with VBA?? 5
change color of column chart 2
Margin from bottom edge of a page to the last line of the last paragraph 1
Setting the Colour of Individual Items within a Legend 6
Changing BackColor of ToggleButton produces a muddy grey color 5
Macro for changing the colors of objects based on user input 2
How to change the colour of a line 2
Excel 2007 VBA shape fill colour problem 0

Top