Complex Charting Help

[John Ortt]

Hi everyone,

I am trying to plot temperature data from a machine tool onto a chart using
access.

The graph will contain a rolling chart showing the temperature of the
machine's environment at each point in time.

(This is the easy bit and it works fine).

The hard part is that there are also control points where the user enters a
manually measured temperature for calibration. These points are usually
daily but can vary dramatically.

The other problem is that the only dates I want to show on the x-axis are
the user check (SRS) values, the rest should remain blank.

I have included a sample of the data below.

Any help would be gratefully recieved,

Thanks,

John

TempDate TempTime ICYout CMMout SRSVal SRSDate
29/10/2006 10:11:00 22.1 20.5 20.6
29/10/2006 10:21:00 22.3 21.6 20.7
29/10/2006 10:31:00 22.5 21.7 20.6
29/10/2006 10:41:00 22.4 21.7 20.5
29/10/2006
29/10/2006 10:51:00 22.9 20.9 20.8
29/10/2006 11:01:00 23 20.9 20.6
29/10/2006 11:11:00 22.9 20.8 20.7

 

[John Ortt]

I have found a site which does exactly what I want with excel, but it relies
on changing the x and y values for each range from within the source data.

I am not sure this can be done in Access.

the solution I have found is here:
http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

Cheers,

John