Drop down based graph using link picture method & named range

[gauravkrgautam]

Hi all,

please help me out of this i have created two graphs, and named ranges asdf & qwer surrounding to that, now i want to use asdf & qwer with an drop down list to view graphs accordingly.

Thanks in advance

 

[Debraj]

Hi gaurav..

re-try.. i know.. you can do it..
http://chandoo.org/wp/2013/04/23/interactive-chart-in-excel-tutorial/

 

[gauravkrgautam]

Many Thanks Deb i tried it & its been working fine i was using reference of named range with chart names instead of linkeed cell, thanks for sharing path of same things.

Choose(....., graph name1, graphname2 ) were chossing from linked cell 1or 2 or 3 respectively got the conecept
and will never forget the use of choose also

Thanks once again