Database Reference
In-Depth Information
Any countries with returns less than or equal to 1.1 percent of items shipped is performing
very well and within service commitments and should be displayed on the map as green.
5.
In the
Palette
pane, click the first color (Red).
6.
In the lower-right area of the dialog box, click
Color
.
The Color dialog box is displayed.
7.
Click the
Named Colors
tab.
8.
Click
Green
.
9.
Click
OK
to close the dialog box.
10.
In the
Palette
pane, click the first boundary (33.33).
11.
Change the numeric boundary to
0.011
.
12.
Click the second boundary (66.66).
Any countries with a returned to shipped ratio greater than 1.5 percent are not in compli-
ance with the commitment levels and should be investigated further. These countries
should be displayed as red.
13.
Change the numeric boundary to
0.015
.
14.
In the
Palette
pane, click the last Color (pale green).
15.
Click
Color
to open the Color dialog box.
16.
Click the
Named Colors
tab.
17.
Click
Red
.
The Palette dialog box should look like Figure 2.8.
Even though the boundary numbers have been rounded, they will still work appropri-
ately in the map.
18.
Click
OK
to close the Palette dialog box.
Now that the colors have been set, the ratio numbers should be formatted as a percentage.
19.
Select the
Return/Ship Ratio
in the work area.
20.
In the
Properties
pane, double-click the
Data Format
property.
The Data Format dialog box is displayed.
21.
Change the
Format Type
option to
Percent
.
22.
In the
Properties
pane of the dialog box, change the
No. of decimal places
property to
3
.
23.
Click
OK
to close the dialog box.
Finally, the other map attributes should be changed to match the requirements.
24.
In the
Properties
pane, click
Select Ancestor
.
