Add other dataset to display a combination chart

Question

Chart chart1 = new Chart();  //ChartFX
chart1.DataSourceSettings.DataSource = dset.Tables[0];
chart1.Data.Series = 2;
DataSetDataValuesTableAdapters.DataValuesTableAdapter adapter = 
    new DataSetDataValuesTableAdapters.DataValuesTableAdapter();
DataSetDataValuesTableAdapters.DataValuesTableAdapter adapter2 = 
    new DataSetDataValuesTableAdapters.DataValuesTableAdapter();
DataSet dset = new DataSet();
DataTable datos1 = adapter.GetDataCaudal();
DataTable datos2 = adapter2.GetDataByPluvio();

dset.Tables.Add(datos1);
dset.Tables[0].TableName = "Table1";
dset.Tables.Add(datos2);
dset.Tables[1].TableName = "Table2";

I can only display one data series in the chartFX chart. I need to connect another DataSource to the chart so I can display two series of data combined.

Here's an example of what I want to get:

Is there anyone who can help me?

What kind of chart are you using? – MrFox Feb 25 '13 at 18:19 — MrFox, Feb 25 '13 at 18:19
I am using chartfx, type bar or line chart. – juanchoelx Feb 26 '13 at 09:17 — juanchoelx, Feb 26 '13 at 09:17

score 1 · Accepted Answer · answered Feb 28 '13 at 11:43

I don't have this module so I can't test any code. But it seems you should make a combination chart: http://community.softwarefx.com/forums/p/8501/19692.aspx

First you need to create a crosstab to pass the data to this chart so that a series is created for each distinct value in the Product Column (Column Header). Check the programmer's guide on the Cross Tab provider for more details. You can also do this using the Chart FX Wizard.

After the data is setup, all you need to do is set the gallry for each series. You can do this in code or using the property grid at desing-time. In code it's something like:
chart.AllSeries.Gallery = Gallery.Bar;

chart.Series[2].Gallery = Gallery.Lines; // Third series is the Line

Add other dataset to display a combination chart

1 Answers1