I have created Pie charts from the pivot tables in Excel and have selected
my own colours on the pie charts.

However, when I select Refresh Data from the pivot table menu, I loose all
my formatting.

This is VERY annoying but perhaps I have a certain option set and that's why
this happens. Anyone know how to keep the formatting of the charts from
being reset when a refresh is done?

Thanks in advance