Refreshing pivot makes second data series line disappear from chart !!!

Giganews Newsgroups
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.
Jason

Replies