Graphs, Reports, and Crosstab Query

[Kevin Labore]

Hi

I have a report based on a crosstab query that the data and report work fine
I am tyring to Add a Graph to the report so it matches the report.

The report does a page for each Dept, and the Weeks are in rows, and Years
are in Cols

Each Dept is on a new page and the weeks,years fit on a page. The report
also so the increase/decrease over the Prior year for that particular week.

What I would like to graph if the values 2005,2004,Week (by DeptDesc) also
of which are values from the query
I am confident with graphs in Excel, but havent really created anything in
Access for graphs and I am finding it confusing.
It would be ok if the graph ended up being on a new/seperate page from the
report page.

I want the graph to show the series for each year(from the crosstab Query)
and the graph to represent value from
only one deptartment per graph.(but all department (about 50 ))

Can someone tell me how to go about this (just inserting the graph doesnt
give desired results).
Or tell me where I can find some clear examples

thanks

KEvin