Thanks for the response Debra - this is what I did as a workaround in the end.
"Debra Dalgleish" wrote:
You could create another pivot table, based on the first pivot table,
then base the second chart on the second table.
Middlesex Tiger wrote:
I would like to know if it is possible to embed multiple Pivot Charts (with
different Pivot Table Fields used as paramters on each Chart).
I intially created a chart with certain fields and then created another
chart, but when I embedded a different field in the second chart, this
replaced the one in the original as well.
Any ideas, or is this simply not possible?
Many thanks.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html