I have a spreadsheet. 17 respondents answered on the question, where should be selected 3 variants of there preferences.
I need to draw Pie graph to see % of variants 1-12 in columns (q22a-q22c)
Respondent | Q22a | Q22b | Q22c |
1 | 8 | 9 | 12 |
2 | 8 | 9 | 12 |
3 | 3 | 6 | 8 |
4 | 7 | 9 | 12 |
5 | 1 | 3 | 8 |
6 | 5 | 7 | 12 |
7 | 3 | 11 | 12 |
8 | 1 | 6 | 11 |
9 | 1 | 6 | 12 |
10 | 2 | 7 | 8 |
11 | 1 | 6 | 12 |
12 | 5 | 11 | 12 |
13 | 1 | 2 | 5 |
14 | 1 | 11 | 12 |
15 | 1 | 3 | 9 |
16 | 1 | 4 | 7 |
17 | 1 | 9 | 10 |
tabulate Q22a , generate(a)
tabulate Q22b , generate(b)
tabulate Q22c , generate(c)
gen t1=c1+b1+a1
gen t2=c2+b2+a2
gen t3=c3+b3+a3
gen t4=c4+b4+a4
gen t5=c5+b5+a5
gen t6=c6+b6+a6
gen t7=c7+b7+a7
gen t8=c8+b8+a8
gen t9=c9+b9+a9
gen t10=c10+b10+a10
graph pie t1-t10
but tabulate can show only 10 rows but i have 12 rows, so it calcualted wrong, and it show me wrong labels after tabulate (like a1 ≠b1≠c1 ) (i manually created label for q22a-q22c (they are same) )
0 Response to Pie graph with 12 variants of answers recorded in three columns
Post a Comment