Hello welcome to the forum.
Take a look at the attached example. The chart is fed from some dummy data on the Chart Data tab to return only those values that meet the drop down criteria; top 1, top 2 etc. The formulas are in B3:Q10 on the Chart Data tab.
Is this what you're looking to do?
DBY
Bookmarks