My data is below. Basically, I have 10 deciles and three sets of scores (x, y, and z). I've split the scores into min & max for each decile (1=min, 2=max...hence x1 = min x score for each decile). I'd like to create something similar to a stock chart that shows three lines for each decile, representing the range for each score. My x-axis categories would be 1-10 (decile). My y-axis categories would be the score. There would be three vertical lines for each decile.
I think the easiest way would be using a stacked column chart & I was able to do this for one score, but wasn't able to determine how to show three separate stacked columns for each decile.
Decile x1 x2 y1 y2 z1 z2
1 0 1 0 4 0 1
2 1 3 4 7 1 2
3 3 6 7 9 2 6
4 6 7 9 11 6 10
5 7 11 11 16 10 11
6 11 13 16 18 11 15
7 13 15 18 22 15 17
8 15 18 22 25 17 21
9 18 20 25 29 21 25
10 20 25 29 34 25 28
I think the easiest way would be using a stacked column chart & I was able to do this for one score, but wasn't able to determine how to show three separate stacked columns for each decile.
Decile x1 x2 y1 y2 z1 z2
1 0 1 0 4 0 1
2 1 3 4 7 1 2
3 3 6 7 9 2 6
4 6 7 9 11 6 10
5 7 11 11 16 10 11
6 11 13 16 18 11 15
7 13 15 18 22 15 17
8 15 18 22 25 17 21
9 18 20 25 29 21 25
10 20 25 29 34 25 28