Creating an interactive chart with a drop down list

[annlyn_800]

Hi,

I was wondering how I can create a graph that is interactive. Basically I have a graph that has one set of data which is column graph, and the three other data series which are line graphs. I wanted the option of selecting the line graphs through a drop down option. I do not want all three line graphs stacking on top of each other. 

Please help. 

Thank you. 

[#2]

@annlyn_800 , the idea with step by step instruction is here https://www.officetooltips.com/excel_2016/tips/how_to_create_an_interactive_chart_with_drop-down_lis..., you may google for more similar posts