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
Bookmarks