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

Slicer connection to chart

J

Joeman187

Member
Hi All,

On my batting dash tab I have a slicer where you can choose an individual player and get
their stats. I also made that individual player's HR pivot table with a chart. I copied the chart to the batting dash but whenever I choose a player the chart doesn't correspond. Can you fix that problem for me? Thank you in advance, Joe from Michigan.
 

Attachments

  • Detroit Dashboard.xlsx
    744.9 KB · Views: 5
See attached
I used a single series for the chart where you had used a number of series
Anyway it works
 

Attachments

  • Detroit Dashboard.xlsx
    751.5 KB · Views: 5
If you Change the structure to return more than 4 months on the HR Pivot Table then you should use a dynamic named Formula for the chart

I have done that using 2 Named Formula Months and HRs
and then using those in the chart instead of the Ranges

That way when you add September to the HR Pivot Table the chart updates
 

Attachments

  • Detroit Dashboard.xlsx
    768.3 KB · Views: 11
Hui, can you take a look at it one more time? The chart doesn't seem to be changing when I choose the player. Only the name does not thstats. Thanks.
 
You must log in or register to reply here.
Back
Top