Slicer --- is it possible to remove items with no data

[PP3321]

The items in the slicer are shaded if they are without any data.

Problem is that it is not very clear...

I want to make them 100% invisible.

Is it possible...?

 

[Luke M]

Yes, but it takes a few steps.

1. With slicer selected, go to Options, and right-click on the slicer style you want to use as a baseline. Select 'Duplicate'.
2. In the screen that pops up, you can now modify appearance of many things. You'll want to focus on items with "...No Date".
3. Change the formatting of all those items so font,fill,border are white (or whatever you want to make it invisible)
4. Ok out when done.
5. If you missed a setting, open the Slicer Styles box and you'll see your Custom setting. Right-click on that, and hit 'Modify' to get back into menu.

 

[NARAYANK991]

Hi ,

Some more information is available here :

http://stackoverflow.com/questions/3988703/any-way-to-hide-slicer-values-in-excel-2010

http://datapigtechnologies.com/blog/index.php/getting-fancy-with-your-excel-slicers/

Narayan

 

[PP3321]

Wow thank you guys...!