Pivot Chart Problem

[WhytheQ]

I have a pivot chart with two data series plotted on it A and B
Series A is plotted against the primary Y-axis, and series B against
the secondary Y-axis....trouble is that when the pivot table is
refreshed the line for series B totally disapears off the chart !!!

- has anyone ever encountered this and is the only solution using
code?

Any help greatly appreciated.
Jason

 

[Guest]

Record a Macro that refreshes the format of the chart.