Fixing the colour of a data series in a chart

[Grizlore]

Hi

Is there a way to fix the colour of a data series in a chart? (Excel 2007)

The colours keep changing whenever I change the format, chart style, of apply a filter (if using a pivot chart)



Any ideas?


Regards