We have CSV results from a single survey (http://surveyanyplace.com/s/linktank-comm) that needs to be presented visually.
Your task is to create an Excel spreadsheet and set up charts for each question using pivot tables.
The CSV data is a little unclear so you'll need to do some work to modify labels. For example, this question (http://d.pr/i/i0ua) requires that the respondent switch the ranking. So, the results are presented as:
In such a case, you would need to change the numbers to the actual words and present the frequency for each one selected in terms of its rank as the first option, second option, third option, fourth option (example: http://6.anychart.com/products/anychart/docs/users-guide/img/Samples/sample-percent-stacked-bar-chart.png)