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. ... 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)