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.
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