|Subject:||Refreshing pivot makes second data series line disappear from chart !!!|
|Posted by:||WhytheQ (whyth…@gmail.com)|
|Date:||14 Jun 2006|
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.