A97图形（x，y）坐标 - 怎么做？ [英] A97 graphing (x,y) coord's - how to do it?
问题描述
我在名为tbl800CircleDataPoints的表中有800行。
表中有两个名为[X]和[Y]的数字字段。
两者都是数字（单个）输入字段。
[X]字段中的数据点范围为-2到+2，步进为
0.01。 [Y]字段中的数据点范围为-2到+2，步进
为0.01。对于800条记录中的每条记录，[X] ^ 2 + [Y] ^ 2 = 4.对于一个圆，半径为2，中心@的原点，它设置了一个数据点./ br / >
每次我使用A97图形工具创建图形时，除了显示的圆圈外，我得到的东西是
。我可以轻松地在MSoft Excel中使用
相同的数据创建圆圈。但Access让我感到难过。
有人会告诉我，一步一步我很害怕，如何
指示访问给我一个这些数据点的图表，这些点数将会是一个圆圈吗？
X Y
0.01 1.999975
0.02 1.9999
0.03 1.999775
0.04 1.9996
0.05 1.999375
0.06 1.9991
0.07 1.998775
0.08 1.998399
0.09 1.997974
0.1 1.997498
0.11 1.996973
0.12 1.996397
0.13 1.995771
0.14 1.995094
0.15 1.994367
0.16 1.99359
0.17 1.992762
0.18 1.991884
0.19 1.990955
0.2 1.989975
0.21 1.988944
0.22 1.987863
0.23 1.986731
0.24 1.985548
0.25 1.984313
0.26 1.983028
0.27 1.981691
0.28 1.980303
0.29 1.978863
0.3 1.977372
0。 31 1.975829
0.32 1.974234
0.33 1.972587
0.34 1.970888
0.35 1.969137
0.36 1.967333
0.37 1.965477
0.38 1.963568
0.39 1.961607
0.4 1.959592
0.41 1.957524
0.42 1.955403
0.43 1.953228
0.44 1.951
0.45 1.948717
0.46 1.946381
0.47 1.943991
0.48 1.941546
0.49 1.939046
0.5 1.936492
0.51 1.933882
0.52 1.931217
0.53 1.928497
0.54 1.925721
0.55 1.922888
0.56 1.92
0.57 1.917055
0.58 1.914053
0.59 1.910995
0.6 1.907878
0.61 1.904705
0.62 1.901473
0.63 1.898183
0.64 1.894835
0.65 1.891428
0.66 1.887962
0.67 1.884436
0.68 1.880851
0.69 1.877205
0.7 1.873499
0.71 1.869733
0.72 1.865905
0.73 1.862015
0.74 1.858063
0.75 1.85405
0.76 1.849973
0.77 1.845833
0.78 1.84163
0.79 1.837362
0.8 1.83303
0.81 1.828633
0.82 1.824171
0.83 1.819643
0.84 1.815048
0.85 1.810387
0.86 1.805658
0.87 1.800861
0.88 1.795996
0.89 1.791061
0.9 1.786057
0.91 1.780983
0.92 1.775838
0.93 1.770621
0.94 1.765333
0.95 1.759972
0.96 1.754537
0.97 1.749028
0.98 1.743445
0.99 1.737786
1 1.732051
1.01 1.726239
1.02 1.720349
1.03 1.71438
1.04 1.708333
1.05 1.702204
1.06 1.695995
1.07 1.689704
1.08 1.68333
1.09 1.676872
1.1 1.670329
1.11 1.663701
1.12 1.656985
1.13 1.650182
1.14 1.643289
1.15 1.636307
1.16 1.629233
1.17 1.622067
1.18 1.614807
1.19 1.607451
1.2 1.6
1.21 1.592451
1.22 1.584803
1.23 1.577054
1.24 1.569204
1.25 1.561249
1.26 1.55319
1.27 1.545024
1.28 1.53675
1.29 1.528365
1.3 1.519868
1.31 1.511258
1.32 1.502531
1.33 1.493687
1.34 1.484722
1.35 1.475635
1.36 1.466424
1.37 1.457086
1.38 1.447619
1.39 1.43802
1.4 1.428286
1.41 1.418415
1.42 1.408403
1.43 1.398249
1.44 1.387948
1.45 1.377498
1.46 1.366894
1.47 1.356134
1.48 1.345214
1.49 1.334129
1.5 1.322876
1.51 1.31145
1.52 1.29984 6
1.53 1.288061
1.54 1.276088
1.55 1.263922
1.56 1.251559
1.57 1.238991
1.58 1.226214
1.59 1.213219
1.6 1.2
1.61 1.18655
1.62 1.17286
1.63 1.158922
1.64 1.144727
1.65 1.130265
1.66 1.115527
1.67 1.1005
1.68 1.085173
1.69 1.069533
1.7 1.053565
1.71 1.037256
1.72 1.020588
1.73 1.003544
1.74 0.9861034
1.75 0.9682459
1.76 0.9499474
1.77 0.931182
1.78 0.911921
1.79 0.8921323
1.8 0.8717798
1.81 0.8508231
1.82 0.8292165
1.83 0.8069077
1.84 0.7838367
1.85 0.7599342
1.86 0.735119
1.87 0.7092955
1.88 0.6823489
1.89 0.6541407
1.9 0.6244998
1.91 0.5932116
1.92 0.56
1.93 0.5244998
1.94 0.4862098
1.95 0.4444097
1.96 0.397995
1.97 0.3451087
1.98 0.2821347
1.99 0.1997498
2 0
0.01 -1.999975
0.02 - 1.9999
0.03 -1.999775
0.04 -1.9996
0.05 -1.999375
0.06 -1.9991
0.07 -1.998775
0.08 -1.998399
0.09 -1.997974
0.1 -1.997498
0.11 -1.996973
0.12 -1.996397
0.13 -1.995771
0.14 -1.995094
0.15 -1.994367
0.16 -1.99359
0.17 -1.992762
0.18 -1.991884
0.19 -1.990955
0.2 -1.989975
0.21 -1.988944
0.22 -1.987863
0.23 -1.986731
0.24 -1.985548
0.25 -1.984313
0.26 -1.983028
0.27 -1.981691
0.28 -1.980303
0.29 -1.978863
0.3 -1.977372
0.31 -1.975829
0.32 -1.974234
0.33 -1.972587
0.34 -1.970888
0.35 -1.969137
0.36 -1.967333
0.37 -1.965477
0.38 -1.963568
0.39 -1.961607
0.4 -1.959592
0.41 -1.957524
0.42 -1.955403
0.43 -1.953228
0.44 -1.951
0.45 -1.948717
0.46 -1.946381
0.47 -1.943991
0.48 -1.941546
0.49 -1.939046
0.5 -1.936492
0.51 -1.933882
0.52 -1.931217
0.53 -1.928497
0.54 -1.925721
0.55 -1.922888
0.56 -1.92
0.57 -1.917055
0.58 -1.914053
0.59 -1.910995
0.6 -1.907878
0.61 -1.904705
0.62 -1.901473
0.63 -1.898183
0.64 -1.894835
0.65 -1.891428
0.66 -1.887962
0.67 -1.884436
0.68 - 1.880851
0.69 -1.877205
0.7 -1.873499
0.71 -1.869733
0.72 -1.865905
0.73 -1.862015
0.74 -1.858063
0.75 - 1.85405
0.76 -1.849973
0.77 -1.845833
0.78 -1.84163
0.79 -1.837362
0.8 -1.83303
0.81 -1.828633
0.82 -1.824171
0.83 -1.819643
0.84 -1.815048
0.85 -1.810387
0.86 -1.805658
0.87 -1.800861
0.88 -1.795996
0.89 -1.791061
0.9 -1.786057
0.91 -1.780983
0.92 -1.775838
0.93 -1.770621
0.94 -1.765333
0.95 -1.759972
0.96 -1.754537
0.97 -1.749028
0.98 -1.743445
0.99 -1.737786
1 -1.732051
1.01 -1.726239
1.02 -1.720349
1.03 -1.71438
1.04 -1.708333
1.05 -1.702204
1.06 -1.695995
1.07 -1.689704
1.08 -1.68333
1.09 -1.676872
1.1 -1.670329
1.11 -1.663701
1.12 -1.656985
1.13 -1.650182
1.14 -1.643289
1.15 -1.636307
1.16 -1.629233
1.17 -1.622067
1.18 -1.614807
1.19 -1.607451
1.2 -1.6
1.21 -1.592451
1.22 -1.584803
1.23 -1.577054
1.24 -1.569204
1.25 -1.561249
1.26 -1.55319
1.27 -1.545024
1.28 -1.53675
1.29 -1.528365
1.3 -1.519868
1.31 -1.511258
1.32 -1.502531
1.33 -1.493687
1.34 -1.484722
1.35 -1.475635
1.36 -1.466424
1.37 -1.457086
1.38 -1.447619
1.39 -1.43802
1.4 -1.428286
1.41 - 1.418415
1.42 -1.408403
1.43 -1.398249
1.44 -1.387948
1.45 -1.377498
1.46 -1.366894
1.47 -1.356134
1.48 -1.345214
1.49 -1.334129
1.5 -1.322876
1.51 -1.31145
1.52 -1.299846
1.53 -1.288061
1.54 -1.276088
1.55 -1.263922
1.56 -1.251559
1.57 -1.238991
1.58 -1.226214
1.59 -1.213219
1.6 -1.2
1.61 -1.18655
1.62 -1.17286
1.63 -1.158922
1.64 -1.144727
1.65 -1.130265
1.66 -1.115527
1.67 -1.1005
1.68 -1.085173
1.69 -1.069533
1.7 -1.053565
1.71 -1.037256
1.72 -1.020588
1.73 -1.003544
1.74 -0.9861034
1.75 -0.9682459
1.76 -0.9499474
1.77 -0.931182
1.78 -0.911921
1.79 -0.8921323
1.8 -0.8717798
1.81 -0.8508231
1.82 -0.8292165
1.83 -0.8069077
1.84 -0.7838367
1.85 -0.7599342
1.86 -0.735119
1.87 -0.7092955
1.88 -0.6823489
1.89 -0.6541407
1.9 -0.6244998
1.91 -0.5932116
1.92 -0.56
1.93 -0.5244998
1.94 -0.4862098
1.95 -0.4444097
1.96 - 0.397995
1.97 -0.3451087
1.98 -0.2821347
1.99 -0.1997498
2 0
-0.01 1.999975
-0.02 1.9999
-0.03 1.999775
-0.04 1.9996
-0.05 1.999375
-0.06 1.9991
-0.07 1.998775
-0.08 1.998399
-0.09 1.997974
-0.1 1.997498
-0.11 1.996973
-0.12 1.996397
-0.13 1.995771
-0.14 1.995094
-0.15 1.994367
-0.16 1.99359
-0.17 1.992762
-0.18 1.991884
-0.19 1.990955
-0.2 1.989975
-0.21 1.988944
-0.22 1.987863
-0.23 1.986731
-0.24 1.985548
-0.25 1.984313
-0.2 6 1.983028
-0.27 1.981691
-0.28 1.980303
-0.29 1.978863
-0.3 1.977372
-0.31 1.975829
-0.32 1.974234
-0.33 1.972587
-0.34 1.970888
-0.35 1.969137
-0.36 1.967333
-0.37 1.965477
-0.38 1.963568
-0.39 1.961607
-0.4 1.959592
-0.41 1.957524
-0.42 1.955403
-0.43 1.953228
-0.44 1.951
-0.45 1.948717
-0.46 1.946381
-0.47 1.943991
-0.48 1.941546
-0.49 1.939046
-0.5 1.936492
-0.51 1.933882
-0.52 1.931217
-0.53 1.928497
-0.54 1.925721
-0.55 1.922888
-0.56 1.92
-0.57 1.917055
-0.58 1.914053
-0.59 1.910995
-0.6 1.907878
-0.61 1.904705
-0.62 1.901473
-0.63 1.898183
-0.64 1.894835
- 0.65 1.891428
-0.66 1.887962
-0.67 1.884436
-0.68 1.880851
-0.69 1.877205
-0.7 1.873499
-0.71 1.869733
-0.72 1.865905
-0.73 1.862015
-0.74 1.858063
-0.75 1.85405
-0.76 1.849973
-0.77 1.845833
-0.78 1.84163
-0.79 1.837362
-0.8 1.83303
-0.81 1.828633
-0.82 1.824171
-0.83 1.819643
-0.84 1.815048
-0.85 1.810387
-0.86 1.805658
-0.87 1.800861
-0.88 1.795996
-0.89 1.791061
-0.9 1.786057
-0.91 1.780983
-0.92 1.775838
-0.93 1.770621
-0.94 1.765333
-0.95 1.759972
-0.96 1.754537
-0.97 1.749028
-0.98 1.743445
-0.99 1.737786
-1 1.732051
-1.01 1.726239
-1.02 1.720349
-1.03 1.71438
-1.04 1.708333
-1.05 1.702204
-1.06 1.695995
-1.07 1.689704
-1.08 1.68333
-1.09 1.676872
-1.1 1.670329
-1.11 1.663701
-1.12 1.656985
-1.13 1.650182
-1.14 1.643289
-1.15 1.636307
-1.16 1.629233
-1.17 1.622067
-1.18 1.614807
-1.19 1.607451
-1.2 1.6
-1.21 1.592451
-1.22 1.584803
-1.23 1.577054
-1.24 1.569204
-1.25 1.561249
-1.26 1.55319
-1.27 1.545024
-1.28 1.53675
-1.29 1.528365
-1.3 1.519868
- 1.31 1.511258
-1.32 1.502531
-1.33 1.493687
-1.34 1.484722
-1.35 1.475635
-1.36 1.466424
-1.37 1.457086
-1.38 1.447619
-1.39 1.43802
-1.4 1.428286
-1.41 1.418415
-1.42 1.408403
-1.43 1.398249
-1.44 1.387948
-1.45 1.377498
-1.46 1.366894
-1.47 1.356134
-1.48 1.345214
-1.49 1.334129
-1.5 1.322876
-1.51 1.31145
-1.52 1.299846
-1.53 1.288061
-1.54 1.276088
-1.55 1.263922
-1.56 1.251559
-1.57 1.238991
-1.58 1.226214
-1.59 1.213219
-1.6 1.2
-1.61 1.18655
-1.62 1.17286
-1.63 1.158922
-1.64 1.144727
-1.65 1.130265
-1.66 1.115527
-1.67 1.1005
-1.68 1.085173
-1.69 1.069533
-1.7 1.053565
-1.71 1.037256
-1.72 1.020588
-1.73 1.003544
-1.74 0.9861034
-1.75 0.9682459
-1.76 0.9499474
-1.77 0.931182
-1.78 0.911921
- 1.79 0.8921323
-1.8 0.8717798
-1.81 0.8508231
-1.82 0.8292165
-1.83 0.8069077
-1.84 0.7838367
-1.85 0.7599342
-1.86 0.735119
-1.87 0.7092955
-1.88 0.6823489
-1.89 0.6541407
-1.9 0.6244998
-1.91 0.5932116
-1.92 0.56
-1.93 0.5244998
-1.94 0.4862098
-1.95 0.4444097
-1.96 0.397995
-1.97 0.3451087
-1.98 0.2821347
-1.99 0.1997498
-2 0
-0.01 -1.999975
-0.02 -1.9999
-0.03 -1.999775
-0.04 -1.9996
-0.05 -1.999375
-0.06 -1.9991
-0.07 -1.998775
-0.08 -1.998399
-0.09 -1.997974
-0.1 -1.997498
-0.11 -1.996973
-0.12 -1.996397
-0.13 -1.995771
-0.14 -1.995094
-0.15 -1.994367
-0.16 -1.99359
-0.17 -1.992762
-0.18 -1.991884
-0.19 -1.990955
-0.2 -1.989975
-0.21 -1.988944
-0.22 -1.987863
-0.23 -1.986731
-0.24 -1.985548
-0.25 -1.984313
-0.26 -1.983028
-0.27 -1.981691
-0.28 -1.980303
-0.29 -1.978863
-0.3 -1.977372
-0.31 -1.975829
-0.32 -1.974234
-0.33 -1.972587
-0.34 -1.970888
-0.35 -1.969137
-0.36 -1.967333
-0.37 -1.965477
-0.38 -1.963568
-0.39 -1.961607
-0.4 -1.959592
-0.41 -1.957524
-0.42 -1.955403
-0.43 -1.953228
-0.44 -1.951
-0.45 -1.948717
-0.46 -1.946381
-0.47 -1.943991
-0.48 -1.941546
-0.49 -1.939046
-0.5 -1.936492
-0.51 -1.933882
-0.52 -1.931217
-0.53 -1.928497
-0.54 -1.925721
-0.55 -1.922888
-0.56 -1.92
-0。 57 -1.917055
-0.58 -1.914053
-0.59 -1.910995
-0.6 -1.907878
-0.61 - 1.904705
-0.62 -1.901473
-0.63 -1.898183
-0.64 -1.894835
-0.65 -1.891428
-0.66 -1.887962
-0.67 -1.884436
-0.68 -1.880851
-0.69 -1.877205
-0.7 -1.873499
-0.71 -1.869733
-0.72 -1.865905
-0.73 -1.862015
-0.74 -1.858063
-0.75 -1.85405
-0.76 -1.849973
-0.77 -1.845833
-0.78 -1.84163
-0.79 -1.837362
-0.8 -1.83303
-0.81 -1.828633
- 0.82 -1.824171
-0.83 -1.819643
-0.84 -1.815048
-0.85 -1.810387
-0.86 - 1.805658
-0.87 -1.800861
-0.88 -1.795996
-0.89 -1.791061
-0.9 -1.786057
-0.91 -1.780983
-0.92 -1.775838
-0.93 -1.770621
-0.94 -1.76 5333
-0.95 -1.759972
-0.96 -1.754537
-0.97 -1.749028
-0.98 -1.743445
-0.99 -1.737786
-1 -1.732051
-1.01 -1.726239
-1.02 -1.720349
-1.03 -1.71438
-1.04 -1.708333
-1.05 -1.702204
-1.06 -1.695995
-1.07 -1.689704
-1.08 -1.68333
-1.09 -1.676872
-1.1 -1.670329
-1.11 -1.663701
-1.12 -1.656985
-1.13 -1.650182
-1.14 -1.643289
- 1.15 -1.636307
-1.16 -1.629233
-1.17 -1.622067
-1.18 -1.614807
-1.19 - 1.607451
-1.2 -1.6
-1.21 -1.592451
-1.22 -1.584803
-1.23 -1.577054
-1.24 -1.569204
-1.25 -1.561249
-1.26 -1.55319
-1.27 -1.545024
-1.28 -1.53675
-1.29 -1.528365
-1.3 -1.519868
-1.31 -1.511258
-1.32 -1.502531
-1.33 -1.493687
-1.34 -1.484722
-1.35 -1.475635
-1.36 -1.466424
-1.37 -1.457086
-1.38 -1.447619
-1.39 -1.43802
-1.4 -1.428286
-1.41 -1.418415
-1.42 -1.408403
-1.43 -1.398249
-1.44 -1.387948
-1.45 -1.377498
-1.46 -1.366894
-1.47 -1.356134
-1.48 -1.345214
-1.49 -1.334129
-1.5 -1.322876
-1.51 -1.31145
-1.52 -1.299846
-1.53 -1.288061
-1.54 -1.276088
-1.55 -1.263922
-1.56 -1.251559
-1.57 -1.238991
-1.58 -1.226214
-1.59 -1.213219
-1.6 -1.2
-1.61 -1.18655
-1.62 -1.17286
-1.63 -1.158922
-1.64 -1.144727
-1.65 -1.130265
-1.66 -1.115527
-1.67 -1.1005
-1.68 -1.085173
-1.69 -1.069533
-1.7 -1.053565
-1.71 -1.037256
-1.72 -1.020588
-1.73 -1.003544
-1.74 -0.9861034
-1.75 -0.9682459
-1.76 -0.9499474
-1.77 -0.931182
-1.78 -0.911921
-1.79 -0.8921323
-1.8 -0.8717798
-1.81 -0.8508231
-1.82 -0.8292165
-1.83 -0.8069077
-1.84 -0.7838367
-1.85 -0.7599342
-1.86 -0.735119
-1.87 -0.7092955
-1.88 -0.6823489
-1.89 -0.6541407
-1.9 -0.6244998
-1.91 -0.5932116
-1.92 -0.56
-1.93 -0.5244998
-1.94 -0.4862098
-1.95 -0.4444097
-1.96 -0.397995
-1.97 -0.3451087
-1.98 -0.2821347
-1.99 -0.1997498
-2 0
I have 800 rows in a table named tbl800CircleDataPoints.
There are two number fields named [X] and [Y] in the table.
Both are number (single) Type fields.
The data points in the [X] field range from -2 to +2, stepping by
0.01. The data points in the [Y] field range from -2 to +2, stepping
by 0.01. For each of the 800 records, [X]^2 + [Y]^2 = 4. Its a set
of data points for a circle, radius 2, center @ the origin.
Each time I use A97 graph tool to create a graph, I get something
other than a circle displayed. I can easily create the circle with the
same data in MSoft Excel. But Access has me stumped.
Is there someone who will tell me, step-by-step I''m afraid, how to
instruct Access to draw me a graph of these data points that will
look like a circle?
X Y
0.01 1.999975
0.02 1.9999
0.03 1.999775
0.04 1.9996
0.05 1.999375
0.06 1.9991
0.07 1.998775
0.08 1.998399
0.09 1.997974
0.1 1.997498
0.11 1.996973
0.12 1.996397
0.13 1.995771
0.14 1.995094
0.15 1.994367
0.16 1.99359
0.17 1.992762
0.18 1.991884
0.19 1.990955
0.2 1.989975
0.21 1.988944
0.22 1.987863
0.23 1.986731
0.24 1.985548
0.25 1.984313
0.26 1.983028
0.27 1.981691
0.28 1.980303
0.29 1.978863
0.3 1.977372
0.31 1.975829
0.32 1.974234
0.33 1.972587
0.34 1.970888
0.35 1.969137
0.36 1.967333
0.37 1.965477
0.38 1.963568
0.39 1.961607
0.4 1.959592
0.41 1.957524
0.42 1.955403
0.43 1.953228
0.44 1.951
0.45 1.948717
0.46 1.946381
0.47 1.943991
0.48 1.941546
0.49 1.939046
0.5 1.936492
0.51 1.933882
0.52 1.931217
0.53 1.928497
0.54 1.925721
0.55 1.922888
0.56 1.92
0.57 1.917055
0.58 1.914053
0.59 1.910995
0.6 1.907878
0.61 1.904705
0.62 1.901473
0.63 1.898183
0.64 1.894835
0.65 1.891428
0.66 1.887962
0.67 1.884436
0.68 1.880851
0.69 1.877205
0.7 1.873499
0.71 1.869733
0.72 1.865905
0.73 1.862015
0.74 1.858063
0.75 1.85405
0.76 1.849973
0.77 1.845833
0.78 1.84163
0.79 1.837362
0.8 1.83303
0.81 1.828633
0.82 1.824171
0.83 1.819643
0.84 1.815048
0.85 1.810387
0.86 1.805658
0.87 1.800861
0.88 1.795996
0.89 1.791061
0.9 1.786057
0.91 1.780983
0.92 1.775838
0.93 1.770621
0.94 1.765333
0.95 1.759972
0.96 1.754537
0.97 1.749028
0.98 1.743445
0.99 1.737786
1 1.732051
1.01 1.726239
1.02 1.720349
1.03 1.71438
1.04 1.708333
1.05 1.702204
1.06 1.695995
1.07 1.689704
1.08 1.68333
1.09 1.676872
1.1 1.670329
1.11 1.663701
1.12 1.656985
1.13 1.650182
1.14 1.643289
1.15 1.636307
1.16 1.629233
1.17 1.622067
1.18 1.614807
1.19 1.607451
1.2 1.6
1.21 1.592451
1.22 1.584803
1.23 1.577054
1.24 1.569204
1.25 1.561249
1.26 1.55319
1.27 1.545024
1.28 1.53675
1.29 1.528365
1.3 1.519868
1.31 1.511258
1.32 1.502531
1.33 1.493687
1.34 1.484722
1.35 1.475635
1.36 1.466424
1.37 1.457086
1.38 1.447619
1.39 1.43802
1.4 1.428286
1.41 1.418415
1.42 1.408403
1.43 1.398249
1.44 1.387948
1.45 1.377498
1.46 1.366894
1.47 1.356134
1.48 1.345214
1.49 1.334129
1.5 1.322876
1.51 1.31145
1.52 1.299846
1.53 1.288061
1.54 1.276088
1.55 1.263922
1.56 1.251559
1.57 1.238991
1.58 1.226214
1.59 1.213219
1.6 1.2
1.61 1.18655
1.62 1.17286
1.63 1.158922
1.64 1.144727
1.65 1.130265
1.66 1.115527
1.67 1.1005
1.68 1.085173
1.69 1.069533
1.7 1.053565
1.71 1.037256
1.72 1.020588
1.73 1.003544
1.74 0.9861034
1.75 0.9682459
1.76 0.9499474
1.77 0.931182
1.78 0.911921
1.79 0.8921323
1.8 0.8717798
1.81 0.8508231
1.82 0.8292165
1.83 0.8069077
1.84 0.7838367
1.85 0.7599342
1.86 0.735119
1.87 0.7092955
1.88 0.6823489
1.89 0.6541407
1.9 0.6244998
1.91 0.5932116
1.92 0.56
1.93 0.5244998
1.94 0.4862098
1.95 0.4444097
1.96 0.397995
1.97 0.3451087
1.98 0.2821347
1.99 0.1997498
2 0
0.01 -1.999975
0.02 -1.9999
0.03 -1.999775
0.04 -1.9996
0.05 -1.999375
0.06 -1.9991
0.07 -1.998775
0.08 -1.998399
0.09 -1.997974
0.1 -1.997498
0.11 -1.996973
0.12 -1.996397
0.13 -1.995771
0.14 -1.995094
0.15 -1.994367
0.16 -1.99359
0.17 -1.992762
0.18 -1.991884
0.19 -1.990955
0.2 -1.989975
0.21 -1.988944
0.22 -1.987863
0.23 -1.986731
0.24 -1.985548
0.25 -1.984313
0.26 -1.983028
0.27 -1.981691
0.28 -1.980303
0.29 -1.978863
0.3 -1.977372
0.31 -1.975829
0.32 -1.974234
0.33 -1.972587
0.34 -1.970888
0.35 -1.969137
0.36 -1.967333
0.37 -1.965477
0.38 -1.963568
0.39 -1.961607
0.4 -1.959592
0.41 -1.957524
0.42 -1.955403
0.43 -1.953228
0.44 -1.951
0.45 -1.948717
0.46 -1.946381
0.47 -1.943991
0.48 -1.941546
0.49 -1.939046
0.5 -1.936492
0.51 -1.933882
0.52 -1.931217
0.53 -1.928497
0.54 -1.925721
0.55 -1.922888
0.56 -1.92
0.57 -1.917055
0.58 -1.914053
0.59 -1.910995
0.6 -1.907878
0.61 -1.904705
0.62 -1.901473
0.63 -1.898183
0.64 -1.894835
0.65 -1.891428
0.66 -1.887962
0.67 -1.884436
0.68 -1.880851
0.69 -1.877205
0.7 -1.873499
0.71 -1.869733
0.72 -1.865905
0.73 -1.862015
0.74 -1.858063
0.75 -1.85405
0.76 -1.849973
0.77 -1.845833
0.78 -1.84163
0.79 -1.837362
0.8 -1.83303
0.81 -1.828633
0.82 -1.824171
0.83 -1.819643
0.84 -1.815048
0.85 -1.810387
0.86 -1.805658
0.87 -1.800861
0.88 -1.795996
0.89 -1.791061
0.9 -1.786057
0.91 -1.780983
0.92 -1.775838
0.93 -1.770621
0.94 -1.765333
0.95 -1.759972
0.96 -1.754537
0.97 -1.749028
0.98 -1.743445
0.99 -1.737786
1 -1.732051
1.01 -1.726239
1.02 -1.720349
1.03 -1.71438
1.04 -1.708333
1.05 -1.702204
1.06 -1.695995
1.07 -1.689704
1.08 -1.68333
1.09 -1.676872
1.1 -1.670329
1.11 -1.663701
1.12 -1.656985
1.13 -1.650182
1.14 -1.643289
1.15 -1.636307
1.16 -1.629233
1.17 -1.622067
1.18 -1.614807
1.19 -1.607451
1.2 -1.6
1.21 -1.592451
1.22 -1.584803
1.23 -1.577054
1.24 -1.569204
1.25 -1.561249
1.26 -1.55319
1.27 -1.545024
1.28 -1.53675
1.29 -1.528365
1.3 -1.519868
1.31 -1.511258
1.32 -1.502531
1.33 -1.493687
1.34 -1.484722
1.35 -1.475635
1.36 -1.466424
1.37 -1.457086
1.38 -1.447619
1.39 -1.43802
1.4 -1.428286
1.41 -1.418415
1.42 -1.408403
1.43 -1.398249
1.44 -1.387948
1.45 -1.377498
1.46 -1.366894
1.47 -1.356134
1.48 -1.345214
1.49 -1.334129
1.5 -1.322876
1.51 -1.31145
1.52 -1.299846
1.53 -1.288061
1.54 -1.276088
1.55 -1.263922
1.56 -1.251559
1.57 -1.238991
1.58 -1.226214
1.59 -1.213219
1.6 -1.2
1.61 -1.18655
1.62 -1.17286
1.63 -1.158922
1.64 -1.144727
1.65 -1.130265
1.66 -1.115527
1.67 -1.1005
1.68 -1.085173
1.69 -1.069533
1.7 -1.053565
1.71 -1.037256
1.72 -1.020588
1.73 -1.003544
1.74 -0.9861034
1.75 -0.9682459
1.76 -0.9499474
1.77 -0.931182
1.78 -0.911921
1.79 -0.8921323
1.8 -0.8717798
1.81 -0.8508231
1.82 -0.8292165
1.83 -0.8069077
1.84 -0.7838367
1.85 -0.7599342
1.86 -0.735119
1.87 -0.7092955
1.88 -0.6823489
1.89 -0.6541407
1.9 -0.6244998
1.91 -0.5932116
1.92 -0.56
1.93 -0.5244998
1.94 -0.4862098
1.95 -0.4444097
1.96 -0.397995
1.97 -0.3451087
1.98 -0.2821347
1.99 -0.1997498
2 0
-0.01 1.999975
-0.02 1.9999
-0.03 1.999775
-0.04 1.9996
-0.05 1.999375
-0.06 1.9991
-0.07 1.998775
-0.08 1.998399
-0.09 1.997974
-0.1 1.997498
-0.11 1.996973
-0.12 1.996397
-0.13 1.995771
-0.14 1.995094
-0.15 1.994367
-0.16 1.99359
-0.17 1.992762
-0.18 1.991884
-0.19 1.990955
-0.2 1.989975
-0.21 1.988944
-0.22 1.987863
-0.23 1.986731
-0.24 1.985548
-0.25 1.984313
-0.26 1.983028
-0.27 1.981691
-0.28 1.980303
-0.29 1.978863
-0.3 1.977372
-0.31 1.975829
-0.32 1.974234
-0.33 1.972587
-0.34 1.970888
-0.35 1.969137
-0.36 1.967333
-0.37 1.965477
-0.38 1.963568
-0.39 1.961607
-0.4 1.959592
-0.41 1.957524
-0.42 1.955403
-0.43 1.953228
-0.44 1.951
-0.45 1.948717
-0.46 1.946381
-0.47 1.943991
-0.48 1.941546
-0.49 1.939046
-0.5 1.936492
-0.51 1.933882
-0.52 1.931217
-0.53 1.928497
-0.54 1.925721
-0.55 1.922888
-0.56 1.92
-0.57 1.917055
-0.58 1.914053
-0.59 1.910995
-0.6 1.907878
-0.61 1.904705
-0.62 1.901473
-0.63 1.898183
-0.64 1.894835
-0.65 1.891428
-0.66 1.887962
-0.67 1.884436
-0.68 1.880851
-0.69 1.877205
-0.7 1.873499
-0.71 1.869733
-0.72 1.865905
-0.73 1.862015
-0.74 1.858063
-0.75 1.85405
-0.76 1.849973
-0.77 1.845833
-0.78 1.84163
-0.79 1.837362
-0.8 1.83303
-0.81 1.828633
-0.82 1.824171
-0.83 1.819643
-0.84 1.815048
-0.85 1.810387
-0.86 1.805658
-0.87 1.800861
-0.88 1.795996
-0.89 1.791061
-0.9 1.786057
-0.91 1.780983
-0.92 1.775838
-0.93 1.770621
-0.94 1.765333
-0.95 1.759972
-0.96 1.754537
-0.97 1.749028
-0.98 1.743445
-0.99 1.737786
-1 1.732051
-1.01 1.726239
-1.02 1.720349
-1.03 1.71438
-1.04 1.708333
-1.05 1.702204
-1.06 1.695995
-1.07 1.689704
-1.08 1.68333
-1.09 1.676872
-1.1 1.670329
-1.11 1.663701
-1.12 1.656985
-1.13 1.650182
-1.14 1.643289
-1.15 1.636307
-1.16 1.629233
-1.17 1.622067
-1.18 1.614807
-1.19 1.607451
-1.2 1.6
-1.21 1.592451
-1.22 1.584803
-1.23 1.577054
-1.24 1.569204
-1.25 1.561249
-1.26 1.55319
-1.27 1.545024
-1.28 1.53675
-1.29 1.528365
-1.3 1.519868
-1.31 1.511258
-1.32 1.502531
-1.33 1.493687
-1.34 1.484722
-1.35 1.475635
-1.36 1.466424
-1.37 1.457086
-1.38 1.447619
-1.39 1.43802
-1.4 1.428286
-1.41 1.418415
-1.42 1.408403
-1.43 1.398249
-1.44 1.387948
-1.45 1.377498
-1.46 1.366894
-1.47 1.356134
-1.48 1.345214
-1.49 1.334129
-1.5 1.322876
-1.51 1.31145
-1.52 1.299846
-1.53 1.288061
-1.54 1.276088
-1.55 1.263922
-1.56 1.251559
-1.57 1.238991
-1.58 1.226214
-1.59 1.213219
-1.6 1.2
-1.61 1.18655
-1.62 1.17286
-1.63 1.158922
-1.64 1.144727
-1.65 1.130265
-1.66 1.115527
-1.67 1.1005
-1.68 1.085173
-1.69 1.069533
-1.7 1.053565
-1.71 1.037256
-1.72 1.020588
-1.73 1.003544
-1.74 0.9861034
-1.75 0.9682459
-1.76 0.9499474
-1.77 0.931182
-1.78 0.911921
-1.79 0.8921323
-1.8 0.8717798
-1.81 0.8508231
-1.82 0.8292165
-1.83 0.8069077
-1.84 0.7838367
-1.85 0.7599342
-1.86 0.735119
-1.87 0.7092955
-1.88 0.6823489
-1.89 0.6541407
-1.9 0.6244998
-1.91 0.5932116
-1.92 0.56
-1.93 0.5244998
-1.94 0.4862098
-1.95 0.4444097
-1.96 0.397995
-1.97 0.3451087
-1.98 0.2821347
-1.99 0.1997498
-2 0
-0.01 -1.999975
-0.02 -1.9999
-0.03 -1.999775
-0.04 -1.9996
-0.05 -1.999375
-0.06 -1.9991
-0.07 -1.998775
-0.08 -1.998399
-0.09 -1.997974
-0.1 -1.997498
-0.11 -1.996973
-0.12 -1.996397
-0.13 -1.995771
-0.14 -1.995094
-0.15 -1.994367
-0.16 -1.99359
-0.17 -1.992762
-0.18 -1.991884
-0.19 -1.990955
-0.2 -1.989975
-0.21 -1.988944
-0.22 -1.987863
-0.23 -1.986731
-0.24 -1.985548
-0.25 -1.984313
-0.26 -1.983028
-0.27 -1.981691
-0.28 -1.980303
-0.29 -1.978863
-0.3 -1.977372
-0.31 -1.975829
-0.32 -1.974234
-0.33 -1.972587
-0.34 -1.970888
-0.35 -1.969137
-0.36 -1.967333
-0.37 -1.965477
-0.38 -1.963568
-0.39 -1.961607
-0.4 -1.959592
-0.41 -1.957524
-0.42 -1.955403
-0.43 -1.953228
-0.44 -1.951
-0.45 -1.948717
-0.46 -1.946381
-0.47 -1.943991
-0.48 -1.941546
-0.49 -1.939046
-0.5 -1.936492
-0.51 -1.933882
-0.52 -1.931217
-0.53 -1.928497
-0.54 -1.925721
-0.55 -1.922888
-0.56 -1.92
-0.57 -1.917055
-0.58 -1.914053
-0.59 -1.910995
-0.6 -1.907878
-0.61 -1.904705
-0.62 -1.901473
-0.63 -1.898183
-0.64 -1.894835
-0.65 -1.891428
-0.66 -1.887962
-0.67 -1.884436
-0.68 -1.880851
-0.69 -1.877205
-0.7 -1.873499
-0.71 -1.869733
-0.72 -1.865905
-0.73 -1.862015
-0.74 -1.858063
-0.75 -1.85405
-0.76 -1.849973
-0.77 -1.845833
-0.78 -1.84163
-0.79 -1.837362
-0.8 -1.83303
-0.81 -1.828633
-0.82 -1.824171
-0.83 -1.819643
-0.84 -1.815048
-0.85 -1.810387
-0.86 -1.805658
-0.87 -1.800861
-0.88 -1.795996
-0.89 -1.791061
-0.9 -1.786057
-0.91 -1.780983
-0.92 -1.775838
-0.93 -1.770621
-0.94 -1.765333
-0.95 -1.759972
-0.96 -1.754537
-0.97 -1.749028
-0.98 -1.743445
-0.99 -1.737786
-1 -1.732051
-1.01 -1.726239
-1.02 -1.720349
-1.03 -1.71438
-1.04 -1.708333
-1.05 -1.702204
-1.06 -1.695995
-1.07 -1.689704
-1.08 -1.68333
-1.09 -1.676872
-1.1 -1.670329
-1.11 -1.663701
-1.12 -1.656985
-1.13 -1.650182
-1.14 -1.643289
-1.15 -1.636307
-1.16 -1.629233
-1.17 -1.622067
-1.18 -1.614807
-1.19 -1.607451
-1.2 -1.6
-1.21 -1.592451
-1.22 -1.584803
-1.23 -1.577054
-1.24 -1.569204
-1.25 -1.561249
-1.26 -1.55319
-1.27 -1.545024
-1.28 -1.53675
-1.29 -1.528365
-1.3 -1.519868
-1.31 -1.511258
-1.32 -1.502531
-1.33 -1.493687
-1.34 -1.484722
-1.35 -1.475635
-1.36 -1.466424
-1.37 -1.457086
-1.38 -1.447619
-1.39 -1.43802
-1.4 -1.428286
-1.41 -1.418415
-1.42 -1.408403
-1.43 -1.398249
-1.44 -1.387948
-1.45 -1.377498
-1.46 -1.366894
-1.47 -1.356134
-1.48 -1.345214
-1.49 -1.334129
-1.5 -1.322876
-1.51 -1.31145
-1.52 -1.299846
-1.53 -1.288061
-1.54 -1.276088
-1.55 -1.263922
-1.56 -1.251559
-1.57 -1.238991
-1.58 -1.226214
-1.59 -1.213219
-1.6 -1.2
-1.61 -1.18655
-1.62 -1.17286
-1.63 -1.158922
-1.64 -1.144727
-1.65 -1.130265
-1.66 -1.115527
-1.67 -1.1005
-1.68 -1.085173
-1.69 -1.069533
-1.7 -1.053565
-1.71 -1.037256
-1.72 -1.020588
-1.73 -1.003544
-1.74 -0.9861034
-1.75 -0.9682459
-1.76 -0.9499474
-1.77 -0.931182
-1.78 -0.911921
-1.79 -0.8921323
-1.8 -0.8717798
-1.81 -0.8508231
-1.82 -0.8292165
-1.83 -0.8069077
-1.84 -0.7838367
-1.85 -0.7599342
-1.86 -0.735119
-1.87 -0.7092955
-1.88 -0.6823489
-1.89 -0.6541407
-1.9 -0.6244998
-1.91 -0.5932116
-1.92 -0.56
-1.93 -0.5244998
-1.94 -0.4862098
-1.95 -0.4444097
-1.96 -0.397995
-1.97 -0.3451087
-1.98 -0.2821347
-1.99 -0.1997498
-2 0
推荐答案
2005年7月30日星期六11： 30:17 -0400，MLH< CR ** @ NorthState.net>写道：
On Sat, 30 Jul 2005 11:30:17 -0400, MLH <CR**@NorthState.net> wrote:
我在一个名为tbl800CircleDataPoints的表中有800行。
表中有两个名为[X]和[Y]的数字字段。
两者都有是数字（单个）类型字段。
[X]字段中的数据点范围为-2到+2，步进为
0.01。 [Y]字段中的数据点范围为-2到+2，步进为0.01。对于800条记录中的每条记录，[X] ^ 2 + [Y] ^ 2 = 4.它是一组圆形的数据点，半径为2，中心为原点。
每次我使用A97图形工具创建图形时，除了显示的圆圈外，我还会得到一些
。我可以使用MSoft Excel中的相同数据轻松创建圆圈。 Access让我感到难过。
有人会告诉我，一步一步我很害怕，如何指示Access为我绘制这些数据点的图表这将是一个圆圈吗？
X Y
0.01 1.999975
< big snip>
你好
这是最近做的类似查询和我的回复，希望它有帮助
David
On Sun，2005年7月10日14:42:24 - 0400，Claus Haslauer
< ch ****** @ scimail.uwaterloo.ca>写道：
I have 800 rows in a table named tbl800CircleDataPoints.
There are two number fields named [X] and [Y] in the table.
Both are number (single) Type fields.
The data points in the [X] field range from -2 to +2, stepping by
0.01. The data points in the [Y] field range from -2 to +2, stepping
by 0.01. For each of the 800 records, [X]^2 + [Y]^2 = 4. Its a set
of data points for a circle, radius 2, center @ the origin.
Each time I use A97 graph tool to create a graph, I get something
other than a circle displayed. I can easily create the circle with the
same data in MSoft Excel. But Access has me stumped.
Is there someone who will tell me, step-by-step I''m afraid, how to
instruct Access to draw me a graph of these data points that will
look like a circle?
X Y
0.01 1.999975 <big snip>
Hi
Here is a similar query made recently and my reply, hope it helps
David
On Sun, 10 Jul 2005 14:42:24 -0400, Claus Haslauer
<ch******@scimail.uwaterloo.ca> wrote:
我想创建一个图表
值（y轴）与时间（x轴）。实际上非常类似于graph10.chm帮助文件中的
xy（scatter）示例。
我遇到了问题，所以我启动了一个非常基本的* .mdb文件。它包含一个带ID，日期和价格的表格（值）栏目
ID自动分配
日期是短日期格式
和价格是一个长整数
我输入了10个数据集。
然后我创建了一个查询（我能想象的最简单的一个）
SELECT tbl_Basis.Date，tbl_Basis.Price
FROM tbl_Basis
ORDER BY tbl_Basis.Date;
然后我创建了一个表格并插入了一个MS Graph Chart。对象，并设置查询的行源。我将图表类型更改为分散，并将x轴的数字格式更改为日期（14/03 / 2001）。
现在问题：当我执行表格，我所有的数据点都在01/01/1900上，并有不同的颜色。当我将x轴数字
格式更改为一般时，它们都是1。
为什么会这样？我尝试在表格中设置Lond日期而不是数字格式，在查询的属性中我设置了不同的数字格式 - 没有任何改变。
我感谢任何帮助，
谢谢，
克劳斯
Hi,
I want to create a chart
value (y-axis) vs. time (x-axis). In fact very similar to the
xy(scatter) example in the graph10.chm help-file.
I ran into problems, so I started a very basic *.mdb file.
It contains one table with ID, Date, and Price (Value) Column
ID is automatically assigned
Date is in the short date format
and Price is a long integer
I entered 10 datasets.
Then I created a query (the simplest one I could imagine)
SELECT tbl_Basis.Date, tbl_Basis.Price
FROM tbl_Basis
ORDER BY tbl_Basis.Date;
Then I created a form and inserted a "MS Graph Chart" Object, and set
the row source to the query. I changed the chart type to scatter, and
the number format of the x-axis to Date ("14/03/2001").
Now the problem: When I execute the form, all my data points are on
01/01/1900 and have different colours. When I change the x-axis number
format to general, they are all at "1".
Why would that be? I tried setting lond date instead of number format in
the table and in the properties of the query I set different number
formats - nothing has changed.
I appreciate any help,
thanks,
Claus
（我对克劳斯的回复从这里开始）
嗨
关于图表的几个问题得到解答在这个组中，也许它是一个只有Excel用户才能理解的黑色艺术。我希望这个回复不会让任何更专家回答你。
问题是图表是基于总计查询并且考虑将普通的XY图绘制为某种博士项目。
我通常会在数据中引入一个exta变量，该变量总是具有
值1，然后使图表将其视为一系列的
要绘制的值。
您可以使用下面的查询作为散点图的来源：
TRANSFORM Max（tbl_Basis.price）AS MaxOfPrice SELECT tbl_Basis.mydate
FROM tbl_Basis GROUP BY tbl_Basis.mydate PIVOT 1;
如果查看查询的输出，您可以看到
图表所期望的输入。
如果有两个具有相同日期的项目，它将只显示最大的。当然，如果你愿意，你可以使用SumOf而不是MaxOf，只需按月或其他任何方式分组。
HTH
David
(my reply to Claus starts here)
Hi
Few questions about charts get answered in this group, maybe it is a
black art only understood by Excel users. I hope this reply doesn''t
put off anyone more expert answering you.
The problem is that charts are based on totals queries and regard
plotting an ordinary X-Y graph as some kind of PhD project.
I usually introduce an exta variable in the data which always has the
value 1, and then make the chart regard this as one of a series of
values to be plotted.
You can use a query like that below as source for a scatter plot:
TRANSFORM Max(tbl_Basis.price) AS MaxOfPrice SELECT tbl_Basis.mydate
FROM tbl_Basis GROUP BY tbl_Basis.mydate PIVOT 1;
If you look at the output of the query you can see what input the
chart expects.
I have used mydate as a table field as I don''t like to use reserved
words.
iIf there are two items with the same date it will just show
the biggest. Of course if you prefer you can use SumOf rather than
MaxOf and just group by month or whatever.
HTH
David
大卫，你当然是对的。令人困惑。图表向导，对我来说是
，创建了一个图表4个季度，东部，西部和北部销售
区域。所有那些bullshxx来自哪里。我有X和Y
坐标，对吗？没有更多。
你认为我需要在我的桌子上添加另一个字段吗？或许
一个名为[GrosslyMisunderstoodByTheADT]并填写
，所有800条记录中的值1都可以。我不确定它将如何使用它来告诉MS Graph在（2,0）或其中任何一个上点上笛卡尔
飞机其他799分。如果你能告诉我如何用你的SQL替换我的表和我的3字段，那会有所帮助。
我很害怕我迷路了。 br />
David, you are certainly right. Its confusing. The graph wizard,
for me, creates a graph 4 quarters, East, West and North sales
areas. Where does all that bullshxx come from. I have X and Y
coordinates, right? Nothing more.
Do you think I need to add another field to my table? Perhaps
one named [GrosslyMisunderstoodByTheADT] and fill it with
the value 1 in all 800 records will do. I am not sure how it will
be used by Access to tell MS Graph "put a point on the cartesian
plane at (2,0) or any of the other 799 points. If you can tell me how
to substitute my table and my 3 field in your SQL, that would help.
I''m afraid I''m lost.
我修改了你的SQL以试图达到你建议的目标。
我的SQL如下所示。运行它只产生400条记录，因为我害怕b $ b。并且，将Chart对象的RowSource属性
更改为该查询并没有为我生成一个圆。同样的东，北，
南，第1，第2，第3和第4季度废话仍显示在我的图表上。
TRANSFORM Max（tbl800CircleDataPoints.Y ）AS MaxOfPrice
SELECT tbl800CircleDataPoints.X
FROM tbl800CircleDataPoints
GROUP BY tbl800CircleDataPoints.X
PIVOT 1;
I modified your SQL in an attempt to achieve your suggested objective.
My SQL is shown below. Running it produces only 400 records, as I
was afraid of. And, changing the Chart object''s RowSource property
to that query did not produce a circle for me. The same east, north,
south, 1st, 2nd, 3rd and 4th quarter crap still shows up on my graph.
TRANSFORM Max(tbl800CircleDataPoints.Y) AS MaxOfPrice
SELECT tbl800CircleDataPoints.X
FROM tbl800CircleDataPoints
GROUP BY tbl800CircleDataPoints.X
PIVOT 1;
这篇关于A97图形（x，y）坐标 - 怎么做？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
