473,564 Members | 2,768 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

A97 graphing (x,y) coord's - how to do it?

MLH
I have 800 rows in a table named tbl800CircleDat aPoints.
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
Nov 13 '05 #1
16 1639
On Sat, 30 Jul 2005 11:30:17 -0400, MLH <CR**@NorthStat e.net> wrote:
I have 800 rows in a table named tbl800CircleDat aPoints.
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******@scim ail.uwaterloo.c a> wrote:
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

(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.p rice) AS MaxOfPrice SELECT tbl_Basis.mydat e
FROM tbl_Basis GROUP BY tbl_Basis.mydat e 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

Nov 13 '05 #2
MLH
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 [GrosslyMisunder stoodByTheADT] 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.
Nov 13 '05 #3
MLH
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(tbl800Circl eDataPoints.Y) AS MaxOfPrice
SELECT tbl800CircleDat aPoints.X
FROM tbl800CircleDat aPoints
GROUP BY tbl800CircleDat aPoints.X
PIVOT 1;

Nov 13 '05 #4
MLH
Simple works for me, so I better restructure my post...
I have table with 2 fields: [X] and [Y] and 1 record.
The value in both fields of the single record is 1. I
would like ms graph to create me a graph showing
a dot (or some other object) at the point (1,1) on the
graph. Nothing else, no lables, titles, axes titles -
nothing. Just a big PLUS mark and a single dot.
The plus sign being the coordinate axes. Can it do that?
Nov 13 '05 #5
MLH wrote:
Simple works for me, so I better restructure my post...
I have table with 2 fields: [X] and [Y] and 1 record.
The value in both fields of the single record is 1. I
would like ms graph to create me a graph showing
a dot (or some other object) at the point (1,1) on the
graph. Nothing else, no lables, titles, axes titles -
nothing. Just a big PLUS mark and a single dot.
The plus sign being the coordinate axes. Can it do that?


Have you tried the chart wizard choosing a scatter chart as the type?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #6
MLH
Yes. No luck there, I'm afraid.

Have you tried the chart wizard choosing a scatter chart as the type?


Nov 13 '05 #7
MLH wrote:
Yes. No luck there, I'm afraid.

Have you tried the chart wizard choosing a scatter chart as the
type?


What was the problem? I tested with the single record table that you described
and it charted a single "dot" at 1,1. Isn't that what you want?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #8
MLH
wow!
Are you using Access 97?

On Sat, 30 Jul 2005 18:05:29 GMT, "Rick Brandt"
<ri*********@ho tmail.com> wrote:
MLH wrote:
Yes. No luck there, I'm afraid.
>
> Have you tried the chart wizard choosing a scatter chart as the
> type?


What was the problem? I tested with the single record table that you described
and it charted a single "dot" at 1,1. Isn't that what you want?


Nov 13 '05 #9
MLH wrote:
wow!
Are you using Access 97?


Yep. What result did you get?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2341
by: Michael T. Peterson | last post by:
Would anyone care to recommend a good graphing package (commercial or otherwise)? I've looked at some of the PEAR Image packages - The only graphing package is still alpha quality. One particularly interesting feature would be to display data as in a 'strip chart' recorder, i.e., the graph scrolls across the web page. Any...
4
1917
by: FGO | last post by:
Hi all, I use jpgraph as a graphing tool and it is very slow. Is there a solution to tune it or will I have to use another graphing solution, and which one? (My graphs are simple line stocks quotes) thanks!
2
2323
by: john | last post by:
Are there any charting or graphing modules for python that can write PNG, JPEG, or GIF graphics? I have found a couple of nice looking packages that can make beautiful postscript, PDF, or SVGs (PyChart and ReportLab) but they can't make PNGs, GIFs, or JPEGs. (On my Solaris machine with Python 2.2 they don't.) Or are there any simple UNIX...
22
14335
by: Kenneth Miller | last post by:
Hello All, I am new to Python and i was wondering what graphing utlities would be available to me. I have already tried BLT and after weeks of unsuccesful installs i'd like to find something else. Anything someone would recommend? Regards, Ken
6
1585
by: Michael Hill | last post by:
Hello, all. I am considering writing an online graphing utility. I plan it to be of good quality, such that an undergraduate university student can print it out and include it with a lab report. Data points will be entered, having been generated by another program; the utility will NOT accept functions for plotting--just the data points. ...
1
1161
by: Mudcat | last post by:
Hi, I have looked through the previous suggestions on graphing modules and have been able to find some good suggestions. However I was wondering about something more specific. I am going to write a program that tracks stock prices and other financial related charts, so I need to use the classic stock chart. From the ones I've seen, the...
1
2963
by: robby.walker | last post by:
Hi, I've just released a full-featured online graphing calculator at http://www.e-tutor.com/et2/graphing/ It requires no downloads or plugins - just JavaScript. You can track points on the curve, graph multiple functions, and more. A lot of this functionality is implemented in JavaScript. I'm very interested in hearing people's...
0
1341
by: Dexter | last post by:
GraphEasyRect was previously available as an applet. Now we have converted it to a desktop standalone application that runs on multiple platforms Windows, Mac, and Linux This tool allows graphing functions in cartesian plane, points of discontinuity having limits are encircled on graph line. You may view and copy the values of the function...
2
2180
by: sydneytroz | last post by:
I am writing a program to simulate a double displacement reaction getting to equilibrium, but I am having some trouble graphing the particles' concentrations. It seems that it's only possible to pan and zoom the graph once the program exits (when running it from IDLE), but I don't want to have to kill the sim every time I want to view the graph...
1
1779
by: skeates | last post by:
Hey all - I'm attempting to write a program that accesses a database, runs some calculations according to user input, and then creates some graphs from the results. The first two steps were pretty simple, but I was disappointed to discover that VB.NET (at least the express edition) doesn't have any sort of built in graphing controls. My original...
0
7665
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8106
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7950
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6255
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5484
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3643
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2082
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1200
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
924
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.