Is it possible to make a graph that gets the plot points from the active row? (referencing the active row)?

[Rnkhch]

Hello,

I have a table that consists of one student per row, and the scores for each student in the same row. I'm wondering if it's possible to make a line graph such that it displays scores in time for the student in the active row. That way, I can just make one graph and visualize any student's progress over time by clicking on any cell in their row (rather than making numerous graphs for all students or making one overcrowded graph for all students).

I suppose I would need a way to reference the active row in "Series values:" when I 'select data' for the graph.

Any thoughts/guidance would be highly appreciated.

Thank you!

 

[Rnkhch]

You made my life much easier, so I may reach out for some additions