I have data from a questionnaire that incorporated a Likert scale which I would like to chart but am having difficulties incorporating everything I want in one chart, i.e. i would like the number of responses indicated along with these response figures as a percentage that ive already calculated using formula in excel under the likert scale of strongly disagree, disagree, undecided, agree and strongly agree which would all be indicated in different coloured bars. How can i get all the three pieces of data i have on my spreadsheet into a graph. I can either get the responses and likert scale as the legend or the percentages corresponding to the likert scale as the legend.
Also what graph would be best to display my data.
Furthermore i would it be possible to separate this data once all displayed in a graph according to the respondents age to the number of responses for each scale along with the percentage.
I would appreciate any help.
Gareth
I have attached my raw data so i hope someone can help me with a solution.
Bookmarks