Forum Discussion
annlyn_800
Jun 08, 2019Copper Contributor
Creating an interactive chart with a drop down list
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.
1 Reply
- SergeiBaklanDiamond Contributor
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_list_in_excel.html, you may google for more similar posts