Keep format after pivot
 

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

Keep format after pivot
 

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

CG wrote:
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, Microsoft MVP - Excel
http://www.andypope.info