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
Thanks David, very helpful stuff!