Forum Discussion

Nabila Benmalek's avatar
Nabila Benmalek
Copper Contributor
Sep 01, 2018

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

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)

 

 

 

 

excel
  • Qaiser_j's avatar
    Qaiser_j
    Brass Contributor
    Aug 31, 2021

    Hi Nabila Benmalek 

     

    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.

     

    You can check here for Microsoft Excel & Office 365.

     

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

     

    This video perfectly fulfill your case. 

     

    Thanks 

Resources