Create reference between 2 tables where the rows in table 1 match the column headers in table 2

Hello - 

I am newer to PowerBI and appreciate any suggestions that come from my question.

I have an excel spreadsheet that is being used to keep track of 40 yard dash times for players on a team.  Column A has the list of players and Columns B...n are the times for each timed run per user.  

I am trying to create a simple dashboard that consists of 2 visualizations.  The first would be a table of the player names and the second would be a line graph with Time (y) and runs (x).  The table would be used to filter the line graph to a single runner.

My problem with the data is that I can only get a dot on the graph in a virtical line for each players run and not a horizontal line.  The table filtering works.

I decided to transpose the spreadhseet and put the Run1 in column 1 and then the other column headers are the player names.  This allows the graph to have a horizontal line but I cannot figure out a way to create the chart for player names and filter.  

I am looking for either a more efficient way to create this...or a way to create a table just for player names and create a reference to the data.

Thanks in advance!

Jason