Pivot chart from available data

[Matuag]

Hi,

I want to plot a graph (Audiogram) for frequency (X axis) against
intensity (Y axis). Data for which will be sourced from an existing
table following frequency fields. (http://en.wikipedia.org/wiki/
Image:Tonaud_w_norm.jpg)
250Right, 500Right, 1000Right, 2000Right, 4000Right and 250Left,
500Left, 1000Left, 2000Left, 4000Left. Data under these fields will be
intensities in any number from 0dB to 120dB.
eg.

Client ID 250Right 500Right 1000Right ...
1 20 40 50 ....
2 30 90 80 ....
3 40 55 85 ....

and so on
Please suggest which data goes to series, category and data field? I
am very confused and unable to create this graph as I don't know which
data to drag on X axis. Every time I try this it gives Total values
for entire data. Also not sure if I am using the correct chart type. I
selected XY scatter so that I can create TWO different lines for Left
and Right ear which can be compared on the same graph.

Cheers, Matuag

[JHB]

Hello Mataug.

It can be done on this way.

Make a query with the following SQL and save it named "GetData".

Replace "Table1" with the name of yours table.

SELECT "Right" as Side, Tabel1.Right250 as 250, Tabel1.Right500 as 500,
Tabel1.Right1000 as 1000, Tabel1.Right2000 as 2000, Tabel1.Right4000 as 4000

FROM Tabel1

WHERE (((Tabel1.ClientID)=[Input ClientId]))

union

SELECT "Left" as Side, Tabel1.Left250 as 250, Tabel1.Left500 as 500,
Tabel1.Left1000 as 1000, Tabel1.Left2000 as 2000, Tabel1.Left4000 as 4000

FROM Tabel1

WHERE (((Tabel1.ClientID)=[Input ClientId]));

Create a report and put a graph on it, set the graphs rowsource to:

SELECT GetData.Side, GetData.[250], GetData.[500], GetData.[1000],
GetData.[2000], GetData.[4000] FROM GetData GROUP BY GetData.Side,
GetData.[250], GetData.[500], GetData.[1000], GetData.[2000],
GetData.[4000];

Regards

Jørn


"Matuag" <ma****@gmail.comskrev i en meddelelse
news:11**********************@g37g2000prf.googlegr oups.com...

Hi,

I want to plot a graph (Audiogram) for frequency (X axis) against
intensity (Y axis). Data for which will be sourced from an existing
table following frequency fields. (http://en.wikipedia.org/wiki/
Image:Tonaud_w_norm.jpg)
250Right, 500Right, 1000Right, 2000Right, 4000Right and 250Left,
500Left, 1000Left, 2000Left, 4000Left. Data under these fields will be
intensities in any number from 0dB to 120dB.
eg.

Client ID 250Right 500Right 1000Right ...
1 20 40 50 ....
2 30 90 80 ....
3 40 55 85 ....

and so on
Please suggest which data goes to series, category and data field? I
am very confused and unable to create this graph as I don't know which
data to drag on X axis. Every time I try this it gives Total values
for entire data. Also not sure if I am using the correct chart type. I
selected XY scatter so that I can create TWO different lines for Left
and Right ear which can be compared on the same graph.

Cheers, Matuag