Creating a button out of text (a student name) that will automatically insert a graph

. I am trying to do the following

Unit Percentage Score Unit 1 Percent Score Johny Smith Betty Donovan
Unit 1 Operations & Algebraic Thinking 2 100.00% 50.00%
Unit 1 Measurement & Data 3 100.00% 66.67%
Unit 1 Geometry 0 #DIV/0! #DIV/0!
Unit 1 Number & Operations Base Ten 16 100.00% 93.75%

1- I would like to create a type of link or button that would exist in the cell “Johny Smith” so that when a teacher clicks on that name excel would generate a graph or pie chart for the specific data associated with Johny and when a teacher clicks on Betty a different graph would pop up. I know teachers can just highlight the data and insert charts, but many of them don’t know how to do that. I have been asked to make the process a one click function. Is that possible?


Thank you in advance for your time.