Pivot Chart - Preserve Formatting

[JMH022]

I am using Excel 2003.

I have a Pivot Table/Chart which contains two columns of data. One is a percentage, and the other is currency. I have reformatted the chart so the percentage data is displayed as a Line graph, while the currency remains a Column graph. (% over $). I also added a secondary Y-Axis for reference points for the percentages.

Here's the problem: Whenever the Pivot Table/Chart is refreshed with new data, I lose all formatting; the graph changes back to a column graph for both sets of data and I lose the secondary Y-axis.

Is there a way to "lock down" the graph so it will not revert when the Pivot Table/Chart is refreshed?

 

[Matty]

This is a known problem.

Best thing to do is the workaround suggested on Microsoft's website:

http://support.microsoft.com/kb/215904

Matty