Pivot Table Charts

Paul-Johnson · Mar 21st, 2002, 07:39 AM

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 · Mar 21st, 2002, 08:19 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 07:39 AM	#1
Paul-Johnson New Member Join Date: Feb 2002 Posts: 47	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.

Mar 21st, 2002, 08:19 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	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