+ Reply to Thread
Results 1 to 5 of 5

Excel 2016 formatting slicers

  1. #1
    Registered User
    Join Date
    07-08-2013
    Location
    Kent, England
    MS-Off Ver
    Excel 2016
    Posts
    71

    Excel 2016 formatting slicers

    Hi is it possible please, to somehow hide slicer "group options" that do not actually contain any information for that particular pivot/graph?

    slicer question.jpg

    Hopefully you can see Families "History" and "#N/A" that for the life of me I can't hide them, I have deleted and created new slicers again and again, and I have tried every combination in the slicer formatting settings.

    Thing is there aren't even any N/A families, although there are History's which do have results, they are machines we no longer make but need to stay in the report, until such a time when they naturally fall off but are in the reporting period at present.

    Thank you, please save my sanity
    Clair
    Last edited by clairh2011; 02-15-2018 at 12:45 PM. Reason: now resolved
    Thanks
    Clair

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Excel 2016 formatting slicers

    maybe this:

    slicersettings.jpg
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Excel 2016 formatting slicers

    I suspect the #N/A is old data. You need to change the Pivot Table's data settings to not retain old data values.

    There is an option in the slicer settings to hide items with no data- do you have that selected?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Registered User
    Join Date
    07-08-2013
    Location
    Kent, England
    MS-Off Ver
    Excel 2016
    Posts
    71

    Re: Excel 2016 formatting slicers

    thank you thank you thank you

  5. #5
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Excel 2016 formatting slicers

    Welcome, welcome, welcome

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)

    If you did it already - ignore it.
    Thank you.
    Last edited by sandy666; 02-17-2018 at 02:48 AM.

+ 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-18-2017, 08:27 AM
  2. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  3. Help! Automated Email coding for Excel 2016 and Outlook 2016 problems
    By lisa6421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2017, 08:07 AM
  4. Replies: 0
    Last Post: 08-31-2017, 10:40 AM
  5. [SOLVED] Excel 2016 Conditional Formatting
    By excelconditional in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2016, 11:18 AM
  6. Conditional Formatting in Excel 2016
    By Mansfieldexcel in forum Excel General
    Replies: 2
    Last Post: 03-21-2016, 01:56 PM
  7. [SOLVED] Excel 2016: Conditional Formatting to highlight weekends
    By ClareLou in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2016, 01:25 PM

Tags for this Thread

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