UltraWebChart - how to add data from a datasource to Composite Chart Bar and Line

310

John posted over 15 years ago

I need to put a line graph on top of this graph - so i know it will be a composite but i am not sure how to create the series from a TableAdapter -

THis is the way i formated the Series for the Column Chart

ColumnChart.Axis.X.Labels.SeriesLabels.FormatString = "Fiscal\nMonth\n<SERIES_LABEL>";

Thanks

Parents

10880

Verified Answer
[Infragistics] Sung Kim posted over 15 years ago

Take a look at the following help articles for creating composite charts. As far as providing data to the series objects, it can work in bound or unbound mode as shown in the link:

http://help.infragistics.com/Help/NetAdvantage/NET/2008.3/CLR2.0/html/Chart_Creating_a_Composite_Chart_in_Code_Part_1_of_2.html

Full set of articles for composite charts in documentation:

http://help.infragistics.com/Help/NetAdvantage/NET/2008.3/CLR2.0/html/Chart_Creating_a_Composite_Chart.html
Cancel
Reply

Reject Answer

Cancel
310

John posted over 15 years ago in reply to [Infragistics] Sung Kim

G'day Sung Kim,

Thanks for the info - I will let you know if i get into any trouble.

Are there any tutorials that show how to use a composite chart using DALs and BLLs? These charts are customer specific and on the page two parms are passed customerID and UtilityID so i have to take that into consideration too.

thanks
Cancel
Reply

Cancel
10880

[Infragistics] Sung Kim posted over 15 years ago in reply to John

When using composite charts, only Series objects can be used to provide the chart data. In the above link, it shows how to use it in bound mode, to a DataTable or unbound, where you add items yourself.
Cancel
Reply

Cancel
310

John posted over 15 years ago in reply to [Infragistics] Sung Kim

Thanks so much - i think i have it now!really appreciate your help
Cancel
Reply

Cancel
310

John posted over 15 years ago in reply to John

Ok, need your help Sung Kim - bleow is the code i have and i cannot seem to get the format the same as the graph above.

Thanks,

