Changing X-axis to be grouped by column[1],2,3 instead of column[0] ?

[gopikrish]

Hi,

In chartfx, I am using ChartFX.Gallery.Bar type to display my table data.

My table is like this,

Frequency Total Pass   Total Fail Total Abandons========  ======== ======= ===========

Nov 1-7   33 16 5Nov 8-14   44 23    8

I am binding the DataSet resultset from this table to Chart object in asp.net webform in C#

I want my X-axis to be grouped by "Total Pass", "Total Fail", "Total Abandons" instead of grouped by "Frequency".

To be clear, right now in X-axis, "Total Pass", "Total Fail", "Total Abandons" are grouped by "Frequency"That is first set (for Nov 1-7) has 3 bars one for "Total Pass", "Total Fail", "Total Abandons" each.And similarly, second set (for Nov 8-14) has 3 bars one for "Total Pass", "Total Fail", "Total Abandons" each.

But what I want is, first set (for "Total Pass") has 2 bars one for "Nov 1-7", "Nov 8-14" each.Second set (for "Total Fail") has 2 bars one for "Nov 1-7", "Nov 8-14" each.Third set (for "Total Abandons") has 2 bars one for "Nov 1-7", "Nov 8-14" each.

So I guess by default its showing x-axis in chart grouped by frequency. Is it possible to change in chart or is it only possible to change the backend table format?Hope its clear. Thanks in advance.