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

%3CLINGO-SUB%20id%3D%22lingo-sub-241201%22%20slang%3D%22en-US%22%3EPivottable%20%2F%20Charts%3A%20How%20to%20sum%20up%20questions%20with%20different%20answers%20(scale%201-4)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241201%22%20slang%3D%22en-US%22%3E%3CP%3EHey%2C%20I%20need%20help%2C%20please%20leave%20an%20answer%2C%20thankyou%20so%20much!%3C%2FP%3E%3CP%3EI'm%20german%20but%20will%20try%20to%20explain%20in%20english%20language%20correctly.%20I%20tried%20everything%20but%20I%20cant%20find%20a%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20my%20picture%20explains%20everything.%20How%20can%20I%20reach%20that%20pivottable%20or%20is%20pivottable%20not%20the%20suitable%20thing%20for%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B(It%20would%20be%20nice%20if%20you%20could%20send%20me%20an%20easy%20example%20excel%20sheet%20to%20demonstrate%20the%20solution)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-241201%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivot%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivotTable%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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)

 

 

 

 

0 Replies