Hi guys,
For our research we need to give feedback to patients based on several scores they obtain on different dates.
Here a small fictive example of my dataset:
excelhelp.png
Now we have a bunch of these ID's of course and I would like to generate a graph per ID where you can see the progress (lower score means progress!) of the patient.
I tried all day using pivot table but i am not getting anywhere. I know there is a way to refer to your whole dataset using a pivot table/graph and then filter on ID, where only the graph is generated for the ID you want when you click on the ID you want.
I would really appreciate your help! Thanks in advance.
Bookmarks