+ Reply to Thread
Results 1 to 8 of 8

Excel slicer

  1. #1
    Registered User
    Join Date
    08-25-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    51

    Excel slicer

    Hi,

    Hope you can help. Is it possible to hide a certain selection on the slicer? Basically I want to hide data on the graph on where the department has left than 5 employees?

    Thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,267

    Re: Excel slicer

    Hi sansan,

    Can you create a helper column that gives a blank when Employees is less than 5? Then do your slicer on this and use Slicer Settings to Hide rows with no data? See the attached.
    Slicer Helper Hide no data.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    624

    Re: Excel slicer

    You forgot to place the sample file

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,267

    Re: Excel slicer

    Hi Vraag,
    Click on the "Slicer Helper Hide no data.xlsx" and it should be there. I've just learned how to attach files a little quicker.

  5. #5
    Registered User
    Join Date
    08-25-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Excel slicer

    Thanks, but slicers is links to several pivots table, not sure if this will work?

  6. #6
    Registered User
    Join Date
    08-25-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Excel slicer

    Thanks, hide with no data would only work if no data right?

  7. #7
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,267

    Re: Excel slicer

    Yep, but that is why I built a helper column and an If() formula in it to go to "No Data" if the Employees were less than 5. Use this helper column instead of the real column in your slicer.

  8. #8
    Registered User
    Join Date
    08-25-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Excel slicer

    Thanks, I guess you built the helper on the master data? I will try this out and let you know. Thanks

+ 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. Disconnect Slicer, Change Pivot Source, Reonnect Slicer
    By ensi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2020, 04:26 AM
  2. Show value of highest slicer selections (multi selected items in slicer
    By saudi_red_neck in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-01-2020, 05:37 AM
  3. VBA Disconnecting Slicer, Updating PivotTable Source, Reconnecting Slicer
    By CowboyFlipflop in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-22-2019, 04:00 PM
  4. Loop through slicer, but don't do slicer action when values are unselected
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2018, 04:55 PM
  5. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  6. Replies: 1
    Last Post: 04-23-2018, 09:43 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