I tried making charts, like pie charts and bar charts.
Here is a screenshot.
http://imgur.com/npwVV6V

What I want is to create a bar chart (E.g. in the screenshot I was trying to create a bar chart to show the total amount of each age group 16,17,18 etc...) What I did was highlighting row 1 and 2 then I went to insert, then clicked on bar graph. Then below is the graph which I got... it showed each age of each questionnaire, where I wanted to have total amount of 16 year olds, 17 year olds etc..

ALSO

When I try to create a pie chart for like the total of M and F... I highlighted row 1 and 3 and did the same thing with insert > pie chart but nothing came out... it doesn't work or show anything. It doesn't read non numeric data? Nothing shows up.

Please help me

Thank you very much.

Is it the same method for excel 2010 as well a 2013?