In article , ?B?
UGF1bCBHcmF5c29u?= <Paul says...
I have created an Excel Pivot chart and formatted the Data Label and other
formating options on the chart but when I refresh the pivot I lose all my
formatting on the chart.

How can I refresh the pivot chart data without losing all my formatting on
the Pivot Chart?

Thanks

Paul

A PivotChart loses some (most?) of its formatting on a refresh. Search
support.microsoft.com for 'pivotchart refresh' (w/o the quotes) for several
articles including one titled 'Changing a PivotChart removes series
formatting in Excel'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions