Hi guys,

I am trying to create a macro to re-colour a selection of pie charts with
standard colours. They all have a different number of points but I want the
same colour sequence for each chart.
For example:
ActiveChart.SeriesCollection(1).Points(1).Interior .ColorIndex = 55
ActiveChart.SeriesCollection(1).Points(2).Interior .ColorIndex = 47 etc...
However, I don't know how to do it for the variable number of points.

Any suggestions?

Thanks.