Plotting Likert (agree/disagree) data in Excel
Channel: Chris Armstrong
Date: 2022-07-26

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.