Pull-down list for chart filter?
I have a chart that changes according to how I filter my
data. I used named ranges to achieve this. I want to
add a selection box with a list of the data I might wish
to select and view in the chart. (Then I won't have to
fumble with choosing from the autofilter list, which contains
lots of things I'm not interested in viewing or skipping past.)
I don't know how to approach doing this. Help would be
appreciated. xl 2002.
Thanks,
=dman=
|