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