Dynamic Graphs

Copper Contributor

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.