View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default 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=