Automate multiple series line graphs
 

I am trying to automate multiple-series line graphs from an Access query, but
I am having trouble defining the chart that I will call with the ChartWizard
method of the Chart object.

The query has 4 columns: Station, Device, Waterlevel, Date.
Each Station has several Devices, and Waterlevel and Date as listed for each
Device.

In Access, the user inputs the Station for the query, so the called Excel
worksheet will have only the Device, Waterlevel, and Date columns.

I want to make a line chart, time x-axis (with day base unit), with
Waterlevel as the y value. There should be a series for each Device (1-4
depending on the Station chosen).

How do I progam multiple line series using the Device column as the
definition of the series, without naming each individual device specifically?
(The names of the Devices change when a different Station is chosen.)

How do I define the x-axis as as time-series with day as its base unit? (Or
will Chart Wizard do this automatically?)

Thanks