Hi guys, can anybody tell me how to customize my graph to show the right view? I have a table (bigger then in this sample), where in one column are my categories, which should be my X values. And then there is other column which should be my Y1 and Y2 values..
this is the sample
Y index ... X ................ Y value
Index_1 .. Category_1 ... 1
Index_1 .. Category_2 ... 2
Index_1 .. Category_3 ... 0
Index_2 .. Category_1 ... 0
Index_2 .. Category_2 ... 1
Index_2 .. Category_3 ... 1
How to achieve the graph looks like from this table without manulay rewriting it to this?
X ................ Y1 . Y2
Category_1 ... 1 ... 0
Category_2 ... 2 ... 1
Category_3 ... 0 ... 1
try to imagine this is the resulting graph I want to see

. connected with lines
2 ............................. Y1 ...............................
1 ..... Y1 ................... Y2 ................... Y2 ......
0 ..... Y2 ............................................ Y1 ......
.. Category_1 ....... Category_2 ....... Category_3