I want to create multiple charts using a series of non-numerical data in Excel 2010.

Good morning everyone,

I am trying to create multiple charts with Excel 2010 using non-numerical data. I want every heading that is the top row to be designated as a different chart (e.g. ethnicity, # in household, grade of children). In the past I would have school districts fill out a survey through google docs and have google docs tabulate the data for me automatically and it would create these pie and bar graphs for me with the calculation of the number of people who responded to each specific question along with percentages. I want to be able to do that efficiently on my own to not have to be limited to google docs. I will go ahead and paste a spreadsheet of some dummy data and some questions and hopefully this would give you an idea of what I am trying to accomplish!

Help please

Thanks everyone!

-Carlos