Putting names and percentage on a baseball diagram

[Joseph Horling]

Hi Chandoo experts,

I am creating a baseball dashboard involving statistics from my hometown Detroit Tigers. I was wondering if you can take a look at the baseball diagram that I created in the "Batting Dash." What I would like to do is to select a player from the drop down list and have his name and the percentage of games to appear in that particular position on the diagram. On sheet two are the names and positions of where each player played. Thank for your help. The file is attached. Joe, Michigan.

 

[Hui]

If I select Cabrera How do i know he should be at First Base?

You will need a Table of Names and Locations somewhere in the file

 

[Joseph Horling]

Hi Hui,
I made a table of the players positions and percentages of each position they have played, it's under sheet5.

 

[Hui]

See attached

 

[Joseph Horling]

Hi Hui,

Thanks so much for your help. Could you do one more thing for me? Can you explain how you did that? I would like to create some more graphs like that but doing it that way I have no idea. I would appreciate it.