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/...Gridlines.html
Cheers,
John
"John Ortt" <(E-Mail Removed)> wrote in message
news:45b8b4a8$(E-Mail Removed)...
> 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
>
>
>
Similar Threads
