Excel 2010 Bible

Part III: Creating Charts and Graphics

492

FIGURE 20.11

Changing the icon assignment rule.

FIGURE 20.12

Using a modified rule and eliminating an icon makes the table more readable.

Another icon set example

Figure 20.13 shows a table that contains two test scores for each student. The Change column con-

tains a formula that calculates the difference between the two tests. The Trend column uses an icon

set to display the trend graphically.

This example uses the icon set named 3 Arrows, and I customized the rule: