Chart Format generated from a Pivot Table Data

[Victor]

After I Format a Chart generated from a Pivot table Data, and I change a
selection, for example "Plant".. Al the information on the chart changes,
according to the new plant selection, but, why the Chart Type and the format
also changes too... I need to keep the same chart type and format to keep
reviewing the information for the rest of the plants.... with the same chart
type and format.

 

[Jon Peltier]

Microsoft admits they goofed that one up:

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904

They suggest you record a macro, so you can reapply the format whenever the pivot
table is updated.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______