Statistics with Google Forms?

Question

excel

Welcome all!
A survey is conducted through Google Forms, through the "Scale" field.
Those. just a person chooses from 1 to 5.
This is recorded in an Excel document. At the output, I would like to have the following:
A chart that makes up for each column the percentage of how many times a person pressed the number 5 4 3 2 1, respectively. That is, to keep statistics for each item separately.
upd: the toaster is a magical place, every time after I write a question here - I literally find the answer in a couple of minutes. I found a summary of all the answers in Google forms, but there the graphs are slightly different. I would like to generate diagrams on my own, point by point.

Answer 1

You are simply using a modified Duckling method. )
Correctly formulate the question and find the answer to it.