Thread: Color Index
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Color Index

It is the black(ish) font colour, but presumably as it is called automatic
it can be changed, or MS have reserved the option to make it configurable.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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