MS Graph Object in MS Access - category axis as timeline

C

Claus Haslauer

Hi,
I want to plot variable X versus time.
X has been measured at discrete, not equidistant points in time.
X has also been measured at different locations (those should be
different "series" (in excel lingo))

I've got one query:

SELECT
tbl_parameter.date
tbl_basis!y + tbl_parameter!z AS X
tbl_parameter.location.
FROM {some joins}
HAVING tbl_parameter.location IN ('loc1', 'loc3');


*What is the best and easiest way to plot the result of that query?* The
x-axis should be a linear x-axis ranging say from 1998 to 2005.

I played around, and I can get it to work, if I take monthly averages,
and then plot only the months when there is a measurement.

That chart should be updated based on a list box where I choose the
locations, that's why I'm posting this in the "forms" newsgroup, and
because I didn't find a specific access-charting one.

Thanks for your help,
Claus
 
Top