Plotting Likert (agree/disagree) data in Excel

If you're processing survey data that includes scales from strongly agree to strongly disagree, or similar, you probably want to plot it rather than try to compress it to a single number -- I know people who would get very, very angry if you did that. This gives a nice visualisation of your results, which doesn't hide any distributions or make assumptions about what "neither" might mean. This tutorial covers how to build such a plot in Excel. Alternatives are available, obviously. It's probably in R, too, but you can build a spreadsheet template and drop your data into it again and again and have it update instantly.

[mlo]

Thank you. It took me a while to find as most videos out there are on how to create an initial Likert scale, not on how to display the results. I am grateful that I came across your video!

[alisonhill]

Thank you very much for this! I've re-watched it many times and its helped me make excellent charts for my Masters coursework. The way you explained it was excellent and very easy to follow.

[jameselliott]

Excellent explanation! Thank you! It's a wonder that Excel doesn't do this already.

[HRUMS]

thank you very much. I have learned a lot from your presentation.

[carok]

genius! exactly what I needed, thanks a lot!

[carmenalns]

This was such a life saver, thank you so much!!

[AnnaRiling]

How would you visualize a "NA/Don't know" response? Would that be a 2nd axis?

[nobuenomonkey]

Thank you for this video. I’ve trying to figure out how to properly display my data from my surveys