Pivot Charts - refreshing clears my chart formatting

  • Thread starter Thread starter MP
  • Start date Start date
M

MP

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
 
Thanks for replying Andy.

I can't believe that the fix for this is to record a macro; figures. I was
expecting a fix from MS, not a bandaid.
 
Back
Top