Great thanks, Gord and JLatham. I think both of your methods will help. And
through recording Macro, I found the macro to set the default colors for
chart lines is as follows,

ActiveWorkbook.Colors(25) = RGB(0, 0, 0)
ActiveWorkbook.Colors(26) = RGB(0, 0, 255)
ActiveWorkbook.Colors(27) = RGB(255, 0, 0)
...

thanks again for both of your kind help.

Regards,

Leonard

"Gord Dibben" wrote:

If just for one workbook, you could modify the default chart colors in
ToolsOptionsColor under Chart Fills and Chart Lines.


Gord Dibben MS Excel MVP

On Mon, 30 Jun 2008 02:34:00 -0700, Leonard Lan wrote:

I am using VBA to create a set of line charts. The default line colors
include yellow or other light colors, which should be avoided. Is there a
method to change the default colors? Glad if anyone could give me a hand.