You can use pivot table data in a regular chart, but you have to specify it
carefully. Create a chart based on the non-pivot data, or starting with a
blank cell (no data). In step 2 of the wizard, or after creating the chart,
from Chart menu Source Data, click on the Series tab, add your series on
at a time, and select the X and Y value ranges. If you start with any data
in the pivot table selected, the chart becomes a pivot chart. If you use the
Data Range tab, the chart becomes a pivot chart. The pivot table can still
be live, you don't have to paste values. However, the chart will not
automatically update its data range with the change in the pivot table,
unless the pivot table only changes one dimension, which is the number of
points in a series, and you have a dynamic name defined to track that.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mark" wrote in message
...
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.