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.

[@mlo9987]

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!

[@HRUMS]

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

[@YTFC2008]

I likert very much, thank you!

[@hs0008]

Thanks for your help Chris

[@yumnamoussa8165]

thank you!!! this was so helpful

[@carok6673]

genius! exactly what I needed, thanks a lot!

[@carmenalns4156]

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

[@samb5282]

What about where 'Neither agree nor disagree' is zero?

[@jameselliott4911]

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

[@ChrisArmstrongChemistry]

It can do stacked bar charts that are scaled to 100%. That's perfectly acceptable for most uses, especially if the number of responses is comparable between questions, and works "out of the box" with no modifications. But those can be a little harder to see exactly where the central tendency is. It'll come down to preference and what you want to show.

[@nobuenomonkey478]

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

[@ChrisArmstrongChemistry]

It's probably slightly easier in R, but once you have a template set up, may as well keep with a spreadsheet.

[@AnnaRiling]

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

[@ChrisArmstrongChemistry]

I don't think I've seen N/A used with this style.