How to change which data appears along x-axis

I am trying to teach myself looker studio and I’m about 5 hours in and have worked out lots of the settings, watching videos and reading up along the way.  I’m at a road block.

afe68ce6-d4f6-4497-8c1d-45f10f49fa91.jpg

I’ve made this data on the left, the blanked out part are student names.  I have created another part which isn’t shown which is a fixed-size list.  I want to be able to select a single student from that and display the graph like I have done on the right but just for the one student, but each time I set it up, the x-axis becomes the score and not the year, how do I set this up? I have tried mucking around with all set up but I don’t know enough.

My spreadsheet looks like this in google sheets:

4bb59b4b-0e82-4517-af15-b1760ca62023.jpg

Any support would be appreciated.

0 0 860
0 REPLIES 0