I want to create a set of dependant filters to dynamically update a
set of charts. Specifically, my data source has multiple rows each
with World Area, Country, City. I want to be able to select a World
Area, then select from just the Countries in that World Area, then
from just the Cities in that country to filter the charts. As a
second option, I would like to be able to just select a City without
first selecting World Area/ Country. I'm looking for assistance on
how best to accomplish this.

CMS_CWT has brought this to us :
> I want to create a set of dependant filters to dynamically update a
> set of charts. Specifically, my data source has multiple rows each
> with World Area, Country, City. I want to be able to select a World
> Area, then select from just the Countries in that World Area, then
> from just the Cities in that country to filter the charts. As a
> second option, I would like to be able to just select a City without
> first selecting World Area/ Country. I'm looking for assistance on
> how best to accomplish this.

Not sure but maybe...

http://www.contextures.com/xlDataVal15.html

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc