Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
display chart based on control box
Hi
I want to give users an option of selecting a zone / parameter thru a control box. Based on the value they select, the chart should get displayed. How can i do this? Nikhil |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
display chart based on control box
Hi,
This would probably be done through code, but before that you should see if you can use the AutoFilter to do the job. The user can pick an item from the autofilter and Excel charts only the selected item. You can do something similar by plotting your chart from a pivot table. However, if those two ideas don't meet your needs you would need to supple a lot more detail before anyone here is going to be able to give you some code. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Nikhil" wrote: Hi I want to give users an option of selecting a zone / parameter thru a control box. Based on the value they select, the chart should get displayed. How can i do this? Nikhil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display a chart based on cell value | Charts and Charting in Excel | |||
Active x control box display order | Excel Discussion (Misc queries) | |||
How to display a hh:mm:ss cell value in a forms text control | Excel Discussion (Misc queries) | |||
Using Calendar control to display dates | Excel Discussion (Misc queries) | |||
How can I control the full screen display width ? | Excel Discussion (Misc queries) |