Help with Likert Response to Stacked Chart

[bcochra]

I am trying to take a Google Form response sheet with likert scales and make a stacked bar chart that lists each question with a 100% stacked bar based on responses similar to image (I have tried converting the numerical responses to text and it did not work). However, I cannot figure out how to make it work.

Here is data sheet

What I wantWhat I get