By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,149 Members | 885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,149 IT Pros & Developers. It's quick & easy.

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

P: n/a
MLH
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
Nov 13 '05 #1
Share this Question
Share on Google+
16 Replies


P: n/a
On Sat, 30 Jul 2005 11:30:17 -0400, MLH <CR**@NorthState.net> wrote:
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:
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.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

Nov 13 '05 #2

P: n/a
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 [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.
Nov 13 '05 #3

P: n/a
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(tbl800CircleDataPoints.Y) AS MaxOfPrice
SELECT tbl800CircleDataPoints.X
FROM tbl800CircleDataPoints
GROUP BY tbl800CircleDataPoints.X
PIVOT 1;

Nov 13 '05 #4

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
MLH
wow!
Are you using Access 97?

On Sat, 30 Jul 2005 18:05:29 GMT, "Rick Brandt"
<ri*********@hotmail.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

P: n/a
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

P: n/a
MLH
I'm getting the same junk as before. I let the wizard build
the graph. I click the chart/graph tool, tell it which table
to use for data, pick the 2 fields and no matter what I do
after that, Access gives me a table with 4 quarterly results
plotted and some company performance junk. We are
certainly not doing the same thing. What are you doing?

Yep. What result did you get?


Nov 13 '05 #11

P: n/a
MLH wrote:
I'm getting the same junk as before. I let the wizard build
the graph. I click the chart/graph tool, tell it which table
to use for data, pick the 2 fields and no matter what I do
after that, Access gives me a table with 4 quarterly results
plotted and some company performance junk. We are
certainly not doing the same thing. What are you doing?

Yep. What result did you get?


Are you doing this on a form? Never build a chart on a report or you will
always see the "sample chart data" when in design view. Even on a report though
you should only get the sample data when in design view. In Preview you should
see your data.

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

Nov 13 '05 #12

P: n/a
On Sat, 30 Jul 2005 16:06:40 -0400, MLH <CR**@NorthState.net> wrote:
I'm getting the same junk as before. I let the wizard build
the graph. I click the chart/graph tool, tell it which table
to use for data, pick the 2 fields and no matter what I do
after that, Access gives me a table with 4 quarterly results
plotted and some company performance junk. We are
certainly not doing the same thing. What are you doing?

Yep. What result did you get?

Hi
I have taken the liberty of sending you a small mdb file.
I find it easier to change a working program than using
the chart wizard!
David

Nov 13 '05 #13

P: n/a
MLH
David!

You R the man! I see it but I can barely believe it!
Every single time I try to do this, I cannot make it
happen. I will try harder to replicate it. R U using
the graph tool wizard? Do you have to do anything
manually that I may not encounter with the graph
tool wizard?
Nov 13 '05 #14

P: n/a
MLH
I'm doing it on a form. Is that where I should be?
And, I just looked at David Shofield's file. He's right
on the money. I still can't create it in my copy of A97
though. Frankly, I don't know how on earth he did it,
but he did! Its all there - right on the form - a perfect
plot of the 800 data points.

Are you doing this on a form? Never build a chart on a report or you will
always see the "sample chart data" when in design view. Even on a report though
you should only get the sample data when in design view. In Preview you should
see your data.


Nov 13 '05 #15

P: n/a
MLH wrote:
I'm doing it on a form. Is that where I should be?
And, I just looked at David Shofield's file. He's right
on the money. I still can't create it in my copy of A97
though. Frankly, I don't know how on earth he did it,
but he did! Its all there - right on the form - a perfect
plot of the 800 data points.


I got the same results as you (intermittently) when I used the wizard in a
report. In a form it "just works" for me.

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

P: n/a
On Sat, 30 Jul 2005 17:15:24 -0400, MLH <CR**@NorthState.net> wrote:
David!

You R the man! I see it but I can barely believe it!
Every single time I try to do this, I cannot make it
happen. I will try harder to replicate it. R U using
the graph tool wizard? Do you have to do anything
manually that I may not encounter with the graph
tool wizard?


Hi
I'm afraid I just looked up one of my old programs and altered it
to suit your data. I always do this now as I have lost the knack.

The problem with chart is that it is hard (impossible?) to find
where it stores its properties. You have to click and hope.
David

Nov 13 '05 #17

This discussion thread is closed

Replies have been disabled for this discussion.