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

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

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

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

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

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

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

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

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