pivottable + chart

[Franck]

How to add data to the chart of a pivottable but the data are not in the
datasource of the pivottable

Regards
Franck

 

[Frank Kabel]

Hi
AFAIK this is not possible for these kind of pivot charts

 

[Franck]

Thanks Frank Kabel

Is there another way to do it by using another kind of charts

 

[Debra Dalgleish]

On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm

Once you've created the normal chart, you could add your other data to
that chart.