1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Putting names and percentage on a baseball diagram

Discussion in 'Discuss Data Visualizations and Charting' started by Joseph Horling, Mar 10, 2019.

  1. Joseph Horling

    Joseph Horling Member

    Messages:
    71
    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.

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    12,266
    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
  3. Joseph Horling

    Joseph Horling Member

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

    Attached Files:

  4. Hui

    Hui Excel Ninja Staff Member

    Messages:
    12,266
    See attached

    Attached Files:

  5. Joseph Horling

    Joseph Horling Member

    Messages:
    71
    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.

Share This Page