23:48:00
การ สร้าง Chart แบบ Scatter with smooth lines Amazing chart 3
Scatter with smooth lines แบบที่ 3 ในโลกนี้มีสิ่งที่สวยงามอยู่หลายอย่างด้วยกัน สาวงาม, ธรรมชาติสวยสดงดงาม, รูปทรงทางคณิตศาสตร์ที่สวยงาม Excel สามารถแสดง Chart ที่สวยงามจาก Chart ต้นแบบได้หากเราเก่งคณิตศาสตร์และรู้จักที่จะคำนวณค่าต่างๆเพื่อเอามาสร้าง Chart รูปทรงต่างๆได้ตามใจปรารถนา
Chart type แบบ Scatter with smooth lines เพียงตัวเดียวสามารถสร้าง Chart รูปทรงตรงๆได้สวยงามมากมายขึ้นอยู่กับค่าที่เราป้อนเข้าไปครับ
วิธีสร้าง Scatter with smooth lines แบบที่ 3
1. เปิด Excel ขึ้นมา
2. พิมพ์ค่าเหล่านี้ลงไปในเซลล์ A1 ถึง เซลล์ B377
3. คลิกที่ Insert->Scatter->Scatter with smooth lines เราก็จะได้ Chart หน้าตาดังภาพ
Scatter with smooth lines แบบที่ 3 ในโลกนี้มีสิ่งที่สวยงามอยู่หลายอย่างด้วยกัน สาวงาม, ธรรมชาติสวยสดงดงาม, รูปทรงทางคณิตศาสตร์ที่สวยงาม Excel สามารถแสดง Chart ที่สวยงามจาก Chart ต้นแบบได้หากเราเก่งคณิตศาสตร์และรู้จักที่จะคำนวณค่าต่างๆเพื่อเอามาสร้าง Chart รูปทรงต่างๆได้ตามใจปรารถนา
Chart type แบบ Scatter with smooth lines เพียงตัวเดียวสามารถสร้าง Chart รูปทรงตรงๆได้สวยงามมากมายขึ้นอยู่กับค่าที่เราป้อนเข้าไปครับ
วิธีสร้าง Scatter with smooth lines แบบที่ 3
1. เปิด Excel ขึ้นมา
2. พิมพ์ค่าเหล่านี้ลงไปในเซลล์ A1 ถึง เซลล์ B377
A
|
B
|
1
|
0
|
12.4058
|
-19.0732
|
-12.782
|
-58.4548
|
-57.5792
|
-50.2209
|
-61.1846
|
23.36426
|
14.81135
|
107.087
|
130.6172
|
117.7491
|
183.5956
|
26.71751
|
94.46127
|
-98.7474
|
-107.237
|
-143.387
|
-281.774
|
-48.3306
|
-279.741
|
120.079
|
-70.4834
|
208.9104
|
212.0149
|
106.5711
|
358.2229
|
-143.65
|
247.6919
|
-350.709
|
-43.0058
|
-317.137
|
-287.138
|
-10.9368
|
-285.187
|
376.8946
|
-34.6239
|
554.9558
|
252.8228
|
354.8011
|
315.2555
|
-118.389
|
63.55083
|
-539.706
|
-320.978
|
-599.335
|
-510.085
|
-244.403
|
-291.99
|
266.1084
|
232.0022
|
550.261
|
688.9968
|
399.1474
|
704.7764
|
-52.286
|
204.6959
|
-424.44
|
-495.578
|
-396.154
|
-900.459
|
24.70899
|
-702.176
|
487.5246
|
-26.3206
|
570.1605
|
645.1057
|
131.4875
|
829.5327
|
-539.497
|
412.1068
|
-916.849
|
-262.265
|
-643.427
|
-655.333
|
162.4274
|
-461.095
|
953.6435
|
143.7182
|
1143.772
|
632.0461
|
554.8751
|
550.6764
|
-423.536
|
-94.5788
|
-1103.78
|
-808.692
|
-1008
|
-978.239
|
-230.609
|
-367.948
|
630.1919
|
650.044
|
929.7642
|
1336.692
|
475.5183
|
1136.123
|
-323.785
|
120.3027
|
-783.658
|
-1026.27
|
-497.278
|
-1493.49
|
319.9946
|
-948.37
|
980.3225
|
206.6777
|
867.8468
|
1128.596
|
-42.8504
|
1167.642
|
-1114.38
|
357.7149
|
-1504.74
|
-618.947
|
-821.826
|
-972.314
|
532.7648
|
-433.26
|
1618.539
|
525.5196
|
1641.067
|
1061.734
|
555.9841
|
647.8549
|
-876.183
|
-471.672
|
-1643.24
|
-1428.4
|
-1233.51
|
-1393.53
|
-14.3884
|
-252.664
|
1058.043
|
1244.649
|
1180.824
|
2007.07
|
325.2001
|
1419.882
|
-749.602
|
-163.041
|
-1108.22
|
-1646.8
|
-401.798
|
-1991.97
|
824.0441
|
-986.059
|
1536.768
|
599.4657
|
1039.894
|
1594.862
|
-430.485
|
1318.817
|
-1822.99
|
86.19598
|
-2044.38
|
-1057.53
|
-811.696
|
-1172.09
|
1079.819
|
-176.706
|
2305.835
|
1075.183
|
1986.155
|
1473.33
|
349.17
|
558.6786
|
-1426.82
|
-1057.68
|
-2088.49
|
-2119.26
|
-1239.91
|
-1691.2
|
378.9519
|
72.28013
|
1483.059
|
1973.318
|
1247.438
|
2629.204
|
-53.6477
|
1511.268
|
-1276.02
|
-629.474
|
-1330.74
|
-2292.91
|
-81.2664
|
-2332.79
|
1503.891
|
-801.886
|
2087.764
|
1105.635
|
1034.638
|
1973.925
|
-1025.3
|
1243.833
|
-2605.69
|
-380.585
|
-2468.43
|
-1512.22
|
-589.909
|
-1196.3
|
1764.503
|
313.9099
|
2944.229
|
1740.636
|
2130.385
|
1797.688
|
-54.1982
|
250.7836
|
-2013.07
|
-1822.63
|
-2374.49
|
-2811.72
|
-1009.82
|
-1815.76
|
905.9479
|
605.2781
|
1834.891
|
2778.274
|
1087.201
|
3133.473
|
-642.412
|
1382.383
|
-1837.82
|
-1243.74
|
-1390.14
|
-2893.47
|
473.4759
|
-2463.89
|
2309.228
|
-402.888
|
2562.222
|
1664.765
|
815.3075
|
2199.042
|
-1800.95
|
921.4902
|
-3392.94
|
-1001.87
|
-2717.57
|
-1912.09
|
-153.163
|
-999.156
|
2531.498
|
1023.316
|
3462.369
|
2457.074
|
2041.311
|
1970.651
|
-622.826
|
-289.341
|
-2564.31
|
-2718.43
|
-2446.1
|
-3432.86
|
-546.198
|
-1725.72
|
1508.003
|
1324.203
|
2045.027
|
3590.564
|
675.123
|
3457.092
|
-1402.92
|
1024.907
|
-2363.17
|
-1953.41
|
-1236.83
|
-3375.92
|
1250.908
|
-2348.6
|
3175.843
|
183.4925
|
2892.674
|
2206.855
|
363.467
|
2212.156
|
-2712.2
|
350.861
|
-4110.39
|
-1720.67
|
-2745.54
|
-2186.57
|
481.1002
|
-551.572
|
3313.082
|
1916.112
|
3794.47
|
3151.689
|
1705.744
|
1938.372
|
-1307.35
|
-1054.56
|
-3007.09
|
-3681.96
|
-2262.77
|
-3911.98
|
127.1694
|
-1397.3
|
2115.569
|
2187.388
|
2052.349
|
4335.06
|
6.267116
|
3549.276
|
-2279.77
|
451.4283
|
-2779.16
|
-2692.44
|
-837.112
|
-3671.91
|
2218.906
|
-1969.15
|
4030.141
|
910.8743
|
3020.743
|
2657.54
|
-318.781
|
1968.832
|
-3697.74
|
-447.863
|
-4684.53
|
-2467.72
|
-2523.18
|
-2271.14
|
1275.266
|
155.8163
|
4033.939
|
2938.715
|
3885.648
|
3749.08
|
1131.504
|
1662.002
|
-2043.53
|
-2016.74
|
-3270.71
|
-4639.37
|
-1802.27
|
-4186.24
|
966.7509
|
-827.133
|
2653.218
|
3136.041
|
1808.293
|
4936.02
|
-902.984
|
3375.649
|
-3203.92
|
-304.704
|
-3017.47
|
-3385.72
|
-176.57
|
-3722.82
|
3326.296
|
-1328.78
|
4794.439
|
1716.797
|
2902.098
|
2943.762
|
-1208.02
|
1442.359
|
-4684.19
|
-1434.02
|
-5048.4
|
-3166.32
|
-2041.43
|
-2112.64
|
2173.579
|
1110.97
|
4616.648
|
4022.661
|
3696.633
|
4176.993
|
347.7055
|
1121.445
|
-2756.64
|
-3127.9
|
-3292.94
|
-5511.23
|
-1063.33
|
-4205.81
|
1911.763
|
-33.383
|
3045.266
|
4097.953
|
1281.265
|
5322.856
|
-2015.15
|
2921.622
|
-4097.43
|
-1191.01
|
-3019.95
|
-3954.51
|
737.8314
|
-3484.72
|
4505.809
|
-452.441
|
5392.71
|
2526.809
|
2510.547
|
2999.511
|
-2260.24
|
626.7058
|
-5591.05
|
-2548.57
|
-5146.93
|
-3737.92
|
-1313.02
|
-1674.04
|
3105.525
|
2280.23
|
4987.485
|
5089.054
|
3207.506
|
4372.01
|
-596.465
|
317.878
|
-3366.66
|
-4322.8
|
-3025.2
|
-6218.21
|
-66.7211
|
-3938.29
|
2887.967
|
944.4816
|
3221.605
|
4992.278
|
459.987
|
5435.724
|
-3273.37
|
2194.468
|
-4878.87
|
-2138.91
|
-2743.56
|
-4322.19
|
1877.078
|
-2932.47
|
5678.275
|
613.9394
|
5756.394
|
3259.543
|
1840.979
|
2771.267
|
-3413.03
|
-461.876
|
-6336.41
|
-3717.63
|
-4941.74
|
-4108.02
|
-372.574
|
-938.127
|
3990.383
|
3609.612
|
5082.177
|
6053.907
|
2420.205
|
4284.799
|
-1634.42
|
-725.134
|
-3794.11
|
-5522.84
|
-2436.98
|
-6687.05
|
1145.061
|
-3372.1
|
3812.548
|
2047.508
|
3123.336
|
5735.094
|
-644.454
|
5230.555
|
-4604.53
|
1223.937
|
-5469.23
|
-3068.03
|
-2164.51
|
-4420.21
|
3190.975
|
-2062.66
|
6757.797
|
1805.783
|
5829.891
|
3832.45
|
910.9302
|
2222.759
|
-4589.2
|
-1784.75
|
-6842.84
|
-4857.07
|
-4414.87
|
-4211.93
|
724.7203
|
89.98282
|
4742.652
|
5027.583
|
4851.196
|
6834.03
|
1359.604
|
3884.586
|
-2686.14
|
-1962.05
|
-3965.99
|
-6641.04
|
-1519.24
|
-6856.2
|
2509.663
|
-2518.49
|
4599.762
|
3200.478
|
2707.834
|
6245.391
|
-1998.05
|
4683.179
|
-5923.66
|
61.33441
|
-5797.92
|
-3891.44
|
-1281.18
|
-4193.57
|
4610.515
|
-895.138
|
7657.59
|
3043.512
|
5575.361
|
4167.849
|
-239.364
|
1338.716
|
-5701.45
|
-3282.36
|
-7043.36
|
-5878.04
|
-3571.23
|
-4000.16
|
1905.976
|
1381.827
|
5278.033
|
6449.144
|
4264.258
|
7353.091
|
73.04239
|
3162.5
|
-3663.3
|
-3327.31
|
-3821.58
|
-7587.79
|
-286.353
|
-6680.99
|
3948.208
|
-1412.03
|
5167.02
|
4316.393
|
1952.901
|
6451.106
|
-3544.86
|
3792.261
|
-7139.32
|
-1222.93
|
-5808.33
|
-4521.63
|
-115.627
|
-3605.69
|
6051.649
|
526.9888
|
8296.129
|
4237.399
|
4976.509
|
4198.879
|
-1548.48
|
127.3358
|
-6658.08
|
-4877.11
|
-6886.78
|
-6693.12
|
-2439.64
|
-3442.94
|
3084.787
|
2886.116
|
5519.583
|
7781.026
|
3313.689
|
7547.468
|
-1371.7
|
2133.573
|
-4475.07
|
-4738.74
|
-3317.59
|
-8277.05
|
1223.371
|
-6137.78
|
5369.871
|
-109.625
|
5441.007
|
5301.953
|
859.6916
|
6294.808
|
-5209.56
|
2580.787
|
-8159.63
|
-2543.2
|
-5462.73
|
-4876.69
|
1286.456
|
-2642.23
|
7420.243
|
2138.927
|
8603.198
|
5293.314
|
4041.051
|
3874.987
|
-2936.82
|
-1378.74
|
-7369.16
|
-6477.75
|
-6342.32
|
-7222.48
|
-1072.27
|
-2533.62
|
4166.519
|
4530.835
|
5403.638
|
8927.657
|
2016.412
|
7371.492
|
-2889.89
|
837.192
|
-5034.42
|
-6102.25
|
-2432.39
|
-8632.56
|
2948.812
|
-5226.95
|
6677.476
|
1312.152
|
5363.452
|
6063.715
|
-545.807
|
5738.656
|
-6901.38
|
1095.996
|
-8898.61
|
-3803.61
|
-4746.15
|
-4886.53
|
2857.388
|
-1313.53
|
8617.935
|
3857.305
|
8525.454
|
6119.02
|
2801.684
|
3166.551
|
-4311.02
|
-3123.04
|
-7752.85
|
-7984.67
|
-5403.03
|
-7399.97
|
457.5718
|
-1290.6
|
5054.388
|
6226.831
|
4885.128
|
9797.572
|
414.3801
|
6801.719
|
-4384.65
|
-664.055
|
-5264.48
|
-7317.52
|
-1168.98
|
-8593.71
|
4808.72
|
-3974.33
|
7773.77
|
2761.063
|
4896.14
|
6514.545
|
-2212.88
|
4768.281
|
-8519.26
|
-592.318
|
-9282.47
|
-4904.1
|
-3668.83
|
-4498.42
|
4510.675
|
344.4091
|
9548.561
|
5584.652
|
8031.124
|
6630.639
|
1315.432
|
2068.338
|
-5569.41
|
-5027.5
|
-7741.57
|
-9296.21
|
-4087.79
|
-7178.51
|
2059.054
|
242.1516
|
5655.978
|
7872.715
|
3941.902
|
10309.84
|
-1426.63
|
5839.938
|
-5752.75
|
-2287.13
|
-5104.41
|
-8284.42
|
443.5459
|
-8120.61
|
6705.854
|
-2431.13
|
8567.995
|
4134.495
|
4024.853
|
6579.968
|
-4067.87
|
3395.302
|
-9958.02
|
-2395.07
|
-9255.3
|
-5746.9
|
-2267.22
|
-3681.85
|
6145.601
|
2270.643
|
10124.73
|
7215.031
|
7113.511
|
6758.874
|
-338.645
|
601.5123
|
-6608.41
|
-6996.23
|
-7287.45
|
-10315.2
|
-2441.7
|
-6534.43
|
3628.852
|
1996.457
|
5889.783
|
9360.796
|
2577.767
|
10400.14
|
-3419.84
|
4514.66
|
-6891.14
|
-3932.79
|
-4514.63
|
3. คลิกที่ Insert->Scatter->Scatter with smooth lines เราก็จะได้ Chart หน้าตาดังภาพ
