graph in excel 10

I have a small piece of test result stats and i would like to present in a graph the results but not sure how. I have put the meanings of the groups in the spreadsheet ex

i tried the wizard but it doesnt do it correctly

regards in advance
ee-ex.xlsx
PeterBaileyUkAsked:
Who is Participating?
 
SiddharthRoutCommented:
This is the nearest that I could get without manipulating the base data.

Sid
Sample-Chart.xlsx
0
 
SiddharthRoutCommented:
Is this what you are trying?

Sid
Sample-Chart.xlsx
0
 
PeterBaileyUkAuthor Commented:
have drawn what i hope might be possible





example.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.