Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart from pivot data, and sheet data?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart Data Data range cannot be changed | Excel Discussion (Misc queries) | |||
Duplicating Pivot Chart / Changing Pivot Chart data range | Excel Discussion (Misc queries) | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
Pivot Chart Data from external data source | Excel Programming |