Excel 2007 - 如何製作鐘型圖

2013-08-01 10:22 pm
如何製作鐘型圖.

50.328
46.787
47.574
53.416
60.292
59.602
63.713
55.083
56.116
59.208
57.767
56.335
58.167
59.977
59.977
57.707
53.413
52.777
50.254
46.256
35.888
42.299
39.565
36.783
40.858
32.979
33.497
30.454
34.345
42.549
44.844
43.907
35.810
24.412
24.867
33.602
35.130
36.678
38.244
38.244
38.961
40.366
41.765
44.637
47.682
43.183
43.884
43.884
53.643
52.895
56.268
51.212
51.212
52.713
54.957
60.542
62.219
60.170
50.120
48.615
49.306
44.948
46.816
44.681
41.016
43.705
43.705
39.609
44.076
45.126
40.520
36.263
38.389
34.082
37.759
37.058
39.537
36.925
29.103
27.587
30.294
29.581
30.448
33.488
44.124
44.124
40.355
41.215
40.028
29.438
28.708
31.100
34.802
31.353
34.394
36.591
38.494
37.894
39.319
34.765
34.765
42.710
44.775
34.824
29.253
34.773
37.659
35.529
37.937
35.921
39.062
40.716
40.716
37.282
33.718
39.240
41.198
42.784
42.784
44.252
49.366
42.211
45.387
44.416
45.162
45.516
50.693
52.680
50.519
51.243
65.670
63.034
60.533
56.802
64.527
71.778
70.495
74.923
71.066
73.697
70.951
65.472
61.334
60.939
57.730
58.853


Thank you
更新1:

LuLu: C3代表甚麼呢? Thank you

回答 (2)

2013-08-03 8:12 am
✔ 最佳答案

圖片參考:http://imgcld.yimg.com/8/n/HA09113631/o/20130803000350.jpg


C1:=MIN(A2:A147)
C2:=MAX(A2:A147)
C3:自行依需要輸入
C4:=(C2-C1)/C3
E2:=">="&$C$1+$C$4*(D2-1)
F2:="to <"&MID(E2,3,10)+$C$4
G2:=COUNTIF($A$2:$A$147,E2)-COUNTIF($A$2:$A$147,E3)
H2:=IF(D2=$C$3,G2+G3,IF(D2<$C$3,G2,0))
E2至H2往下複製
最後以H行來製圖



2013-08-03 12:32:36 補充:
c3代表分幾多個bar, 8代表分八條bar(如圖)。
2013-08-02 5:53 am
咁樣得唔得?
1. 將data排序
2. 在另一column 輸入 1, 空格, 2, 空格 (由上至下 )
3. highlight 「1, 空格, 2, 空格」再拉到最底 (變左1,空格,2,空格,......,73,空格)
4. 在另一column輸入 146, 空格, 145, 空格
5. highlight 「146, 空格, 145, 空格 」再拉到最底
6. copy 「146, 空格, 145, 空格 」 果個column
7. 在「1, 空格, 2, 空格」個column, 選擇性貼上, 揀 "運算" 入面既 "加", 咁就會變左「1,146,2,145, ......」
8. 將「1,146,2,145, ......」column 排序, 會變左 1,2,3,....,146 ,而d data都會跟住變左由細到大再到返細
9. 淨係揀data個column, plot 棒形圖等


收錄日期: 2021-04-20 14:06:48
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20130801000051KK00161

檢視 Wayback Machine 備份