Interchanging rows and columns in Chart

[gopikrish]

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

My table is like this,

Frequency Total Pass   Total Fail

Nov 1-7   33 16

Nov 8-14   44 23

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

But I want my row and column data from table interchanged.

To be clear, right now my row data in table (i.e. Nov 1-7, Nov 8-14 etc..) is displayed in Chart in X-axis

And different categories like "Total Pass", "Total Fail" etc is shown in Bar in different colors.

But what I want is, I want chart to display different categories like "Total Pass", "Total Fail" in X-axis in place of frequency.

And different bars for different frequencies like one for Nov 1-7 etc..

 

How to do this. Thanks in advance.