private static DataTable GetData()
{
DataTable table = new DataTable();

table.Columns.Add("2007", typeof(double));
table.Columns.Add("2008", typeof(double));
table.Columns.Add("2009", typeof(double));
table.Columns.Add("Fiscal_Month", typeof(string));
table.Rows.Add(new object[ {650579.2369,808624.9300,573754.2836,"1"});
table.Rows.Add(new object[ {589199.8713,741965.9000,573754.2836,"2"});
table.Rows.Add(new object[ {573754.2836,595874.5600,645298.4217,"3"});
table.Rows.Add(new object[ {543837.1542,707583.6500,1124153.0300,"4"});
table.Rows.Add(new object[ {615242.8208,704190.2300,null,"5"});
table.Rows.Add(new object[ {645298.4217,666165.3000,null,"6"});
table.Rows.Add(new object[ {680309.9463,781644.4200,null,"7"});
table.Rows.Add(new object[ {818392.0109,1022916.2200,null,"8"});
table.Rows.Add(new object[ {543837.1542,1124153.0300,null,"9"});
table.Rows.Add(new object[ {792058.6090,1124153.0300,null,"10"});
table.Rows.Add(new object[ {852305.4100,1160035.0600,null,"11"});
table.Rows.Add(new object[ {950394.0800,1043649.7800,null,"12"});
return table;
}

private static NumericSeries GetNumericSeriesBound()
{
NumericSeries series = new NumericSeries();
series.Label = "Fiscal\nMonth\n<SERIES_LABEL>";

// this code populates the series from an external data source
DataTable table = GetData();
series.Data.DataSource = table;
series.Data.ValueColumn = "2007";
series.Data.ValueColumn = "2008";
series.Data.ValueColumn = "2009";
series.Data.LabelColumn = "Label Column";
return series;
}

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (User.IsInRole("Administrator") || User.IsInRole("CustomerAdmin"))CreateUser.Visible = true;
}

this.FiscalInputCostChart.ChartType = ChartType.Composite;
ChartArea myChartArea = new ChartArea();
this.FiscalInputCostChart.CompositeChart.ChartAreas.Add(myChartArea);
AxisItem axisX = new AxisItem();
axisX.OrientationType = AxisNumber.X_Axis;
axisX.DataType = AxisDataType.String;
axisX.SetLabelAxisType = SetLabelAxisType.GroupBySeries;
axisX.Labels.ItemFormatString = "<ITEM_LABEL>";
axisX.Labels.Orientation = TextOrientation.VerticalLeftFacing;
AxisItem axisY = new AxisItem();
axisY.OrientationType = AxisNumber.Y_Axis;
axisY.DataType = AxisDataType.Numeric;
axisY.Labels.ItemFormatString = "<DATA_VALUE:0.#>";
myChartArea.Axes.Add(axisX);

myChartArea.Axes.Add(axisY);

NumericSeries seriesA = GetNumericSeriesBound();this.FiscalInputCostChart.CompositeChart.Series.Add(seriesA);

ChartLayerAppearance myColumnLayer = new ChartLayerAppearance();myColumnLayer.ChartType = ChartType.ColumnChart;
myColumnLayer.ChartArea = myChartArea;

myColumnLayer.AxisX = axisX;

myColumnLayer.AxisY = axisY;

myColumnLayer.Series.Add(seriesA);
this.FiscalInputCostChart.CompositeChart.ChartLayers.Add(myColumnLayer);

}
Cancel
Reply

Cancel
10880

[Infragistics] Sung Kim posted over 15 years ago in reply to John

gcwatson said:
series.Data.ValueColumn = "2007";
series.Data.ValueColumn =
"2008";
series.Data.ValueColumn =
"2009";

You are setting the same property 3 times. Instead create 3 different series objects each with one of those ValueColumn settings.
Cancel
Reply

Cancel

Reply

310

John posted over 15 years ago in reply to [Infragistics] Sung Kim

Hey Sung Kim,

It is building the graph but not in the order that I needed - I guess i am still missing somthing,'

private static DataTable GetData()
{
DataTable table = new DataTable();

table.Columns.Add("2007", typeof(double));
table.Columns.Add("2008", typeof(double));
table.Columns.Add("2009", typeof(double));
table.Columns.Add("Fiscal_Month", typeof(string));
table.Rows.Add(new object[ {650579.2369,808624.9300,573754.2836,"1"});
table.Rows.Add(new object[ {589199.8713,741965.9000,573754.2836,"2"});
table.Rows.Add(new object[ {573754.2836,595874.5600,645298.4217,"3"});
table.Rows.Add(new object[ {543837.1542,707583.6500,1124153.0300,"4"});
table.Rows.Add(new object[ {615242.8208,704190.2300,null,"5"});
table.Rows.Add(new object[ {645298.4217,666165.3000,null,"6"});
table.Rows.Add(new object[ {680309.9463,781644.4200,null,"7"});
table.Rows.Add(new object[ {818392.0109,1022916.2200,null,"8"});
table.Rows.Add(new object[ {543837.1542,1124153.0300,null,"9"});
table.Rows.Add(new object[ {792058.6090,1124153.0300,null,"10"});
table.Rows.Add(new object[ {852305.4100,1160035.0600,null,"11"});
table.Rows.Add(new object[ {950394.0800,1043649.7800,null,"12"});
return table;
}

private static NumericSeries GetNumericSeriesBound()
{
NumericSeries series = new NumericSeries(); series.Label = "Fiscal_Month";
// this code populates the series from an external data source
DataTable table = GetData();
series.Data.DataSource = table;
series.Data.ValueColumn = "2007";return series;
}
private static NumericSeries GetNumericSeriesBound2()
{

NumericSeries series = new NumericSeries();
series.Label = "Fiscal_Month";
// this code populates the series from an external data source
DataTable table = GetData();
series.Data.DataSource = table;
series.Data.ValueColumn = "2008";return series;
}
private static NumericSeries GetNumericSeriesBound3()
{

NumericSeries series = new NumericSeries();
series.Label = "Fiscal_Month";
// this code populates the series from an external data source
DataTable table = GetData();
series.Data.DataSource = table;
series.Data.ValueColumn = "2009";return series;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{

if (User.IsInRole("Administrator") || User.IsInRole("CustomerAdmin"))
CreateUser.Visible = true;
}

this.FiscalInputCostChart.ChartType = ChartType.Composite;
ChartArea myChartArea = new ChartArea();
this.FiscalInputCostChart.CompositeChart.ChartAreas.Add(myChartArea);
AxisItem axisX = new AxisItem();
axisX.OrientationType = AxisNumber.X_Axis;
axisX.DataType = AxisDataType.String;
axisX.SetLabelAxisType = SetLabelAxisType.GroupBySeries;
axisX.Labels.ItemFormatString = "<ITEM_LABEL>";
axisX.Labels.Orientation = TextOrientation.VerticalLeftFacing;
AxisItem axisY = new AxisItem();
axisY.OrientationType = AxisNumber.Y_Axis;
axisY.DataType = AxisDataType.Numeric;
axisY.Labels.ItemFormatString = "<DATA_VALUE:0.#>";
myChartArea.Axes.Add(axisX);

myChartArea.Axes.Add(axisY);

NumericSeries seriesA = GetNumericSeriesBound();
NumericSeries seriesB = GetNumericSeriesBound2();
NumericSeries seriesC = GetNumericSeriesBound3();
this.FiscalInputCostChart.CompositeChart.Series.Add(seriesA);
this.FiscalInputCostChart.CompositeChart.Series.Add(seriesB);
this.FiscalInputCostChart.CompositeChart.Series.Add(seriesC);
ChartLayerAppearance myColumnLayer = new ChartLayerAppearance();myColumnLayer.ChartType = ChartType.ColumnChart;
myColumnLayer.ChartArea = myChartArea;

myColumnLayer.AxisX = axisX;

myColumnLayer.AxisY = axisY;

myColumnLayer.Series.Add(seriesA);

myColumnLayer.Series.Add(seriesB);

myColumnLayer.Series.Add(seriesC);
this.FiscalInputCostChart.CompositeChart.ChartLayers.Add(myColumnLayer);
}
Cancel
Reply

Cancel

Children

10880

[Infragistics] Sung Kim posted over 15 years ago in reply to John

You are going to have to either invert your data, columns become rows and rows become columns, or make a series for each row.
Cancel
Reply

Cancel