Results 1 to 3 of 3

Thread: Slicers

  1. #1


    Register for a FREE account, and/
    or Log in to avoid these ads!

    I’m new in here so not really sure how it works… But I have a question (properly an easy one) about slicers. I’ve build a number of graphs and charts from several pivots. Then added slicers afterwards and it all works just fine. BUT all the subjects in the slicer are automatic selected from the beginning. My question: “is it possible to set the slicer to blank?? Thereby making all graphs blank as well". I wanna do that to minimize the risk of errors by the users. I would like the user to make an active choice to make sure he or she gets the right graph.

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Excel Version
    No, it isn't - you can't deselect all the items. You would have to add a dummy entry to the source data perhaps (eg. 'Select an item') and then have that as the only selected item in the slicer.
    This website wants to know your momentum - | Deny | | Allow |

  3. #3
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    New Zealand
    Yep, JoePublic's right. I've got some code that will quickly de-select all but one item in a pivotfield if you need could set the code to automatically filter on the dummy item when the workbook opens, or when a 'reset' button is pushed. Doing this manually can be a bit tedious.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts