Mulitple Pivot Charts In One Workbook

[Middlesex Tiger]

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]

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

[Middlesex Tiger]

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
>
>