You can't add data from outside the parent pivot table to a pivot chart. It
is possible to add pivot data to a regular chart, if you use the Source Data
dialog, Series tab to add the data.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"DKS" wrote in message
...
Hi
I would love to have a pivot based chart and superimpose another set of
'regular' series on a secondary axis.
Is there a trick to get around doing this retaining the 'pivot' features?
MTIA