Multiple series on the same chart with databinding

[anpi]

Hi,

 I'm a beginner with ChartFX and I have some troubles to do what I want to do.

 I Have a dataview with the following datas :

Market  Category date   Number Value

22 1     08/18/2009 00:00:00:000         1   0.0011213670772462922 1    09/11/2009 00:00:00:000       26     0.99870588321236822 1      10/04/2009 00:00:00:000     50    0.00017274971038618922          2 08/17/2009 00:00:00:000           0    0.0011213670772462922             2       08/28/2009 00:00:00:000          11 0.99870588321236822          2 09/11/2009 00:00:00:000          26   0.00017274971038618922          3     08/17/2009 00:00:00:000           0     0.0011213670772462922           3 09/08/2009 00:00:00:000    23    0.99870588321236822           3     09/15/2009 00:00:00:000    30    0.00017274971038618922 4 08/18/2009 00:00:00:000      1        0.0011213670772462922 4     09/23/2009 00:00:00:000    38       0.99870588321236822           4    10/15/2009 00:00:00:000          61       0.000172749710386189

What I want to have :

4 series, one for each category ( cat. 1, cat 2, cat 3, cat 4 )

For each serie, a chart with Yaxis : Value and Xaxis : Number

 

So I filter my dataview to have only the data for each market / category :

this.gDataView.RowFilter = "Market = 22 AND category = 1";

I prepare the chart to receive the data ( first serie )

Chart1.DataSourceSettings.DataType[0] = DataType.NotUsed;Chart1.DataSourceSettings.DataType[1] = DataType.NotUsed;Chart1.DataSourceSettings.DataType[2] = DataType.NotUsed;Chart1.DataSourceSettings.DataType[3] = DataType.Label;Chart1.DataSourceSettings.DataType[4] = DataType.Value;

And I link :

Chart1.DataSourceSettings.DataSource = this.gDataView;

And it works, I have my first serie 

And I dont know how to do to have the 3 others series on the same chart...

Can somebody help me, please ?

 

[AndreG]

 Take a look at the CrossTab chapter of your Programmer's Guide. I believe that is what you are trying to do.

[anpi]

 Hi Andre G,

 Thank you for your answer, it helped me to understand the context and to realize what I was supposed to.

For the other beginners on Chart Fx, here is the code that I have implemented :

  // Crosstab Settings   SoftwareFX.ChartFX.Data.CrosstabDataProvider cfxCT = new SoftwareFX.ChartFX.Data.CrosstabDataProvider();   // Indique ce que le CrosstabDataProvider doit faire avec chacune des donn