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?

This is a known bug that required vba code to re-apply formatting.

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904

Cheers
Andy

Keith wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info