Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
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= |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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= |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete from pull down list | Excel Discussion (Misc queries) | |||
pivot table pull down filter | Excel Worksheet Functions | |||
entry not removed in pivot table pull down filter | Excel Worksheet Functions | |||
How do I set up a cell with a pull down list? | Excel Discussion (Misc queries) | |||
Pull data - Advance Filter | Excel Worksheet Functions |