Icon Sets

Icon Sets, also known as Cell Icons, are in-cell graphical indicators that provide a sense of scale or value relative to other numbers in your list. As with Data Bars, you can choose to show numbers and icons in the same cell or hide the numbers and only show the icons. By default, Icon Sets group amounts based upon percentages, but you can edit the rule to use percentiles instead. Here are the default percentages that Excel uses and how they’re calculated:

• 67th percent: This calculation takes the form smallest value from the list plus .67 multiplied by (largest value minus smallest value). This is illustrated by the formula =MIN(D8:D27)+0.67*(MAX(D8:D27)-MIN(D8:D27)) in cell C2 of the Cell Icons – Percent worksheet. The MIN function returns the smallest value in a range, while the MAX function returns the largest. As shown in cell D2, this calculates as 72.03%, which means any amounts that are greater than the largest value in the list multiplied by...