+ Reply to Thread
Results 1 to 3 of 3

Associate Slicer to Multiple Tables

  1. #1
    Registered User
    Join Date
    09-10-2019
    Location
    Edinburgh, UK
    MS-Off Ver
    Office 365 (Mac and Windows)
    Posts
    27

    Question Associate Slicer to Multiple Tables

    I am using a bubble chart and have three series of data from three tables on separate worksheets displayed. All three tables have the same format in terms of the number of columns, column names etc.

    I would like to be able to filter the bubble chart using a slicer but cannot see any way to do this, can you help?

  2. #2
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Associate Slicer to Multiple Tables

    As far as I know you can't assign 1 slicer to 3 different tables.

    Either insert all 3 tables' data into 1 table (since they're same format, column names and numbers anyway),

    or

    make 3 slicers and format them in way they are compact and look good.

    I would move the entire data into 1 table, but the other option is just as simple.
    To show your appreciation
    Click ★ Add reputation!

  3. #3
    Registered User
    Join Date
    09-10-2019
    Location
    Edinburgh, UK
    MS-Off Ver
    Office 365 (Mac and Windows)
    Posts
    27

    Re: Associate Slicer to Multiple Tables

    Thanks. The problem with the data being in one table is that the series data is in one column (one of three distinct values) and I want to colour code the bubble chart dependent on the value which is why I split into three tables originally so I could import them as separate series.

+ 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. Replies: 1
    Last Post: 09-11-2019, 11:54 AM
  2. Associate values between 2 sets of tables
    By Hsalem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2019, 08:46 AM
  3. One Slicer to control 2 Tables (Not Pivot Tables) in 2016
    By sparkyster in forum Excel General
    Replies: 1
    Last Post: 05-09-2018, 03:00 PM
  4. One Slicer to control 2 Tables (Not Pivot Tables) in 2016
    By sparkyster in forum Excel General
    Replies: 1
    Last Post: 05-09-2018, 01:25 PM
  5. Replies: 3
    Last Post: 12-04-2017, 01:55 PM
  6. Replies: 5
    Last Post: 12-04-2017, 10:33 AM
  7. Replies: 1
    Last Post: 07-21-2017, 02:44 AM

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