Hi

I am new to vb and would greatly appreciate if somebody could help.

I have some names in one column(column A), Questions for which they are evaluated upon(column B) and a rating based on each month( May, Jun and July in columns C, D and E).

Each person is given a rating of 1 for incorrectly answered questions and 5 for correctly answered .A person could be evaluated for more that one question.

I wanted to generate a chart with the name of the person as the sheet name, the questions on the X axis and the number of questions answered incorrectly on Y axis(i.e if a person answers 3 question wrong in May then the chart should read on 3 on Y axis for a 3 month period.

Sorry for making it so long but would really appreciate if somebody could help.

Matt