Pivottable / Charts: How to sum up questions with different answers (scale 1-4)?

Nabila Benmalek · ‎Sep 01 2018

Hey, I need help, please leave an answer, thankyou so much!

I'm german but will try to explain in english language correctly. I tried everything but I cant find a solution.

I hope my picture explains everything. How can I reach that pivottable or is pivottable not the suitable thing for this?

(It would be nice if you could send me an easy example excel sheet to demonstrate the solution)

Qaiser_j · ‎Aug 31 2021

Hope you are doing well.

I would like to mention a No Code Data Visualization Tool for the purpose to get insights from your raw data. Hope you will like it.

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

This video perfectly fulfill your case.

Thanks

Products (49)