| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Index
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color Index
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color Index
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color Index
If you change your setting for the window font color in the windows (not
excel) settings, it changes the color in the cells that are set for xlautomatic - so it isn't necessarily the black(ish) font color. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color Index
That is the '... presumably it can be changed ... ' that I mentioned.
-- HTH RP (remove nothere from the email address if mailing direct) "Tom Ogilvy" wrote in message ... If you change your setting for the window font color in the windows (not excel) settings, it changes the color in the cells that are set for xlautomatic - so it isn't necessarily the black(ish) font color. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color Index
Typo
From colorindex 17 in the order the series were added, typically the order the series were added. would make more sense written as: From colorindex 17 in the order the series were added, typically series index + 16 Peter T 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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color Index
Now you don't have to presume.
-- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... That is the '... presumably it can be changed ... ' that I mentioned. -- HTH RP (remove nothere from the email address if mailing direct) "Tom Ogilvy" wrote in message ... If you change your setting for the window font color in the windows (not excel) settings, it changes the color in the cells that are set for xlautomatic - so it isn't necessarily the black(ish) font color. -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Color/Color Index | Excel Discussion (Misc queries) | |||
| Chart axes color index vs font color index | Charts and Charting in Excel | |||
| color index | Excel Programming | |||
| Color Index | Excel Programming | |||
| Color index values | Excel Programming | |||
![Bill[_30_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
