Custom Line Graph x, y1, y2

[bendi]

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

[gebobs]

I think you will have to rearrange your data. That shouldn't be too hard and you might be able to create a macro to do it for you.

[bendi]

Thank you gebobs for your answer. I think I would be able to write some code in VBA Excel, but I hoped it can be done with some build-in functionality of excel graphs. But anyway thanks for the answer and if someone have an idea how to achieve it with only choosing the right graph and it's settings please write it here..