Charts

[Guest]

Hi,

I would like to create a chart for each employee, each record, to compare of
the year 2006 and 2007. It is about 8O employees.
I use Pivot Chart option to create one, but it shows all employees. In my
case, I would like to have their charts separately. Is there a way I can do
it? Please help

Ex: AT BC CC GA
2006 100 50 12 11
2007 80 60 11 22

 

[Guest]

Create a Crosstab query, then use it as the basis for a report that seperates
each employeeID to a seperate page.

 

[Guest]

Hi Steve,

Would you please show me how to separate each employeeID to a separate page
in the report?
Thanks
Chi Huynh

 

[Pieter Wijnen]

with charts I think you have to program or print one report per employee, as
you can't change the rowsource of a graph in access "on the fly"

Pieter