beginning microsoft excel 2010 phần 5

. Màu sắc quy mô: tùy chọn Color Scales Bằng cách chọn tùy chọn thứ hai hàng đầu tiên được gọi là Quy mô màu đỏ-vàng-xanh, và áp dụng nó vào phạm vi của chúng tôi của các cấp, tôi nhận được điều này (hình 4-118) | CHAPTER 4 KEEPING UP APPEARANCES FORMATTING THE WORKSHEET Figure 4-117. Chromatic scales Color Scales options By selecting the second option on the first row called the Red-Yellow-Green Color Scale and applying it to our range of grades I get this Figure 4-118 67 82 73 81 90 90 83 77 61 56 Figure 4-118. Grade values colored by score group In this color scheme Red captures the highest values Yellow the intermediate ones and Green the lowest all in shadings to reflect fine differences in values. The final option Icon Sets supplies the user with a large assortment of symbols with which to format the relationship between values and in a range of ways Figure 4-119 146 CHAPTER 4 KEEPING UP APPEARANCES FORMATTING THE WORKSHEET Figure 4-119. Icon Set options Directional Icon Sets symbolize values by their position in a percentile scale via the designated icons. Thus if I select the first such option and apply it to the grade range the conditional format looks like this Figure 4-120 Figure 4-120. An arrow icon set in action Here we see that the highest scores sport an up arrow the intermediates a flat one and the lower scores a down arrow. Shapes represent values with a trove of shapes. If I apply the second selection in the Shapes first column on the grade range I ll see this Figure 4-121 147 CHAPTER 4 KEEPING UP APPEARANCES FORMATTING THE WORKSHEET 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 4122 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 .