A
astro
I'm trying to get a simple line chart going in a report.
The problem I'm having is Access's insistence of using the Transform/Pivot
functionality on the dataset I'm pulling from.
I don't want/need this. I want x-axis to be description, y-axis to be avg,
and the series to be the staff .
Sample data is as follows:
staff location description avg std
a 1 t1 4 1
a 1 t2 2 1
a 1 t3 4 2
a 1 t4 3 3
a 1 t5 2 4
b 1 t3 5 1
b 1 t4 3 2
b 1 t5 2 1
baseline 1 t1 1 2
baseline 1 t2 2 1
baseline 1 t3 4 3
baseline 1 t4 3 5
baseline 1 t5 2 1
b 1 t1 4 2
How do i tell the chart engine to lay off the fireworks and just chart my
data?
Thanks
)
The problem I'm having is Access's insistence of using the Transform/Pivot
functionality on the dataset I'm pulling from.
I don't want/need this. I want x-axis to be description, y-axis to be avg,
and the series to be the staff .
Sample data is as follows:
staff location description avg std
a 1 t1 4 1
a 1 t2 2 1
a 1 t3 4 2
a 1 t4 3 3
a 1 t5 2 4
b 1 t3 5 1
b 1 t4 3 2
b 1 t5 2 1
baseline 1 t1 1 2
baseline 1 t2 2 1
baseline 1 t3 4 3
baseline 1 t4 3 5
baseline 1 t5 2 1
b 1 t1 4 2
How do i tell the chart engine to lay off the fireworks and just chart my
data?
Thanks
)