Hi,
I am a beginner level reportnet user and I am trying to figure out how to do a 100% stacked bar chart -
here is my simplified data -
policy # score1 score2 score3
A 3 3 1
B 3 2 1
C 1 2 3
D 1 3 2
summary count of 3s count of 3s count of 3s
summary count of 2s count of 2s count of 2s
summary count of 1s count of 1s count of 1s
expected bar graph output -
3 horizoantal bars one each for score1, score 2 and score 3
each bar sectioned with color coding of scores.
for example bar 1 will be for score 1 and it will have 50% for 3, 50% for 1.
I am unable to figure out what goes where in x & y axis and series. Any help would be much apreciated!