Forum Discussion

jty1969

Copper Contributor

Oct 15, 2021

Need help with my formula, please!

Trying to return a numerical value 1-5 based on the text response in the cell. It's basically an attempt to turn a Likert scale response into a number. Here's what I have so far but it's not working:...

Excel on Mac

Formulas and Functions

Qaiser_j

Brass Contributor

Jun 14, 2024

Hi jty1969

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 https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.

And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

Thanks

Likert Scale Chart for survey data

Following 2 more charts for survey.