• 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...

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

Circle Charts

Hi Chandoo Experts,

Happy Saturday! I have made a sports dashboard. Under the "Pitching Dash" tab I have created some circle charts. The only problem I am having is that the inputs are not changing when I select the player from the drop down list above. Can you check the formulas underneath the charts to see what I did wrong? I appreciate the help. Joe, Michigan.
 

Attachments

  • Detroit Dashboard.xlsm
    986.9 KB · Views: 5
Joseph Horling,
Your data series are not dynamic. You refer to pitches B2 which will always return the data for Joba Chamberlain.
You could add a in your data a lookup table that fetches the required data to plot on the chart. =VLOOKUP(name entered, dataTable, requiredColumn).
In uploaded file: chart still refers to B2, but that cell now responds to the selected player name.
Now you need to repeat this for all of your charts.
 

Attachments

  • Copy of Detroit Dashboard.xlsm
    992.1 KB · Views: 11
Sorry Joseph, I do not understand the question, probably like very often there is a way in Excel to accomplish stuff. But what is your aim?
 
Hi G,

I was hoping to just connect the slicer I have so that the everything will work in
one spot instead of jumping back and forth from the pitches tab to the dash tab and manually selecting the player from the drop down list. I want the era chart to change and the circle charts to change when I click on one of the players names on the slicer. Don't know if that is possible, but hoping.
 
It is possible. Your workbook could do perhaps with some lay-out enhancements to make it easier.
Here is a way how it can be done:
- copy the pivot to "pitches"
- put name in row labels
- connect your slicer to this pivot (when it is clicked, only that name will be in the list)
- in the "lookup table" you change the player name by a reference to the new pivot
 

Attachments

  • Copy of Detroit Dashboard.xlsm
    992.8 KB · Views: 8
Back
Top