If you add additional rows of data for each month you should be able to do
Also add another column of labels in order to group Months with Questions.
Put the question text in A2,A5,A8,A11 and A14
In B2:B16 repeat Month 1, Month 2, Month 3
In C2:C16 scores for each question and month
In D2:D16 maximum score for each question repeated across months
In E2:E16 minimum score for each question repeated across months
Now chart A1:E16 and format as per previous instructions.
I think now you really should have the Average score as a line.
In order to break the line between questions insert blank rows above and
below each question.
You will need to adjust each series to use the rows 2:26. And move the
Question text up in order for the axis labels to appear correct.
Andy Pope, Microsoft MVP - Excel