The easiest way to do this would be to use a PivotChart. PivotCharts allow you to create charts based upon pivot tables, which allows them to be filtered. A PivotChart actually has drop-down menus on the chart itself, which allow you to select a name.
For a walkthrough of how to create a PivotChart, see the video lesson: Expert Skills Lesson 5-23: Create a pivot chart from a pivot table.
Since a PivotChart is based on a pivot table, you can also filter it using the drop-down menu in the pivot table. For more on how pivot tables are filtered, see: Expert Skills Lesson 5-7: Use report filter fields.
You can make filtering even easier by applying a Slicer, which shows all of the names as large buttons. For a video walkthrough of creating slicers, see: Expert Skills Lesson 5-8: Filter a pivot table visually using slicers.
I have attached a copy of your workbook with the pivot table, pivotchart and slicer.
Compensation Planning-1-1.xlsx 39.27KB
You can also enable users to choose items from drop-down menus using a List Validation. It probably wouldn't be the approach you'd choose in this case, but you can learn about applying List validations in: Expert Skills Lesson 2-11: Add a table-based dynamic list validation.
Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.