Symbols in Pivot Slicers

A Neat Pivot Slicer Trick

How to use symbols in Excel Pivot Slicer

Give your report a customized look by replacing text with symbols in your Pivot Slicers.

Obviously you can’t do that with every Pivot Table filter. But replacing text with symbols whenever it makes sense, is actually effective in improving the readability of your report.

In this tutorial, you’ll learn a new Excel Pivot Slicer trick;

You’ll learn how to customize the look of some of your slicers to show symbols instead of text. In addition you’ll learn how to group categories in your Pivot Slicers.

We use sample HR data that has information on salaries for male and female employees by cost center. Our task is to create a dynamic dashboard report that uses symbols for gender and also for part-time and full-time employees.

Watch the steps in this video:

Feel free to Download the Workbook HERE.

Free Excel Download

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

Free Ebook

Leave A Comment

Share This