M
ML
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.
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.