Below, you can see that Wednesday is the busiest day. Calls fall of on Friday for everyone except Missy. Missy is consistently the strongest performer.
Figure 1105 Easily spot trends in the data.
Gotcha: You should not include any total cells in your selection when applying conditional formatting. The relative size of the totals would make all the detail numbers receive small bars. Below, the 904 in cell G6 makes all the cells in B2:F5 look relatively the same.
Figure 1106 Don’t include totals in a visualization.
Additional Details: You can use color scales to apply a mix of colors to a range. Excel offers built-in three-color scales such as red-yellow-green as well as two-color scales. The two-color scales look better than three-color scales when printed in monochrome. You can also use More Rules to design your own color scheme. Below, the largest numbers are in the darker green, and the smallest numbers are in the lighter yellow.
Figure 1107 Each cell is lighter or darker based on size.
The final new visualization is icon sets.
In Excel 2010, there are 20 sets of icons. Some have three symbols, others have four, and some have five. The items in a red box in this figure are new in Excel 2010 and will not render when opened in Excel 2007.
Figure 1108 Twenty icon sets are available.
Note that for many of these sets you need to print in color in order for the reader to differentiate the symbols. If you are printing in monochrome, the arrows or power bars are good choices.
After you choose an icon set, Microsoft will display the icon at the left of each cell. Since numbers are usually right-aligned, the number from B2 and the icon from C2 are too close together and many will think that they go together.
I’ve begun using Ctrl+1 to visit the Format Cells dialog. On the Alignment tab, use a horizontal alignment of Right (Indent). You can then increase the indent to 2 or 3 to move the numbers closer to their icons.
Figure 1109 Indent numbers to move them closer to the icons.
The icons won’t respond to the horizontal alignment of the cell, unless you use Home, Conditional Formatting, Manage Rules, Edit Rule, Show Icon Only. Ironically, when you use this setting, the icon responds to the Left, Center, and Right Align buttons in the Home ribbon!