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