I am looking to find what the auto color scheme is in an Excel chart.
Basically, when you select a range of data for a chart it
automatically selects a color for each line in a line graph. I, for
the sake of formatting and conditional formatting, need to know what
that order is for the first 40 colors.

I am currently using Excel 2003.

Thank you.

Default colors for Chart Fill and Chart Lines are found in
ToolsOptionsColor

There are not 40 colors for these.........8 only for each.

The order is as shown.

Can be modified but the number cannot be increased.

I don't understand the second half of the question about why you need to
know the order.


Gord Dibben MS Excel MVP

On Tue, 4 Nov 2008 06:57:21 -0800 (PST), wrote:

I am looking to find what the auto color scheme is in an Excel chart.
Basically, when you select a range of data for a chart it
automatically selects a color for each line in a line graph. I, for
the sake of formatting and conditional formatting, need to know what
that order is for the first 40 colors.

I am currently using Excel 2003.

Thank you.