As you say only six basic colours are available. However each subsequent set
of six is a shade lighter, although each incremental difference in shade is
not very noticeable from the previous set.

One approach is to define at least as many colours in RGB format as you'll
need, then a simple macro can apply them in order to your series. Post back
if not sure how to go about that, and say how many colours you'll need.

Regards,
Peter T


"Lina" wrote in message
...
Hi!
I want to do a macro that sets the color for the chart series to the color
the company has desided to use. We have a theme but we can only set color
for
the first 6 series and we often use much more series.
I have understod that this isnt so easy as to loop thru the series and set
the color since the color is set on different ways depending on the
charttype
for the serie, or is it a way to do this so it works for all chart types?

thanks