Multiple Drop Down_ Chart

[bilboy]

Hi friends,


I came across this challenge in excel of putting two drop downs in graph and fetching the chart that satisfies these two criteria.


For example- if in the first drop down i have selected Question 1 and in second drop down any one Mall from drop down. It should show the trend (as per data) for this criterion in chart format.


Attaching a sample excel sheet.

Data in data tab and Graph with drop down (in yellow) in Graphs tab


Any ideas!!!

Bilboy

 

[Hui]

See attached:
It uses a Named Formula for the Y_Values

 

[bilboy]

See attached:
It uses a Named Formula for the Y_Values

Thanks a lot sir...
U made my day Cheers!!!
Have a nice day