G Guest Jun 15, 2005 #1 I would like to know how to automate the graph using drop down list where I can select the appropriate parameters.
I would like to know how to automate the graph using drop down list where I can select the appropriate parameters.
D Debra Dalgleish Jun 15, 2005 #2 Jon Peltier has some interactive charting examples: http://www.peltiertech.com/Excel/Charts/ChartByControl.html
Jon Peltier has some interactive charting examples: http://www.peltiertech.com/Excel/Charts/ChartByControl.html
T Tushar Mehta Jun 17, 2005 #3 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
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