.


:




:

































 

 

 

 





, . , , , .

, . 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





:


: 2016-03-28; !; : 452 |


:

:

,
==> ...

802 - | 802 -


© 2015-2024 lektsii.org - -

: 0.031 .