Keep format after pivot

[CG]

Is there a way to maintain a chart's format after you change the data
you are looking at? I build a pivot chart and whenever I pivot to view
different data, the chart type reverts from a line -2 axis (which I
selected) back to a bar graph.

Thanks in advance

CG

 

[Andy Pope]

This is a known bug that required vba code to re-apply formatting.

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

Cheers
Andy