I have a chart this is based on a Pivot Table. I go into the chart and
change the colours into something a bit brighter than the standatrd coulour,
but when I change the view ot the chart (i.e. from show all to just one piece
of data) when the chart refreshes the coulours go back to their original
values.

How can I make the colour changes I make stay when the chart is refreshed?