Hi to all,
I can't find a way to create a line chart by having all the yellow values in the X axis (it takes only the first line of yellow) and of course all the other values in Y axis. But mostly my problem is that I can't find a way to add two different rows countinuously (1,2,3,4,5,6,7,8,9 and10,11,12,13,14,15,16,17,18) in X axis.
Can anyone help me
Thanks in advance
I can't find a way to create a line chart by having all the yellow values in the X axis (it takes only the first line of yellow) and of course all the other values in Y axis. But mostly my problem is that I can't find a way to add two different rows countinuously (1,2,3,4,5,6,7,8,9 and10,11,12,13,14,15,16,17,18) in X axis.
Can anyone help me
Thanks in advance
TZOKER.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | ||
2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||
3 | 18 | 41 | 27 | 26 | 24 | 33 | 18 | 25 | 9 | ||
4 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | ||
5 | 12 | 15 | 17 | 19 | 21 | 38 | 47 | 28 | 19 | ||
Sheet3 |