Retain formatting for pivotchart on refresh

[machumpion]

I have a pivotchart based on a pivot table that regularly gets updated. Whenever I update the pivot table the chart updates also, but the original colors are changed.

Is there a way to retain formatting on pivot charts on refresh?

Thanks!!

 

[NBVC]

Does this help?

http://datapigtechnologies.com/blog...-pivot-table-formatting-stick/comment-page-1/

 

[machumpion]

unfortunately the tips in that link does not seem to retain formatting for pivotcharts

 

[NBVC]

How about?

http://peltiertech.com/pivot-chart-formatting-changes/

or

http://www.contextures.com/xlfaqPivot.html#ChartFormat