+ Reply to Thread
Results 1 to 2 of 2

Have slicer generate slicers depending on selection

  1. #1
    Registered User
    Join Date
    02-10-2020
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    12

    Red face Have slicer generate slicers depending on selection

    Hello masters of Excel.

    Is it possible to have a slicer generate diffrent slicers depending on the slection you made in the first slicer, in the same way as you can generate diffrent lists with the indirect function?
    I tried to get the pivot tables to work with the indirect function but I dident get it to work.

    I linked a workbook with a slicer named Car brands. I want that slicer to generate one out of two slicers with car models depening on the brand.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Have slicer generate slicers depending on selection

    See if the layout of row over row table (columns J:K) and pivot table (columns M:N) with slicers is something that you could use.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Macro to Run when Slicer Selection is Changed (multiple slicers)
    By jcanlas in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2021, 11:41 AM
  2. Limiting slicer selection to 1 item for two different slicers
    By aalbarak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2018, 12:09 AM
  3. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  4. [SOLVED] Slicers -- Change ' Name to use in formulas ' value of the Slicer Setting
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2017, 02:08 PM
  5. Slicers - how to update one slicer for all charts?
    By kreinking in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-06-2016, 03:35 PM
  6. Replies: 5
    Last Post: 06-21-2013, 08:42 AM
  7. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 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