MS charts data binding in Reverse order
Posted on 2012-09-17
I'm using bar charts to represent data from an array for y axis values and for x axis the i'm using an array with hard coded names. I could able to get the chart but the problem is the x axis data and y axis values are not matching. X axis values are in bottom to top order and y axis values are from top to bottom.
Ex: Suppose i have an array with the following names X, Y and Z for the x- axis and i'm binding the y-axis values as 1.0,2.2,3.3 from the array.
the result i should get is in the order X -1.0, Y-2.2, Z-3.3. But the result i'm getting is in the order Z-3.3,Y-2.2, X-1.0. There is no problem with the data. I want the order to be in X,Y and Z rather than Z, Y and X.
I tried by giving the x.axis values in reverse order i.e Z, Y and X. But the problem with that is the data is not matching with the correct values. I tried and i couldn't resolve the issue.
Could You please help me to resolve the issue?
Thanks in advance.