1
2/28/20
Excel Charts
2020/02/28
1.Charts i exce
2
1
3
2/28/20
2.1 Cu Chart
• C .
2.1 Cu Chart
4
2
5
2/28/20
2.2 Lie Chart
• L . U , . U (XY ) XY .
2.2 Lie Chart
6
3
7
2/28/20
2.3 Bar Chart
• A bar chart . U .
2.3 Bar Chart
8
4
9
2/28/20
2.4 Pie Chart
• Pie charts () (). P .
2.4 Pie Chart
10
5
11
2/28/20
2.5 Area Chart
• A area chart . U .
2.5 Area Chart
12
6
13
2/28/20
2.6 Scatter Chart
• U scatter chart (XY chart) XY . S ’ X Y.
2.6 Scatter Chart
14
7
15
2/28/20
3.1 Data Series
• A data series. Y .
3.2 Switch Rw/Cu
• Y (B, D, …) (J, F, …).
• I S R/C, ’ 6 (J, F, …) (B, D, …).
16
8
17
2/28/20
3.3 Add, Edit, Reve & Mve Data Series
• Y S D S , , , ’ .
• 1. S .
• 2. S .
3.4 Axes
• M : ( -) ( -). T , .
18
9
19
2/28/20
3.4 Axes
E 8/24/2018 9/1/2018. T , D T .
3.5 Axis Tite
• T , .
• 1. S .
• 2. C + , A T P V
3. E . F , V.
20
10
21
2/28/20
3.6 Axis Scae
• B , E . T , .
• 1. R , F A.
• 2. F 10000.
• 3. F 2000.
3.7 Chart Sheet
• S ( ). H, move a chart (chart sheet).
• T , .
• 1. S .
• 2. O D , L , M C.
• 3. C N .
• 4. C OK.
22
11
23
2/28/20
3.7 Chart Sheet
3.8 Tred Lie
• 1. Seec he cha.
• 2. Cic he + b he igh ide f he cha, cic he a e Tedie ad he cic Me Oi.
• 3. Che a Ted/Regei e. Cic Liea.
• 4. Secif he be f eid icde i he feca. Te 3 i he Fad b.
• 5. Chec “Dia Eai cha” ad “Dia R-aed ae cha”.
24
12
25
2/28/20
3.9 Errr Bar
3.10 Saries
• S E .
• 1. S . I , G2:G4.
• 2. O I , S , L.
• 3. C D R A2:F4.
26
13
27
2/28/20
3.10 Saries
3.11 Cbiati Chart
• A .
28
14
29
2/28/20
4.1 Gauge Chart
• A gauge chart ( ) D P .
• 1. S H2:I6.
• 2. O I , C , C .
• 3. C C C C C.
4.1 Gauge Chart
• 4. F D , D ( P) .
• 5. F P , P .
• 6. P P .
30
15
31
2/28/20
4.1 Gauge Chart
• 7. C OK.
• 8. R .
• 9. S . O F , C S , P .
• 10. O F , C S , F S 270 .
4.1 Gauge Chart
• 11. H CTRL ← → . O F , S S , S F . P 1 = N F, 2 = 3 = N F.
• 12. R 9 11 D . P 1 = , 2 = , 3 = 4 = N F.
32
16
33
2/28/20
4.1 Gauge Chart
• 13. Seec he cha. O he Fa ab, i he Ce Seeci g, eec he Cha Aea. I he Shae Se g, chage he Shae Fi N fi ad he Shae Oie N Oie.
• 14. Ue he Si B chage he ae i ce I3 f 75 76. The Pie cha chage a aae ice f 76 i, a bac ice f 1 i (he eede), ad a aae ice f 200 – 1 – 76 = 123 i. The fa i ce I5 ee ha he 3 ice 200 i.
4.2 Gatt Chart
• Excel G , ’ Gantt chart .
• 1. S A3:C11.
• 2. O I , C , C .
34
17
35
2/28/20
4.2 Gatt Chart
• 3. C S B.
• 4. E C T. F , B H.
• 5. C D.
• 6. T (F, W, .) . R , F A ‘C ’.
4.2 Gatt Chart
• 7. R , F D S, F & L , F, N .
• 8. D E J 0, 1900. 1--2020 () 42887. 15--2020 () 44027. R , F A 42887, 42931 M 7.
36
18
37
2/28/20
4.2 Gatt Chart
4.3 Stc chart
• D ///
38
19
2/28/20
4.3 Stc chart: Cadestic t
39
20