I would like to know how to automate graph using drop down list

[Lokesh]

I would like to know how to automate the graph using drop down list where I
can select the appropriate parameters.

 

[Debra Dalgleish]

Jon Peltier has some interactive charting examples:

http://www.peltiertech.com/Excel/Charts/ChartByControl.html

 

[Tushar Mehta]

In addition to Debra's suggestion, check
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005