Dynamic Graphs

%3CLINGO-SUB%20id%3D%22lingo-sub-3352118%22%20slang%3D%22en-US%22%3EDynamic%20Graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352118%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20am%20trying%20to%20create%20a%20dynamic%20line%20graph%20for%20the%20below%20data.%20I%20need%20the%20'amount'%20on%20the%20vertical%20axis%20and%20the%20'dates'%20on%20the%20horizontal%20axis.%20Then%20I%20need%20a%20drop%20down%20menu%20at%20the%20top%20where%20you%20can%20select%20the%20'Account'%20.%20Then%20for%20each%20account%2C%20we%20will%20plot%20the%20different%20clients%20in%20the%20same%20graph.%20(%20different%20amounts%20over%20time)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22390px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3EDate%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3EAmount%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EAccount%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E04%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E20%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20A%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3ELongterm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E04%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E56%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20A%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EMediumTerm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E04%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E25%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20B%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3ELongterm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E04%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E48%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20B%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EMediumTerm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E04%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E55%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20C%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3ELongterm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E04%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E62%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20A%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EShortTerm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E04%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E58%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20D%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EShortTerm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E04%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E96%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20D%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3ELongterm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E05%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E25%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20A%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3ELongterm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E05%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E12%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20A%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EMediumTerm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E05%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E59%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20B%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3ELongterm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E05%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E32%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20B%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EMediumTerm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E05%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E48%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20C%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3ELongterm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E05%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E33%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20A%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EShortTerm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E05%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E22%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20D%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3EShortTerm%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2292.4688px%22%3E05%2F05%2F2022%3C%2FTD%3E%3CTD%20width%3D%2268.0156px%22%3E89%3C%2FTD%3E%3CTD%20width%3D%2251.5px%22%3EClient%20D%3C%2FTD%3E%3CTD%20width%3D%22177.016px%22%3ELongterm%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3352118%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3353087%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20Graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3353087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386099%22%20target%3D%22_blank%22%3E%40ExcelAD190%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20create%20a%20pivot%20table%20based%20on%20the%20data%2C%20then%20a%20pivot%20chart%20based%20on%20the%20pivot%20table.%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20sample%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi - I am trying to create a dynamic line graph for the below data. I need the 'amount' on the vertical axis and the 'dates' on the horizontal axis. Then I need a drop down menu at the top where you can select the 'Account' . Then for each account, we will plot the different clients in the same graph. ( different amounts over time)

 

Any ideas?

thanks

 

DateAmountClientAccount
04/05/202220Client ALongterm
04/05/202256Client AMediumTerm
04/05/202225Client BLongterm
04/05/202248Client BMediumTerm
04/05/202255Client CLongterm
04/05/202262Client AShortTerm
04/05/202258Client DShortTerm
04/05/202296Client DLongterm
05/05/202225Client ALongterm
05/05/202212Client AMediumTerm
05/05/202259Client BLongterm
05/05/202232Client BMediumTerm
05/05/202248Client CLongterm
05/05/202233Client AShortTerm
05/05/202222Client DShortTerm
05/05/202289Client DLongterm
1 Reply

@ExcelAD190 

I'd create a pivot table based on the data, then a pivot chart based on the pivot table.

See the attached sample workbook.