Hi Bill,

In a typical chart, Excel automatically applies colours to fill'able type
series "same as" the colours in the 6th row of the palette (not shown in the
dropdown palette). From colorindex 17 in the order the series were added,
typically the order the series were added.

Eg, the xlAutomatic (-4105) fill colour for the third series will be "same
as" colorindex 19.

Depending on the chart, or what you have done to the chart, this rule may
not always apply. Eg, try deleting series #2 of #3, then add a new series.

Regards.
Peter T


n "Bill" wrote in message
ink.net...
Thanks, but I want to know the color that is represented by the
xlColorIndexAutomatic. How do I do that?


"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
-4105 is the constant represented by xlColorIndexAutomatic. If you want
the color to be blue try to set it specifically.

--

Vasant


"Bill" wrote in message
ink.net...
Hello,
I have a bar chart is made and then updated. For some reason, when
updating, the color changes from blue to purple. When I ask what the
color index is for the bar, prior to updating, I get -4105. Not the
color index I would expect for blue. I used:

Activechart.seriescollection(1).interior.colorinde x

Any ideas on what is happening? Is the -4105 some default setting?

Thanks,

Bill