Mulitple Pivot Charts In One Workbook
 

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.

Mulitple Pivot Charts In One Workbook
 

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

Mulitple Pivot Charts In One Workbook
 

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