, . , , , .
, . 9.17. , . , , ? , , .
+/-, (. 9.18). .
, . (Show Details). , , , ( ).
, . , , Access , , .
. , , . .
■ , , . , , . (. 9.19). , , . , , .
. 9.18. "" (+) "" (-) . Accessories. , ( )
. 9.19. , . ,
|
|
■ , . (Drop Filter Fields Here). , . , , .
Access . , , . ProductName (Show Top/Bottom Items). , ( 1, 10, 25 . .) ( 1%, 10% . .). . 9.20 .
/ , (AutoFilter) ( ). , , . . .
/ , , . , , . 9.20, . "/"
ProductName, 1% . ProductCategory, 1% . , , , .
. 9.20. . , ,
, , , Components , , , . ProductCategory, . ProductName, , . Clothing .
, . , , , | → → ( PivotTable Tools | Design → Filter & Sort →AutoFilter).
|
|
Access , . . , , | → → (PivotTable Tools | Design → View → PivotChart View) .
. 9.21. , . . . ( ), ,
, , , . , . 9.21.
| → → (PivotChart Tools | Design → Show/Hide → Legend) (legend box).
, . , , , , . , , . , . 9.21, , Country . , . , .
, . , . (, , ), , , , , .
. . , , .
, , . , (Change Chart Type). . , , . .
■ (stacked bar or column chart) (. 9.22).
|
|
■ , , . (. 9.23).
. 9.22. . . , . . ,
. 9.23. , . , , . ( , , , , )
■ . (. 9.24). |
. 9.24. , . , , ,
. | → → (Properties). (3D View), , .
, Office → ( Office → , , ).
, . , . .
1. - (, Bikes Australia).
2. , . , Bikes
Australia (), Bikes , .
3. | → → (PivotChart Tools | Design → Tools → Property Sheet) .
4. (Border/Fill). , ( ) .
5. , , .
III