for example,
Series 1: X: P1 P1 P2
Y 2 3 4
Series 2 X:P1 P1 P2
Y: 5 6 7
If they are plotted in graph as bar series. I expected the plot order as (series1 ->P1,2) (series2->P1,5) (series 1->P1,3) (series 2->P1,6) (series1 ->P2,4) (series2 ->P2,7) . that means all the P1 category will be grouped together and has the value order as (2,5,3,6). And P2 category has value order(4,7)
but actually, it looks like P1 category has the value order as (2,3,5,6) and P2 category has value order(4,7)
in order to achieve what I want, I have to flatten the two series (series1 and series 2) into one series. But that approach is not exactly what I want. Thank you