435,149 Members | 885 Online
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 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
16 Replies

 P: n/a 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 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 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 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 wow! Are you using Access 97? On Sat, 30 Jul 2005 18:05:29 GMT, "Rick Brandt" 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 describedand 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 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 wrote: I'm getting the same junk as before. I let the wizard buildthe graph. I click the chart/graph tool, tell it which tableto use for data, pick the 2 fields and no matter what I doafter that, Access gives me a table with 4 quarterly resultsplotted and some company performance junk. We arecertainly 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 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 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 willalways see the "sample chart data" when in design view. Even on a report thoughyou should only get the sample data when in design view. In Preview you shouldsee 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 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 ithappen. I will try harder to replicate it. R U usingthe graph tool wizard? Do you have to do anythingmanually that I may not encounter with the graphtool 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.