Top/Bottom Rules These rules allow for formatting to be applied to the top or bottom X%, to values above or
below average, or to the top or bottom X items.
Data Bars Data bars shade the background of the cell. The longer the bar, the larger the value in
relation to all other cells in the selected range.
Color Scales Color scales can apply formatting based on the values in the cell, often employing a redyellow-
green format, although this can be modified. The default is to take the highest and
lowest values in the range as the endpoints of the color scheme, but this too can be modified.
Icon Sets Icon sets are very similar to the indicators found in the Dashboard Designer for
PerformancePoint Server. These include stoplights, flags, arrow, and so forth.
Table 9-1 The Various Types of Conditional Formatting that Can Be Applied
C h a p t e r 9 : A n a l y s i s w i t h E x c e l 2 0 0 7 311
other if desired. Figure 9-14 shows just such an example. The date is across the top,
where it has been restricted to just the year 2003 for the sake of simplicity. On the rows
are the sales territories, because the KPI in question, Channel Revenue, was defined
by territory. The first column represents the actual value for 2003, while the second
column represents the goal. The column for the status shows the indicator representing
the health of the KPI. The final column shows the trend for that particular sales territory.
The ability to include KPIs and their associated indicators and trend icons makes the
KPIs built into the cube even more useful.
Pages:
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400