Would this "link" the chart to the pivot table, i.e. I can select pivot rows
or columns to display and the chart changes automatically?

Or would this technique simply use the data in a pivot table as regular data?


"Jon Peltier" wrote:

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