Thread: Color Index
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Color Index

-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