Trouble Creating Filterable Line Graph

I am trying to create a filterable line graph. I've found a few articles online that are slightly relevant, but nothing to my specific data set. I attached an image of a sample data set.

In my table, there will be multiple rows with the same name. Each name will correspond to a single date. So in the example, Joe Smith has 1 score on 5/30, 5/29, 5/28, etc. I want to be able to select Joe Smith from a drop down menu (I already set up the dropdown), and have the line graph update with only Joe Smith's scores over that period of time. Then, be able to select Mike from the drop down, and have his scores populate.

Is something like this possible? Please let me know if I need to add any additional information, this is my first time posting. Happy to help where I can. I can upload the spreadsheet when I get home if necessary.

Thank you!!

Thanks for the tip! Attached a sample workbook.

All of my data is on the "Data" sheet. On the "Graph" sheet, I made a sample graph of what I am looking to show (for 1 person).
Ideally, I would like to select a name in the drop down (Cell B2) and have the graph update based on the data in the "Data" sheet.

Each of the 8 people will have 1 new record added per day in the future, so the graph would need to be dynamic.

Would something like this be possible? Open to all hints and suggestions. Thank you!

Originally Posted by jeffreybrown

Hi Ron,

I think I can help, but must ask, can you sort the data sheet A-Z by name?

Hi- I can, but there will be data added once every day. Would I need to sort the data sheet everyday in order to see the graph?

This works perfectly! Thank you so much! Very appreciated