Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,
I need a very simple line graph to chart a temperature pattern in a course
of time (temperature on the Y axis and the time on the X axis). Simple.
However, simple as it sounds, I have not been able to get the Chart wizard
to do it. I don't need any cummulative figures, or additions or whatever. I
just need the following displayed graphically on a form:
Time Temp
------- -------
12:00 32.5
12:37 31.7
13:04 30.8
15:41 28.0
etc.
Can someone please help me out?
 
I just took your sample data, plugged it into a table and inserted a chart
into a form.

Using the wizard, I chose a Line Graph, with the orientation you described.
Yes, the Chart Wizard mangled it completely, but once it was done, I went
back to the properties of the graph, and changed its rowsource from what the
wizard generated to a simple SELECT [Time],[Temp] FROM [Readings] and the
resultant graph looked fine to me.

BTW, Time isn't a good choice for a field name: it's a reserved word, and
using reserved words can lead to problems. I'd recommend changing it to
something like ReadingTime.
 
Thanx Doug,
It never occured to me I could look into the property box. Yes, it does look
"more right", now. The only problem is that the intervals between the points
on the time scale are equal. I want the interval of 20 minutes between 2
readings to be very different from an interval of 2 hours. What should I do?
--
Glint

Douglas J Steele said:
I just took your sample data, plugged it into a table and inserted a chart
into a form.

Using the wizard, I chose a Line Graph, with the orientation you described.
Yes, the Chart Wizard mangled it completely, but once it was done, I went
back to the properties of the graph, and changed its rowsource from what the
wizard generated to a simple SELECT [Time],[Temp] FROM [Readings] and the
resultant graph looked fine to me.

BTW, Time isn't a good choice for a field name: it's a reserved word, and
using reserved words can lead to problems. I'd recommend changing it to
something like ReadingTime.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Glint said:
Hi All,
I need a very simple line graph to chart a temperature pattern in a course
of time (temperature on the Y axis and the time on the X axis). Simple.
However, simple as it sounds, I have not been able to get the Chart wizard
to do it. I don't need any cummulative figures, or additions or whatever. I
just need the following displayed graphically on a form:
Time Temp
------- -------
12:00 32.5
12:37 31.7
13:04 30.8
15:41 28.0
etc.
Can someone please help me out?
Click to expand...
Click to expand...
 
Back
Top