Abstract
Transcript
Pivot table slicers come with a variety of options and options.
Lets take a look.
There are several ways to get to slicer options.
First, you could hit the Option tab of the Slicer Tools ribbon.
The Slicer Tools ribbon will appear whenever you select a slicer.
you could set the heading or caption for a slicer directly on the ribbon itself.
If you want to hide captions altogether, opt for Slicer controls button and uncheck display header.
Lets re-turn on the header.
Just right-click, and select Z-A.
it’s possible for you to also sort buttons using custom lists.
Just double-check this option is enabled in the Slicer controls dialog.
To see how these work, lets add a new slicer for Category.
By default, the Category slicer shows the four existing categories.
Now lets add a new category item the source data called Custom.
When we refresh the data, we see a new button in the slicer called Custom.
Lets now revert our change in the source data and switch Custom back to Plain.
When we refresh the pivot table, we see the Custom button has been dimmed.
This indicates that there is no data to show for that item.
If you want to hide the button altogether, uncheck the option Show items deleted from the data source.
The last option forces buttons with no data to appear last in the list.
