Pinterest Pixel

Icon Sets In A Pivot Table

John Michaloudis
An Icon Set is a Conditional Formatting icon/graphic that you can include in your cells or Pivot Tables.

An Icon Set is a Conditional Formatting icon/graphic that you can include in your cells or Pivot Tables.

The icon will depend on the cell´s value so you can highlight key variances or trends.  There are a few sets that you can include, like:

DIRECTIONAL (Change in values)

Icon Sets In A Pivot Table

SHAPES (Milestones)

Icon Sets In A Pivot Table

INDICATORS (Positive/Negative)

Icon Sets In A Pivot Table

RATINGS (Scores)

Icon Sets In A Pivot Table

I show you how easy it is to insert an Icon Set within a Pivot Table that will show a “directional icon” depending on the change of the monthly sales values.

So when monthly sales increase from the previous month, a green up arrow is shown and when monthly sales decrease, a red down arrow is shown.

Icon Sets In A Pivot Table | MyExcelOnline

download excel workbook Icon-Sets.xlsx

STEP 1: Place the SALES Field in VALUES

Icon Sets In A Pivot Table

 

STEP 2: Click on the new field and Select Value Field Settings

Icon Sets In A Pivot Table

Go to Show Values as > Difference From > (previous) to get the difference from the previous month

Icon Sets In A Pivot Table

 

STEP 3: Click in a variance cell. Go to Home > Styles > Conditional Formatting > Icon Sets > The First Icon Set

Icon Sets In A Pivot Table

STEP 4: Make sure to select the third option. This excludes the subtotals and grand totals.

Icon Sets In A Pivot Table

 

STEP 5: Go to Home > Styles > Conditional Formatting > Manage Rules

Icon Sets In A Pivot Table

Select Edit Rule.

Icon Sets In A Pivot Table

Set the settings to the ones shown below. This will set the column to show the arrow icons only.

Icon Sets In A Pivot Table

Your icons are now ready in your Pivot Table!

Icon Sets In A Pivot Table

 

How to Use Icon Sets In A Pivot Table

 

 HELPFUL RESOURCE:

101 Macros Book

 

If you like this Excel tip, please share it


Founder & Chief Inspirational Officer

at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  How to Use Conditional Formatting Based on Another Cell

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...