G
Glint
I have been having problems displaying a simple temperature/time line graph
on a form. I eventually got what looked like a fair representation only to
discover that it was not drawn to scale; all missing points were omitted to
give the impression that a 23-hour gap was the same as 1hour.
Someone suggested that for the graph to draw to scale by displaying all the
hours, even when there are no records, I would need to design a query with an
outer join. I found this made sense, especially after I was able to eliminate
the duplicate times the query returned from my simple table (Temperature &
ReadTime) and a table (with temperature as null & all ReadTimes).
However, I cannot help wondering if there is no easier way to go about this
charting. After all, what would be the point designing a charting system if
it cannot draw to scale?
My query does not make provision for a situation where the readings can be
done at any time, instead of specified times. I don't know how to solve that
problem yet.
What is the best way to use the timescale on the PivotChart? I am sure I am
missing something fundamental.
on a form. I eventually got what looked like a fair representation only to
discover that it was not drawn to scale; all missing points were omitted to
give the impression that a 23-hour gap was the same as 1hour.
Someone suggested that for the graph to draw to scale by displaying all the
hours, even when there are no records, I would need to design a query with an
outer join. I found this made sense, especially after I was able to eliminate
the duplicate times the query returned from my simple table (Temperature &
ReadTime) and a table (with temperature as null & all ReadTimes).
However, I cannot help wondering if there is no easier way to go about this
charting. After all, what would be the point designing a charting system if
it cannot draw to scale?
My query does not make provision for a situation where the readings can be
done at any time, instead of specified times. I don't know how to solve that
problem yet.
What is the best way to use the timescale on the PivotChart? I am sure I am
missing something fundamental.