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

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
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
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
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
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