CHARTING

[Guest]

I have been having problems using the chart wizard until i was reminded I
could alter the settings in the property box. Basically, I want to display
temperature over time. The readings are usually done hapahazardly; sometimes
at 2 hours intervals, but sometimes within minutes of each other:
DTime Temp
------- --------
12:00 28.7
14:00 28.9
14:15 29.4
15:05 31.1
19:30 26.4
etc
I want the graph on the form to reflect these intervals accurately but what
I get after changing the Rowsource to [DTime],[Temp] of my table is the
correct temperature charted on equal blocks of time, even though the times
are properly labeled.
How do I make the graph space the points according to the intervals on DTime?

 

[Rick Brandt]

I have been having problems using the chart wizard until i was
reminded I could alter the settings in the property box. Basically, I
want to display temperature over time. The readings are usually done
hapahazardly; sometimes at 2 hours intervals, but sometimes within
minutes of each other:
DTime Temp
------- --------
12:00 28.7
14:00 28.9
14:15 29.4
15:05 31.1
19:30 26.4
etc
I want the graph on the form to reflect these intervals accurately
but what I get after changing the Rowsource to [DTime],[Temp] of my
table is the correct temperature charted on equal blocks of time,
even though the times are properly labeled.
How do I make the graph space the points according to the intervals
on DTime?

You would need to create a table that stores every possible point in time
that you want to graph and then use an outer join query so that all points
are represented whether they have data or not.