To Duane Hookom or Steve T

R

Russ

Hi guys:

I have an application requiring a graph/chart utilizing a
bell curve to represent the data for analysis. The data
looks like the following.

The three fields in the query are: Year, DayCode and
AvgBI. "AvgBI" would be the field on which the Bell Curve
is based.

Year DAY AvgBI
2003 152 4.87333333333333
2003 153 4.70333333333333
2003 154 4.94333333333333
2003 155 4.85
2003 156 4.9
2003 157 4.42666666666667
2003 158 4.65
2003 159 4.61666666666667
2003 160 4.36
2003 161 3.25333333333333
2003 162 5.13
2003 163 4.83
2003 164 4.78666666666667
2003 165 4.61

Appreciate any help from both or either of you guys on
this. You seem to be guru's on the subject! I've been at
this for some time now, and reaching frustration. Any
Access mdb sample downloads from any site containing
graphs and charts will also help.

Thanks,
 
D

Duane Hookom

I think SteveT would suggest you start with a new, blank form. Turn your
wizards off and add a chart control to your form. Find the Row Source
property of the graph and enter:
SELECT DateSerial([Year], 1, [Day]) as BIDay, AvgBI
FROM qselYourQueryName
ORDER BY DateSerial([Year], 1, [Day]);

Set the graph properties:
Enabled: True
Locked: No

Save the form and then open it in Form view. Double click the graph and set
all the properties you want by double-clicking various objects etc. Click
back on the form to update the form view. When you have your graph as
needed, then copy and paste it onto your report.

Sample graphs in ver 97. You should be able to convert to 2000 or 2002.
http://support.microsoft.com/default.aspx?scid=kb;en-us;186855
 
R

Russ

Duane:

Thanks for information and the URL to the chart sample MDB
download. As I said previously: "You guys are good!" Also
thank Steve T for me if you happen to run into him.



-----Original Message-----
I think SteveT would suggest you start with a new, blank form. Turn your
wizards off and add a chart control to your form. Find the Row Source
property of the graph and enter:
SELECT DateSerial([Year], 1, [Day]) as BIDay, AvgBI
FROM qselYourQueryName
ORDER BY DateSerial([Year], 1, [Day]);

Set the graph properties:
Enabled: True
Locked: No

Save the form and then open it in Form view. Double click the graph and set
all the properties you want by double-clicking various objects etc. Click
back on the form to update the form view. When you have your graph as
needed, then copy and paste it onto your report.

Sample graphs in ver 97. You should be able to convert to 2000 or 2002.
http://support.microsoft.com/default.aspx?scid=kb;en- us;186855

--
Duane Hookom
Microsoft Access MVP


Russ said:
Hi guys:

I have an application requiring a graph/chart utilizing a
bell curve to represent the data for analysis. The data
looks like the following.

The three fields in the query are: Year, DayCode and
AvgBI. "AvgBI" would be the field on which the Bell Curve
is based.

Year DAY AvgBI
2003 152 4.87333333333333
2003 153 4.70333333333333
2003 154 4.94333333333333
2003 155 4.85
2003 156 4.9
2003 157 4.42666666666667
2003 158 4.65
2003 159 4.61666666666667
2003 160 4.36
2003 161 3.25333333333333
2003 162 5.13
2003 163 4.83
2003 164 4.78666666666667
2003 165 4.61

Appreciate any help from both or either of you guys on
this. You seem to be guru's on the subject! I've been at
this for some time now, and reaching frustration. Any
Access mdb sample downloads from any site containing
graphs and charts will also help.

Thanks,
Click to expand...


.
Click to expand...
 
Top