View Single Post
 
Old 06-25-2014, 04:33 AM
bendi bendi is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Jun 2014
Posts: 2
bendi is on a distinguished road
Default Custom Line Graph x, y1, y2

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
Reply With Quote