View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default Pull-down list for chart filter?

Dallman,

I don't quite get it. I've read your post over, but can't keep my eyes going in the same
direction. You say the chart responds to the filter. So I think you're using "Plot visible
cells only" (Tools - Options - Chart) But I don't know how named ranges gets into that.
Now you want a list box from which to select data to chart. Does that have something to do
with the named ranges? Say more about what's to be in the list box, and how it relates to
the data to be charted.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Dallman Ross" <dman@localhost. wrote in message ...
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=