+ 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
    18

    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 Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    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
    18

    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 Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    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
    18

    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)

Similar Threads

  1. [SOLVED] Splicer works with all charts but one
    By charlesfarrell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-16-2017, 12:46 PM
  2. Replies: 1
    Last Post: 10-10-2016, 01:17 PM
  3. [SOLVED] Pivot Table/Chart to filter categories
    By Maxthelion in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 05-20-2014, 10:26 AM
  4. How to show full totals in Pivot chart and table when you filter on one customer?
    By newbieexcelgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 06:30 PM
  5. Can a macro filter a table for chart production?
    By debbiemccann in forum Excel General
    Replies: 0
    Last Post: 06-11-2012, 09:30 AM
  6. How to have macro filter a table for chart production
    By debbiemccann in forum Excel General
    Replies: 0
    Last Post: 06-10-2012, 11:11 PM
  7. [SOLVED] Trying to turn table of data into a chart with a filter
    By dwhite30518 in forum Excel General
    Replies: 5
    Last Post: 06-05-2012, 12:06 PM

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