| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Selectable Criteria
I have some cells with sales figures in them. Currently there is a simple bar
graph / chart that displays these figures. What I would like to do is somehow make it so a user can select certain criteria, say from drop down boxes? Such as: B8:M8 are months, Jan-Dec A9:A15 are categories I would like to be able to select which data the graph displays by a drop down, so if the user wanted, they could show only values for New Sales in Oct. Nov. And Dec. for example, these criteria can change at any time... Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a list of options with only one being selectable? | Excel Discussion (Misc queries) | |||
| How do I add N/A to a selectable cell with an arrow? | Excel Worksheet Functions | |||
| want a list of selectable names on my worksheet | Excel Worksheet Functions | |||
| How do I make a line non-selectable? | Excel Discussion (Misc queries) | |||
| How do I insert a selectable circle in Excel? | Excel Worksheet Functions | |||
Threaded Mode
