Help With Slicers / Graphs

[Justinian]

I am trying to make a slicer chart for three teams: Team A, Team B, and Team C. The categories are annual absences, monthly absences, weekly absenced, and daily absences. I want to create a slicer so that when someone clicks the slicer category of Team A, five graphs are shown to illustrated Team A data: annual absences, monthly absences, weekly absenced, and daily absences. So far, I can create five separate slicers but I have to click on Team A on all five slicers spearately to display charts. I want to be able to have one slicer and click Team A once to display all five graphs, then click Team B and display all five Team B graphs, etc. This is my dashboard.

How can I do this?

 

[francoisdublin]

I am a recent convert to slicers - I used not see much point until I saw the light.


You can connect a slicer to multiple pivots/charts

Create your five charts.
Add one slicer for one of the charts.
In the Slicer Tools tab, click PivotTable connections and select all the tables you want to connect to the same slicer.

 

[Justinian]

I tried that but it only saw one pivot table.

Do I create all five pivots and graphs, then the slicer?

 

[Justinian]

Does anyone have any ideas? What was suggested above does not work.

 

[francoisdublin]

Works for me.

I created one pivottable and one pivot chart for it.
I created the second pivottable and pivot chart.
etc

I added the slicer and connected it to pivottable1, pivottable2 etc.

 

[francoisdublin]

I tried that but it only saw one pivot table.

Do I create all five pivots and graphs, then the slicer?

Did you not try before asking?

 

[Justinian]

I did try but only one table showed in the slicer connections.

 

[francoisdublin]

works for me so based on the little you say it's hard to help any more

 

[Justinian]

I did what you asked and it only displays one table even though there are two.