Home

Creating an interactive chart with a drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-679095%22%20slang%3D%22en-US%22%3ECreating%20an%20interactive%20chart%20with%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679095%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20how%20I%20can%20create%20a%20graph%20that%20is%20interactive.%20Basically%20I%20have%20a%20graph%20that%20has%20one%20set%20of%20data%20which%20is%20column%20graph%2C%20and%20the%20three%20other%20data%20series%20which%20are%20line%20graphs.%20I%20wanted%20the%20option%20of%20selecting%20the%20line%20graphs%20through%20a%20drop%20down%20option.%20I%20do%20not%20want%20all%20three%20line%20graphs%20stacking%20on%20top%20of%20each%20other.%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-679095%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679144%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20an%20interactive%20chart%20with%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679144%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356982%22%20target%3D%22_blank%22%3E%40annlyn_800%3C%2FA%3E%26nbsp%3B%2C%20the%20idea%20with%20step%20by%20step%20instruction%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.officetooltips.com%2Fexcel_2016%2Ftips%2Fhow_to_create_an_interactive_chart_with_drop-down_list_in_excel.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.officetooltips.com%2Fexcel_2016%2Ftips%2Fhow_to_create_an_interactive_chart_with_drop-down_list_in_excel.html%3C%2FA%3E%2C%20you%20may%20google%20for%20more%20similar%20posts%3C%2FP%3E%3C%2FLINGO-BODY%3E
annlyn_800
Occasional Visitor

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

@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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies