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

[jpgrimes22]

Record a Macro that refreshes the format of the chart.

"WhytheQ" wrote:

> 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
>
>