Charts in Access 2007

[here4real]

First time I've tried creating a chart and obviously I'm missing something... I have a query that lists for a multiple people and months, 2 values...

For example:

Joe 01/2013 25 45
Joe 02/2013 10 70
Sam 01/2013 37 40
Sam 02/2013 79 23

When I tried using the wizard, it insisted on summing my values... In the report, I have a group on person name (with a page break)... I want to put a chart on each page with the values on the y-axis and the months on the x-axis... It just won't work...

 

[here4real]

I've made progress but am stuck again...

I have a DB with staff, date and 2 values to display...

What I want to do in the report is page break on each staff person so it graphs just the date (month) and the 2 values for each staff person... I can get the chart to put the staff person and month on the x-axis and the 2 values on the y-axis but I haven't figured out how to make it more dynamic...

Any ideas???

 

[here4real]

Finally got it...

I put a dummy hidden field on the report and set it equal to the staff person's name... Then on the chart row source I added a WHERE that says that staff name (the field in the query) must be equal to the dummy field...