pivot chart filters
 

A client is using Excel2003/WinXP and has a pivot chart with 2 levels of row
grouping. Is there a way that by selecting a particular item from the first
filter list will control the values displayed in the second filter list? Hope
this makes sense.
--
maryj

pivot chart filters
 

In the page area, the pivot fields aren't dependent, and there's no
setting you can change to make them dependent.

maryj wrote:
A client is using Excel2003/WinXP and has a pivot chart with 2 levels of row
grouping. Is there a way that by selecting a particular item from the first
filter list will control the values displayed in the second filter list? Hope
this makes sense.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

pivot chart filters
 

Thanks Debra. That's what I thought the answer was going to be.
--
maryj


"Debra Dalgleish" wrote:

In the page area, the pivot fields aren't dependent, and there's no
setting you can change to make them dependent.

maryj wrote:
A client is using Excel2003/WinXP and has a pivot chart with 2 levels of row
grouping. Is there a way that by selecting a particular item from the first
filter list will control the values displayed in the second filter list? Hope
this makes sense.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html