1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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!

Discussion in 'Ask an Excel Question' started by rcmlb, Jul 16, 2017.

  1. rcmlb

    rcmlb New Member

    Messages:
    1
    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..

    Attached Files:

  2. bobhc

    bobhc Excel Ninja

    Messages:
    3,348
    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.
    .
  3. p45cal

    p45cal Well-Known Member

    Messages:
    718
    Thomas Kuriakose likes this.

Share This Page