I can't add a slicer to connect my Pivot Charts. Help!

[rcmlb]

I have 10 pivot tables, each with a chart. I copied all ten charts in one dashboard but when I tried to add a slicer, I only can with one chart and still it showed NO CONNECTIONS AVAILABLE.

FYI: I'm using 2016 Excel & I already tried saving it as a new file .xlsx but it still won't work..

 

[bobhc]

Try This

1. Create two pivot tables off the same source data.
2. Create two pivot charts based on the two pivot tables.
3. Move (not cut and paste, although that is possible, too) the charts to another worksheet.
4. In that sheet, select one chart.
5. Click the chart, then the "Analyze" ribbon > Insert Slicer.
6. Select the slicer field.
7. Click the second chart.
8. Click the "Analyze" ribbon > Insert Slicer > Slicer connections
9. Tick the box next to the field that shows in the dialog (which is the field from the first slicer)
10. Now both charts are connected to the same slicer.

.

 

[p45cal]

I managed to get slicers in your workbook by following from 2min 45 secs. this video:
4evkRxT5gOQ

Also here: http://www.contextures.com/excelpivottableslicers.html#videoproblems
Involves saving as .xls which may lose you some aspects of the file - I don't know what!