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

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

rcmlb

New Member
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..
 

Attachments

  • New.xlsx
    219 KB · Views: 4
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.
.
 
Back
Top