2002 excel microsoft training - VBA Pivot Chart Colours

Hello Zohra

Thank you for your question

The answer to your question is essentially yes.

You can alter the colour of a series simply by altering the colorIndex property of the series's interior

Typically, this might look something like:-

With Selection.Interior

        .ColorIndex = 3

End With

In terms of cycling through series, again this is simple enough. Individual series in a chart are series objects, and belong to the SeriesCollection. This means that it is possible to cycle through each series by using a "For Each Object in SeriesCollection" structure.
If you require further help, could you email a sample chart and worksheet as the details will depensd on the type of chart and data. If this is possible please email it to
infoATmicrosofttrainingDOTnet and mark it for the attention of stephen

Regards

Stephen