Color vs Colorindex for series border

[HC Hamaker]

Running on Excel 2003, I am attempting to set the .border.color property for
an x-y scatter series object using a long value that was generated by the RGB
function. However, the colorindex property seems to override it. I can
successfully change the marker colors, but the .border.color value reverts
back to the one associated with the colorindex value. I don't want to change
the palette because I have several charts in the workbook, each of which has
its own color scheme based on the number of series in the chart. Anyone know
why I can't just set the color property to an arbitrary value?

 

[Jim Cone]

There are only 56 colors available as determined by the color palette.
If you specify a custom color, Excel uses a color from the palette that
is close to the custom color.
Actually, in the default palette, there are 46 unique colors plus 10 duplicates.
You could change one of the duplicates to your custom color and use its
ColorIndex for your border color.
The duplicate indexes are ...
5 to 9, 11, 13, 14, 18, 20, 25 to 32, 34, 54
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(color sort, compare, unique, thesaurus and other add-ins)



"HC Hamaker"
<HC (e-mail address removed)>
wrote in message
Running on Excel 2003, I am attempting to set the .border.color property for
an x-y scatter series object using a long value that was generated by the RGB
function. However, the colorindex property seems to override it. I can
successfully change the marker colors, but the .border.color value reverts
back to the one associated with the colorindex value. I don't want to change
the palette because I have several charts in the workbook, each of which has
its own color scheme based on the number of series in the chart. Anyone know
why I can't just set the color property to an arbitrary value?