Hi Matt,

I don't quite follow what you want to do, as you have not had an answer yet
same may apply to others. Some background info -

Excel "automatically" applies colours for Series sequentially from the 2nd
last row of the palette for "fillable" type charts (bars, areas etc,
ColorIndex 17 on), or from the bottom row for line types (ColorIndex 25 on).
If you have more than 16 or 8 series, further colours are applied from
ColorIndex 33 scattered in the top 5 rows of the palette.

If you only have one Series and you check "vary colors by point" (Format
data Options) colors are applied as above.

You can customize your chart colours in your palette manually (Tools
Options colors) or programatically.

Instead of customizing you could apply any colour from the palette to Series
and/or individual points (if you re-colour a series you will lose previous
individually coloured points). If you often want the same colours go for the
customizing approach and let Excel apply your colours consistently.

A customized palette is unique to your workbook. You could store this as a
template, copy palette from one wb to another in Options / Colours. Or store
some (say 16 or 8 chart colours) or the entire 56 palette colours as numbers
in a column of cells in a convenient place. This would require some simple
code first to store then to customize the current wb with these colours.

You may easily be able to achieve what you want manually. Otherwise the code
things above are simple, post back if necessary.

Regards,
Peter


"Matt" wrote in message
...
I am using MapPoint and want to change each color code property to my
prefered color and not a variety of dark to light shades. MapPoint allows
only certain combinations of colors to be used. I want to be able to
select
each color one by one such as yellow, dark blue, dark green, etc. Is
there a
way to code this in Excel or MapPoint? i think code is the only way to
change each color individually.

Thanks,
Matt