Hi,

This is a know issue.
XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

David wrote:
I have a Pivot Chart with two series of data, one of which is plotted on the
secondary y axis. Every time I refresh the chart, it defaults back and I
lose my secondary axis. I then have to manually change this every time.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info