Menu
I know that Excel 2010 Slicers will visually indicate when there is no data associated with a particular slicer selection. For example, they are faded in color for 2010 if you have no values in 2010.
Is there some setting where I can hide them altogether?
If I have sales in 2007, 2009, and 2010; but not 2008 can the slicer list omit 2008 entirely or must it always be shown as greyed out.
I'm not asking for a SQL selection solution, but rather an Excel setting.
459
Have you tried to filter out the blanks from your pivot table first column and Right click on the slicer and then navigate to "Slicer Settings". Then check the box that says "Hide items with no data".
In Excel 2010, you can only apply slicers to PivotTables, but 2013 will also let you add slicers to data tables. The following images were taken using Excel 2010 on Windows 7. Click on any cell within the PivotTable for which you want to create a slicer.
Actually, yes you can! If the item on the slicer is grayed out because there is no data, you can do the following:
Right click anywhere on the slicer and select "Slicer Settings" from the drop down.
On the bottom right select the box that says "Hide Items with no Data".
Click "OK"
143
Found a way of mimicing this in 2010 - see this article on formatting Slicers
http://datapigtechnologies.com/blog/index.php/getting-fancy-with-your-excel-slicers/
Create a custom format, and just set the items with no data to white fill & White text, and they dissapear! You should also set the "hover over" for items with no data to the same, otherwise they will appear if the user hovers ofer the item. Simples. Thanks to Datapig!
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
