simple line chart in report

[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

)

 

[Duane Hookom]

Just modify the Row Source property of the chart to whatever you want.

 

[astro]

Thanks Duane - I'll give this a shot...

Just modify the Row Source property of the chart to whatever you want.