Microsoft Office Tutorials and References
In Depth Information
Formatting—With Conditions
Figure 4–121. Shape of things to come: the same grades, formatted by shape icons
Here the red diamond captures the highest values, the green circles the intermediates, and the
yellow triangles the lowest .
Ratings communicate value relationships through a potpourri of possibilities—stars, bars, pie
charts, etc. Thus if I choose the pie chart option (the second selection, first column), we’ll see (Figure 4–
122):
Figure 4–122. Bite-sized pie charts
You’ll note, by the way, that the various icons don’t portray values in precisely calibrated ways.
Look at the screen shot above, and you’ll see that the 82, 81, 83, and 77 all display a three-quarter-
bl acke n e d pi e . T hat’ s be cause by de faul t Exce l or g an i ze s the data by the i r percentage di str i buti on . In
the case of the pies above, Excel assigns a clear icon to those data that fall below 20% of the highest
value in the data, the one-quarter-filled pie for data that occupy the 21-40% percents, and so on. But in
addition to these initial distributions, Excel enables you to customize your own—first by clicking the
Manage Rules…
Continuing with our grade book: If we leave the pie format in place, select these grades in C9:C18,
and click Manage Rules…, we’ll see this (Figure 4–123):
 
Search JabSto ::




Custom Search