display chart based on control box

[Nikhil]

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

 

[Shane Devenshire]

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.