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 icon sets that you can include, like:

DIRECTIONAL (Change in values)

Directional2

SHAPES (Milestones)

shapes

INDICATORS (Positive/Negative)

indicators

RATINGS (Scores)

ratings

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.

DOWNLOAD EXCEL WORKBOOK

Icon Sets

 HELPFUL RESOURCE:

728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Fix Column Width in a Pivot Table Each time you Refresh a Pivot Table you will most likely get annoyed at the fact that the column widths that you worked so hard to align - will return back to normal 🙁Do not fear, Pivot Table Options is here!All you need to do is Right Click in the Pivot Table and choose...
How To Fix Pivot Table Empty Cells I am sure that you have come across a Pivot Table which has empty cell values and thought "What the hell is happening here?"This is because your data source has blank cells for certain items, which happens from time to time.This can be fixed in your Pivot Table and you ca...
Pivot Charts Pivot Charts in Excel are an extension of a Pivot Table and they show its values in a graphical representation.  So when you filter a Pivot Table, the Pivot Chart updates accordingly.To insert a Pivot Chart you need to click in your Pivot Table, go to the PivotTable Tools tab...
Add Columns to Pivot Table Slicer Buttons When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout.Say that your Pivot Table Slicer is showing months from January to December.  You can change the layout of the buttons to show in 3 separate column...