01:47:00
การ สร้าง Chart แบบ Scatter with smooth lines Amazing chart 2
Scatter with smooth lines แบบที่ 2 นี้สวยงามทีเดียว ซึ่ง หากใครที่ชื่นชอบความสวยงามแล้วละก็ การใส่ค่าตัวเลขเพื่อเล่นกับรูปทรงของ Chart นับเป็นเรื่องที่ให้ความสนุก ความบันเทิงให้กับเราได้ไม่น้อยเลย
วิธีการทำ Scatter With Smooth lines Amazing chart 2
1. เปิด Microsoft Excel ขึ้นมา
2. พิมพ์ค่าตั้งแต่ A1 จนถึง B377 ดังต่อไปนี้
|
A
|
B
|
|
1
|
0
|
|
134.3013
|
252.3804
|
|
505.839
|
809.0697
|
|
784.5808
|
985.6048
|
|
327.6368
|
495.4508
|
|
-1076.87
|
-221.312
|
|
-2684.33
|
-486.789
|
|
-3169.92
|
-199.593
|
|
-1739.34
|
-72.3512
|
|
1003.476
|
-912.42
|
|
3336.881
|
-2567.12
|
|
3760.769
|
-3645.41
|
|
2266.593
|
-2529.93
|
|
343.1608
|
1040.083
|
|
-397.116
|
5259.488
|
|
221.5348
|
7293.254
|
|
688.7294
|
5429.329
|
|
-733.832
|
595.1732
|
|
-4058.64
|
-4165.81
|
|
-6982.32
|
-5994.45
|
|
-6481.35
|
-4434.99
|
|
-1471.17
|
-1651.01
|
|
5745.352
|
-371.245
|
|
10727.12
|
-1317.57
|
|
10110.25
|
-2450.55
|
|
4261.167
|
-873.943
|
|
-2899.82
|
4145.999
|
|
-6911.31
|
9778.815
|
|
-6206.38
|
11390.59
|
|
-3088.57
|
6309.25
|
|
-1381.46
|
-3494.44
|
|
-2761.29
|
-12275.1
|
|
-5036.29
|
-14555.3
|
|
-4064.26
|
-9228.75
|
|
2180.356
|
-357.969
|
|
10951.82
|
6089.008
|
|
16105.39
|
6934.776
|
|
12766.03
|
4015.079
|
|
1590.069
|
2045.161
|
|
-11060.5
|
3971.607
|
|
-17511.5
|
7915.337
|
|
-14404.5
|
8573.667
|
|
-5035.34
|
2118.243
|
|
3541.621
|
-9581.04
|
|
6275.566
|
-19313.9
|
|
3939.116
|
-19667
|
|
1789.908
|
-8997.49
|
|
4248.924
|
6716.003
|
|
10279.81
|
17948.74
|
|
13707.54
|
18584.99
|
|
8535.784
|
10213.29
|
|
-5127.63
|
289.1581
|
|
-19793.3
|
-4269.59
|
|
-25559.5
|
-2661.55
|
|
-17663.5
|
-232.001
|
|
-516.309
|
-2953.48
|
|
15270.48
|
-11196
|
|
20696.99
|
-18419
|
|
14816.55
|
-16326.9
|
|
4632.425
|
-2400.07
|
|
-1341.12
|
16662.53
|
|
-353.672
|
28965.95
|
|
2683.131
|
26128.93
|
|
309.3359
|
9792.86
|
|
-9805.31
|
-9449.06
|
|
-21473.4
|
-20014.7
|
|
-24279.9
|
-17836
|
|
-12369.2
|
-8556.64
|
|
9593.156
|
-1790.96
|
|
28659.52
|
-2448.58
|
|
32779.51
|
-6605.68
|
|
19787.23
|
-5536.06
|
|
-1058.79
|
5536.688
|
|
-16315
|
21673.51
|
|
-18540.9
|
30880.78
|
|
-11175.4
|
23554.24
|
|
-4272.41
|
1062.467
|
|
-4937
|
-23914.1
|
|
-10792.4
|
-36126.7
|
|
-12239.9
|
-28901
|
|
-1709.86
|
-8800.69
|
|
18108.37
|
9939.831
|
|
34554.81
|
16638.97
|
|
34280.98
|
11850.08
|
|
14253.86
|
5312.674
|
|
-14684.1
|
6195.924
|
|
-35083.1
|
14208.82
|
|
-35532.9
|
19457.54
|
|
-18679.7
|
11449.5
|
|
1753.734
|
-10379.9
|
|
12354.65
|
-33947.7
|
|
10348.17
|
-42666
|
|
4384.391
|
-28336.5
|
|
5409.854
|
1677.994
|
|
15710.1
|
29183.09
|
|
25856.49
|
38360.08
|
|
22597.11
|
27023.23
|
|
1236.092
|
6999.137
|
|
-28200.2
|
-6405.74
|
|
-46916.9
|
-6924.64
|
|
-41287.4
|
-1382.23
|
|
-13691.6
|
-2074.63
|
|
18709.67
|
-14271.7
|
|
36584.25
|
-29932.7
|
|
32444.29
|
-33564
|
|
14914.06
|
-15731
|
|
118.3755
|
17166.89
|
|
-2305.63
|
45646.18
|
|
3294.294
|
51002.37
|
|
3830.859
|
29481.43
|
|
-9229.5
|
-4700.29
|
|
-30271.1
|
-30097
|
|
-42460.7
|
-33976.5
|
|
-31426.5
|
-20683.1
|
|
1536.084
|
-5958.45
|
|
38146.73
|
-2427.35
|
|
55631.28
|
-8756.59
|
|
43489.62
|
-11750.4
|
|
11173.53
|
483.0159
|
|
-19534.4
|
25826.45
|
|
-31261.7
|
47381.63
|
|
-23344.7
|
46161.52
|
|
-9931.71
|
17177.73
|
|
-6036.27
|
-24579.6
|
|
-13746.7
|
-53896.2
|
|
-20560.5
|
-53588.4
|
|
-11379.8
|
-26838.5
|
|
16176.65
|
6205.798
|
|
46728.22
|
24636.95
|
|
57581.73
|
22479.04
|
|
36778.36
|
11178.22
|
|
-6036.9
|
7375.533
|
|
-45340.6
|
16847.16
|
|
-58064
|
28693.25
|
|
-40129.6
|
25069.3
|
|
-8093.58
|
-1699.38
|
|
15100.72
|
-39520.7
|
|
18311.7
|
-63492.8
|
|
9360.421
|
-54656.6
|
|
5646.691
|
-15539.2
|
|
16748.48
|
30464.37
|
|
34361.59
|
55909.01
|
|
38706.35
|
49128.61
|
|
16366.91
|
21360.46
|
|
-25642.9
|
-4161.59
|
|
-62225.1
|
-11701.4
|
|
-68148.9
|
-4775.35
|
|
-37577.6
|
-610.674
|
|
10716.2
|
-12530.5
|
|
47017.28
|
-35856.8
|
|
52477.69
|
-50054.5
|
|
31706.42
|
-35999.9
|
|
6410.168
|
5974.29
|
|
-4009.27
|
52950.56
|
|
1647.377
|
74935.34
|
|
7286.215
|
57213.59
|
|
-3905.64
|
11662.29
|
|
-31871.5
|
-32245.7
|
|
-56844
|
-49613.7
|
|
-54609.7
|
-37673.3
|
|
-17624.2
|
-14887.5
|
|
35897.52
|
-3133.47
|
|
73416.41
|
-8469.67
|
|
71691.76
|
-16903.8
|
|
33924.13
|
-8623.91
|
|
-13327.1
|
21795.12
|
|
-40882.8
|
57142.96
|
|
-38486.7
|
69371.88
|
|
-19896.8
|
42480.06
|
|
-8122.82
|
-12421.7
|
|
-13977.4
|
-63007.9
|
|
-26529.4
|
-78777.3
|
|
-23732
|
-53196.8
|
|
5926.073
|
-7358.58
|
|
49716.81
|
27510.96
|
|
77635.15
|
34203.23
|
|
65421.38
|
20680.01
|
|
15089.33
|
9694.546
|
|
-44303
|
16487.29
|
|
-77112.5
|
34119.82
|
|
-66898.6
|
39376.46
|
|
-27121.5
|
14442.58
|
|
11431.85
|
-34317.5
|
|
25720.34
|
-77343.7
|
|
17258.24
|
-83194.4
|
|
7196.628
|
-43474
|
|
14679
|
19069.27
|
|
37631.77
|
66460.12
|
|
53044.8
|
73128.68
|
|
37092.46
|
43360.62
|
|
-11847.2
|
5006.745
|
|
-67409.9
|
-14644.1
|
|
-92928.7
|
-10465.6
|
|
-69189.2
|
-770.093
|
|
-9930.18
|
-7894.81
|
|
47791.05
|
-35392.2
|
|
70968.18
|
-62110.1
|
|
53959.76
|
-59107.5
|
|
19412.3
|
-15640.5
|
|
-3029.69
|
47975.28
|
|
-1837.97
|
92583.6
|
|
8600.594
|
88785.86
|
|
3648.694
|
39271.14
|
|
-26447.5
|
-23196.3
|
|
-64248.4
|
-60642.4
|
|
-77238.8
|
-57619.4
|
|
-45116.1
|
-29735.3
|
|
20508.83
|
-6966.25
|
|
81305.07
|
-6630.59
|
|
99399.67
|
-19186.2
|
|
65317.23
|
-18782
|
|
4371.052
|
10830.85
|
|
-43514.4
|
57854.41
|
|
-54068.6
|
88360.06
|
|
-34611.7
|
72916.01
|
|
-13465.3
|
12282.06
|
|
-12830.5
|
-59634.8
|
|
-28755
|
-99186.5
|
|
-35462.9
|
-84720.3
|
|
-10305.6
|
-31490.8
|
|
42389.1
|
21905.08
|
|
89951.98
|
44118.56
|
|
95208.86
|
33601.71
|
|
46730.1
|
15216.68
|
|
-29530.5
|
14924.37
|
|
-87632.4
|
34927.7
|
|
-94899.8
|
51015.79
|
|
-54752.2
|
34728.55
|
|
-1237.69
|
-18595.3
|
|
29545.85
|
-80540.7
|
|
27281.63
|
-108528
|
|
11854.66
|
-78646.2
|
|
11715.98
|
-5816.39
|
|
35593.51
|
65688.08
|
|
62505.32
|
94428.04
|
|
59340.26
|
71242.18
|
|
11462.8
|
22773.46
|
|
-60020.5
|
-12817.2
|
|
-110293
|
-17167.1
|
|
-103863
|
-4015.08
|
|
-42349.5
|
-2935.76
|
|
35698.31
|
-29322
|
|
83261.5
|
-67194.1
|
|
78972.38
|
-80557
|
|
39842.32
|
-44558.7
|
|
3303.696
|
29802.1
|
|
-5473.98
|
99242.54
|
|
6716.711
|
118808.2
|
|
10612.3
|
75658.27
|
|
-15700.3
|
-1130.3
|
|
-63016.8
|
-62777.1
|
|
-94802.5
|
-77176.2
|
|
-76653.5
|
-50303.4
|
|
-7248.61
|
-16208.1
|
|
75708.88
|
-5250.16
|
|
121030.6
|
-18027.9
|
|
101562.8
|
-27077.6
|
|
33868.5
|
-4466.38
|
|
-35603.2
|
48996.8
|
|
-66428.9
|
99050.14
|
|
-53069
|
103397.9
|
|
-23880.2
|
47088.28
|
|
-12569.1
|
-41683.3
|
|
-27243
|
-109592
|
|
-43772.8
|
-116690
|
|
-29135.6
|
-65023.1
|
|
25531.98
|
5263.868
|
|
91333.56
|
48566.6
|
|
120723.6
|
48277.84
|
|
84962.83
|
25250.91
|
|
-651.086
|
14604.18
|
|
-85268.2
|
31780.06
|
|
-118960
|
57545.6
|
|
-88516.9
|
55208.95
|
|
-24314.5
|
5504.765
|
|
26412.09
|
-71145
|
|
37276.47
|
-125442
|
|
20403.33
|
-116008
|
|
10409.36
|
-42792.4
|
|
29626.52
|
50519.81
|
|
65264.86
|
107901.9
|
|
78901.28
|
101525.7
|
|
40882.68
|
49364.17
|
|
-39653
|
-3345.63
|
|
-115761
|
-22405.2
|
|
-135905
|
-10593.3
|
|
-83501.8
|
-208.988
|
|
9224.688
|
-19758.6
|
|
84757.79
|
-64350.1
|
|
102620.1
|
-96255.4
|
|
66820.86
|
-76347.2
|
|
17216.86
|
-307.524
|
|
-6617.7
|
91643.19
|
|
1928.743
|
141497.1
|
|
14550.35
|
116444.1
|
|
-2429.24
|
33795.19
|
|
-53262.6
|
-52345.1
|
|
-103734
|
-91972.8
|
|
-107138
|
-74770.5
|
|
-44486.9
|
-32358.4
|
|
54936.63
|
-7010.34
|
|
131282.2
|
-14273.4
|
|
137375.7
|
-31353.4
|
|
73393.96
|
-20731.5
|
|
-14694
|
31876.81
|
|
-71337.4
|
98800.05
|
|
-72726.8
|
128623.7
|
|
-40124.6
|
87694.9
|
|
-15806.9
|
-9251.27
|
|
-23395.5
|
-105698
|
|
-46963.2
|
-143436
|
|
-46834.8
|
-104784
|
|
1663.026
|
-23493.7
|
|
80404.99
|
43795.89
|
|
136976.6
|
61695.02
|
|
124441.6
|
39841.64
|
|
40417.63
|
17980.41
|
|
-67154.7
|
26632.06
|
|
-133570
|
57918.13
|
|
-124188
|
72067.05
|
|
-57488.8
|
34361.45
|
|
13308.02
|
-49288.9
|
|
44006.27
|
-129776
|
|
32233.51
|
-149664
|
|
12966.8
|
-88279.1
|
|
22209.17
|
19797.24
|
|
61107
|
108721.3
|
|
92203.94
|
129353.9
|
|
71923.71
|
83191.16
|
|
-8048.19
|
15872.02
|
|
-106460
|
-22945
|
|
-159438
|
-19314.2
|
|
-128475
|
-1585.91
|
|
-30979.5
|
-9633.5
|
|
71743.49
|
-54335.9
|
|
119880.7
|
-103236
|
|
97701.47
|
-106003
|
|
39827.56
|
-39065
|
|
-2222.03
|
68546.94
|
|
-4065.23
|
151574.5
|
|
14028.48
|
155853.5
|
|
10103.58
|
79203.15
|
|
-36794.6
|
-27058.4
|
|
-102019
|
-97273
|
|
-131495
|
-99723.3
|
|
-86596.9
|
-55564
|
|
19575.27
|
-14627.5
|
|
126009.3
|
-10057.8
|
|
166674.5
|
-30724.1
|
|
119095.8
|
-34553.5
|
|
19917.03
|
9341.009
|
|
-64736.9
|
86844.14
|
|
-89733.3
|
143940.3
|
|
-61456
|
128552.2
|
|
-24827.7
|
35239.41
|
|
-19715.1
|
-84918.4
|
|
-44814.9
|
-159155
|
|
-60081.2
|
-145840
|
|
-25454
|
-63488.3
|
|
57848.26
|
26728.37
|
|
140224.1
|
69889.68
|
|
159175.7
|
57486.77
|
|
89599.35
|
26834.45
|
|
-32535.8
|
22278.32
|
|
-133761
|
52687.68
|
|
-156232
|
82351.29
|
|
-98448.9
|
63526.36
|
|
-11678.2
|
-17172.5
|
|
43691.18
|
-119126
|
|
45237.13
|
-173753
|
|
20618.13
|
-136901
|
|
16335.83
|
-25318.2
|
|
51438.23
|
93210.59
|
|
96968.23
|
149121.6
|
|
99788.6
|
120785.1
|
|
31156.82
|
45513.76
|
|
-81647.4
|
-15431.9
|
3. เมื่อพิมพ์เสร็จให้เรา Select Data range ที่จะเอามาทำ chart ด้วยเมาส์โดยเอาตั้งแต่เซลล์ A1 ถึง A377 เสร็จแล้วคลิกที่แท็บ InsertàScatter->Scatter with smooth lines เราก็จะได้ Chart หน้าตาแบบภาพด้านล่างนี้ครับ
