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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

50 Things You Can Do With Excel Pivot Tables Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.   A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, "pivot"/change the report layout with the ease of dr...
Pivot Table Conditional Formatting Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot Table Adding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second. See how easy it is to add some color to your analysis. DOWNLOAD WORKBOOK ...
Show Report Filter Pages in a Pivot Table When you are using an Excel Pivot Table you can show the items within the Report Filter on separate sheets inside your workbook. Say that you have created an awesome Pivot Table which shows total sales and number of transactions per region. You can drop in your Customer fie...
Running Total In % with an Excel Pivot Table A Running Total In is the accumulation of values over a certain period, like days, month or years.  It is sometimes referred to as the Year to Date analysis. A Running Total In takes one period's values, then adds a second period, then a third period...and so on, to give the a...