Scatter Plot With More Than One Series (1 Viewer)

[rfear]

I have a table with 3 columns as follows, keeping track of the number of jobs arriving and jobs departing from a workcentre :-

JobDate RSumAR RSumDR
02/01/08 2
03/01/08 1

So, 2 jobs arrived on 02/01/08 and 1 job departed on 03/01/08.

A query transforms this table to :-

RowHeading 02/01/08
ArrivalRate 2

... in preparation for charting. The SQL is as follows :-

TRANSFORM Sum(NEWTBL_CUMULATIVEARRIVALANDDEPARTURERATES.RunningSumIndexAR) AS SumOfRunningSumIndexAR
SELECT "Arrival Rate" AS RowHeading
FROM NEWTBL_CUMULATIVEARRIVALANDDEPARTURERATES
GROUP BY "Arrival Rate"
PIVOT NEWTBL_CUMULATIVEARRIVALANDDEPARTURERATES.JOBDATE;

First question, can I have another row beneath 'arrivalrate' and call it 'departurerate'.

Second question, how do I then plot these 2 series on a scatter chart. I've managed to plot one series so far ( the arrival rate ) but also want to show departure rate on the same graph.

 

[rfear]

I may have solved this for myself, with a little help,

http://www.vb123.com/toolshed/00_docs/spatialaccess.htm

It would appear that creating a chart in a form ( as described above ) gives you access to features I have not come across when using the chart wizard in a report.

Most useful of which is instructing the chart that the data is in columns. Therefore no need to transform the data.

Once created in a form, the chart can be cut and pasted into a report.

... and an added bonus, whereas the crosstab query had a limit on the number of columns, using the untransformed table I can have as many records as I like ( I think ).