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

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

In addition to Tushar's advice, you may be able to preserve some of the
changes.

If you apply data labels by choosing ChartChart Options, the labels
will stick when the chart is refreshed. If you select an individual
series and apply data labels, they'll disappear when you refresh the chart.

If you change the colour of a series, it will revert to the default
colour when the chart is refreshed. Instead, if other charts won't be
negatively impacted, you could change the default colours for charts:
Choose ToolsOptions
On the Color tab, select a Chart fill or Chart line colour
Click the Modify button, and select a different colour.


Paul Grayson wrote:
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?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html