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

Jon Peltier has some interactive charting examples:

http://www.peltiertech.com/Excel/Cha...ByControl.html

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

In addition to Debra's suggestion, check
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/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

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