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 - does
anyone know how to get around this?

Any help greatly appreciated.
Jason