Hi.

The latest request is to do a chart which is partially from data in a pivot
table, and partially from static data in another sheet.

The pivot table itself is based upon too many rows to handle in Excel
2003... there's a pivot cache built from an ADO recordset, returned from
Oracle tables.

Is it possible to present a chart with the data mentioned which would be
dynamically updated when the selections in the pivot table are changed?

If not, here's what I've thought up as of now:

1) Fire code when the sheets' PivotTableUpdate event is fired
2) Have that code Copy PasteSpeckial values the data in the pivot table
3) Create the chart off of the static version of what was selected in the
pivot table, and the static data from the other source sheet.

That should work...

but, I'm open to suggestions.