how to chart multiple series from same record in a single table

[beto]

Hello everyone,

I'm quite a beginner and can't manage to solve this.

In a table called Audiometry I have diffrent series of fields to enter hearing threshold. The series are the thresholds obtained by different means: air conductin, bone conducting...
Ex. AC500, AC1000, AC2000.... BC500,BC1000, BC2000... An so on.

I managed to get a chart that shows me the values of a single series (air conducting thresholds) for a single record (audiometry).



I can't manage to show, in the same chart, the values of the other series (bone conducting or others).

Any help would be much apreciated,

Beto

[ranman256]

Add all values to the table, AC, BC, etc.
then open chart. It should see the change in series.

[beto]

I tried this but the chart does not know which fileds and values correspond to each series. It just makes a lng series with all of them.
How do I tell the chart whcich ones are series 1 and which ones are for serie 2

[rpeare]

how are you storing your data, I suspect this is non-normalized data, you may have to use a union query to make your data appear normalized then graph it.

i.e.

SELECT "Bone Conducting" as Desc, BC500 as [500 Range], BC1000 as [1000 Range], BC2000 as [2000 Range] FROM tblTestResults
UNION ALL
SELECT "Air Conducting" as Desc, AC500 as [500 Range], AC1000 as [1000 Range], AC2000 as [2000 Range] FROM tblTestResults

of course you'd have to also include a criteria for the client.