charting multiple values from single record

[ndeans]

This particular database generally looks at reporting individual records as opposed to summary reports. So for a particular data record i have the following data [x1][x2][x3][x4][x5][y1][y2][y3][y4][y5]

I need to chart (scatter) these figures as paired x,y variables for display on a feedback report such as

x1,y1
x2,y2
x3,y3
x4,y4
x5,y5

For some reason i simply can't wrap my head around haw to make this happen.

Many Thanks in advance for any help.

Cheers
ndeans

 

[ndeans]

----solved----

Just to let you all know, i have finally solved this issue myself.
I have basically designed a LUT with some of the more fixed data in it as follows:
group,stage,value
grp1, stage1, x1
grp1, stage2, x2
grp1, stage3, x3
grp1, stage4, x4
grp1, stage5, x5
grp2, stage1, x2
grp2, stage2, x3
grp2, stage3, x4
grp2, stage4, x5
grp2, stage5, x6
grp3, stage1, x3
grp3, stage2, x4

etc for a total of 4 groups.
The grp is based on a collected data variable for each record so i have used this as a grouping criteria in the Select Query
Then
column 1 = x values
column 2 = y values (based on the stage value, ie stage 1 = y1, stage 2 = y2 etc. So the query now returns what appears to be a 5 record dataset that looks as follows:

hidden, hidden, visible, visible
grpA stage1 x1 y1
grpA stage2 x2 y2
grpA stage3 x3 y3
grpA stage4 x4 y4
grpA stage5 x5 y5

So hopefully that won't take me as long to figure out next time, hope this helps anyone else out there who is also having similar difficulties.

 

[neileg]

Your problem only happens because your design is wrong - it's not normalised. Each xy pair should be a record in a related table, not repeating groups as you have them.