PivotChart not updating properly
 

Hi folks,

User upgrading from 2003 to 2007 issue.

In 2003, PivotTable is too wide for spreadsheet when displaying all data.
Excel attempts to display as much data as possible (with warning message),
and PivotChart attempts to reflect this. Filters all work ok, displaying as
much data as shown in PivotTable.

In 2007 (in compatability mode and native mode), same issue on PivotTable,
which is fine, and filtering on a field in the chart is fine. However, when
trying to change the filter to display all data, the chart doesn't change
from the filtered view it had previously.

Refreshing and recreating didn't solve the problem. Am I 'overloading' the
chart - if so, why does it not attempt to at least chart what it can, as in
2003?

Hope this makes sense!

Tia,

Piers