macor to create chart/graph for a specific row of data

[slice.cheese]

I am sort of stuck and need a bit of help!!

I have a worksheet that looks like this:

A B C D E
name test1 test2 test3 test4


average avgtest1 avgtest2 avgtest3 avgtest4


in each class there are 26 students so i want to have a button on each
row that will create a line graph comparing the inividuals marks
against the overall class average for each test.

i'm not really up to speed with excel and have been doing a bit of
reading, as far as i can gather it is a macro i am going to have to use
to do this but i dont really know what i should even be typing into
google to get the help i need.

any help would be much appreciated

 

[Gerencsér Gábor]

This can be done with graphs, no macro needed.
The best visual for this is a bar chart with the individuals' results and a
horizontal line showing the average.
Try to create four graphs.
Gabor