Charts in Access (or maybe Excel??)

[Nancy2021]

Some background...I am trying to create letters for chronically absent students. I have a query and a report that gives me FirstName, LastName, DaysAbsent, DaysAbsentAverageAllStudents along with some other fields. I want to create a letter with a chart at the bottom comparing the days a particular student was absent with the average for all students. When I try to create the chart in the report in access it has everyone in the report on the chart, I would like individual charts for each student. Is this possible in access?? I also downloaded the information to excel. Is there an easy way to create a chart for each record? and then for either way I'm able to create the charts, is there a way to do a mail merge to put them in a form letter?

 

[james_lankford]

in Excel you could make a pivot table and put the student name as the page filter
then create a chart based off the pivot table

 

[Nancy2021]

Would this create a chart for each student? I'm hoping to there is a way to create several charts, one for each record, without doing each chart individually.

 

[james_lankford]

after you create the pivot and put "student name" in the page filter you would have to go to the pivot options and select "show report filter pages"
and excel will automatically create a new sheet with a pivot for each student