View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
maryj
 
Posts: n/a
Default 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