May 10 2022 09:05 AM
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
Date | Amount | Client | Account |
04/05/2022 | 20 | Client A | Longterm |
04/05/2022 | 56 | Client A | MediumTerm |
04/05/2022 | 25 | Client B | Longterm |
04/05/2022 | 48 | Client B | MediumTerm |
04/05/2022 | 55 | Client C | Longterm |
04/05/2022 | 62 | Client A | ShortTerm |
04/05/2022 | 58 | Client D | ShortTerm |
04/05/2022 | 96 | Client D | Longterm |
05/05/2022 | 25 | Client A | Longterm |
05/05/2022 | 12 | Client A | MediumTerm |
05/05/2022 | 59 | Client B | Longterm |
05/05/2022 | 32 | Client B | MediumTerm |
05/05/2022 | 48 | Client C | Longterm |
05/05/2022 | 33 | Client A | ShortTerm |
05/05/2022 | 22 | Client D | ShortTerm |
05/05/2022 | 89 | Client D | Longterm |
May 10 2022 11:43 AM
I'd create a pivot table based on the data, then a pivot chart based on the pivot table.
See the attached sample workbook.