Hey Brian, we created all of these Likert scale plots (also called diverging stacked bar charts) in R. There is a very convoluted way to make them in Excel, but I think Google Sheets doesn’t have the manual editing tools required. I put links to a few guides below. Hope this helps!
Thanks for this report! Two minor questions:
What do you call the type of graph shown below, and what do you use to make these graphs? They’re quite cool.
2. Is the graph above possible to make via Google Sheets or some easy-to-use platform? Thanks!
Hey Brian, we created all of these Likert scale plots (also called diverging stacked bar charts) in R. There is a very convoluted way to make them in Excel, but I think Google Sheets doesn’t have the manual editing tools required. I put links to a few guides below. Hope this helps!
R—https://cran.r-project.org/web/packages/likert/likert.pdf Excel—https://mbounthavong.com/blog/tag/Diverging+stacked+bar+chart
Got it, thanks! Were all of the charts and tables here made using R?