Pivot Table Charts

[Paul-Johnson]

Is there a way to preserve the formatting of a pivot table chart when refreshing data.

I am familiar with preserving the format for the PivotTable itself, but when I refresh the pivot table I lose all many of my settings in the pivot chart.

For example:
Chart type & Series formatting

Your help is appreciated.

 

[lenze]

No, not if you are refreshing from a query or other dynamic source. What I have done, is write a macro to reformat and place a button on the graph to execute it