I am sorry I entered the last response for a different post that
addressed this same topic.

On Nov 4, 1:39*pm, "Jon Peltier"
wrote:
You could make a chart with 40 series, and see what you've got.

I guess what you want, though, is the color index values for the colors. If
you go to Tools menu Options Color, you see the palette, with a couple
rows at the bottom for charts. The 'Chart Fills' colors are color index
values 17 through 24, and the 'Chart Lines' colors are color index values 25
through 32. So if you make a line chart, the first eight series use color
index values 25 to 32. Then the index values increase to 33, 34, etc. When
they get to 56, the number of colors in the palette, they start counting
again at 1, 2, 3. It's not particularly easy to figure out which color index
values correspond to which tiles in the palette, because they are mostly not
in order.

You could select A1:A56, press Alt-F11 to open the VB Editor, press Ctrl+G
to open the Immediate window, copy the following line, paste it into this
window, put the cursor in the line, and press Enter. This will color A1 with
color index 1, A2 with color index 2, etc.

I blogged about colors in Excel charts:http://peltiertech.com/WordPress/200...s-in-excel-cha...

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

wrote in message

...



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.- Hide quoted text -

- Show quoted text -