Help with graphs

[Stazz2385]

Hello i have this particualr problem to solve.

I am not that good at excel but keen to improve.

I have to make a graph out of an answer from a survey; one of the questions can be answered through 5 posible answers, only one can be chosen.

I wanted to know how i can make a graph out of it ? Like a graph that shows that quantity of the answers chosen.

Thank you in advance 

[#2]

Hi @Stazz2385 

I attached sample charts created on survey data. Data refresh in the chart automatically as you change your data selection.

I regularly create these charts with the following tool. Hope you will like it.

You can check here for Microsoft Excel & Office 365.

And if you are comfortable with Google Sheets, you can find it here.

Thanks

Likert Scale Chart for survey data

Another chart for survey data

Another chart for survey data.

One more chart for survey data