software

hi, i'm hoping someone can help me as i dont have much of a clue about excel
formula or macros.

i have a table that contains the names of all the students in a class, the
names of the tests and their score. over the year there are about 16 tests
but to this point only 8 have been completed. the bottom row of the table
contains the class average for the class

Looks something like this:

A B C D E F G H I
J
name test1 test2 test3 test4 test5 test6 test7 test8
joe 44 87 96 54 67 65 45
45

etc

class average is totalled at bottom of each of the test columnswhat i want to do is have a button at the end of each of the rows that will
draw a line graph on its own page plotting the individual pupil's test
scores against the class average, this will then show the pupil's scoring
trend against the rest of the class. i also need the chart sheet to be
renamed with the pupils name.

i hope i have made myself semi clear!! I dont really know what functions i
am looking for so i haven't had much success with google.

thanks in advance