+ Reply to Thread
Results 1 to 5 of 5

Filter table and chart with same splicer

  1. #1
    Registered User
    Join Date
    05-11-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2016
    Posts
    12

    Filter table and chart with same splicer

    Hi everyone,

    I have a table of data that I can filter with a splicer.

    I have a pivot chart that also updates with a splicer.

    I would like both to update with the same splicer, is this possible?

    Thanks,
    Charlie

  2. #2
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    155

    Re: Filter table and chart with same splicer

    Right-click on the slicer, then select PivotTable Connection.

  3. #3
    Registered User
    Join Date
    05-11-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2016
    Posts
    12

    Re: Filter table and chart with same splicer

    I don't have that option, I have "report connections" which allows me to connect the splicer to different pivot tables but does not allow me to splice the original data table.

    I can create a splicer from the original data table but this splicer doesn't have the "report connections" so I am unable to connect it to the pivot tables. Meaning I have to use two sets for exactly the same filters, one for the table and another for the pivot.

  4. #4
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    155

    Re: Filter table and chart with same splicer

    PivotTable Connection is for older version of Excel, Report Connections is for newer Excel version.

  5. #5
    Registered User
    Join Date
    05-11-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2016
    Posts
    12

    Re: Filter table and chart with same splicer

    Yes I had an idea it was due to a version difference.

    Do you happen to happen to know a work around that would use one set of splicers to filter a table and also a pivot chart?

    Thanks,
    Charlie

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1