I am trying to setup the Datasource for a Column / Line Chart so I can show monthly quantities as columns, and a trend line. Here is my data:
Unfortunately, the Column / Line sample code is incomprehensible to me. I am able to create a Column chart with the following code. How do I change this code for a Column / Line chart where Quantity is the columns & ThreeMoAvg is the line? Thanks!
public struct Hist { public string Month; public float Quantity; public float ThreeMoAvg; }
private Hist[ arrHist;
private void buttonDmdHist_Click(object sender, EventArgs e) { // hide the chart this.ultraChartResults.Visible = false;
//attach the history to the chart this.ultraChartResults.DataSource = this.GetHistDataTable(); this.ultraChartResults.DataBind();
// setup X labels this.ultraChartResults.Axis.X.Labels.Visible = false; this.ultraChartResults.Axis.X.Labels.SeriesLabels.Visible = true; this.ultraChartResults.Axis.X.Labels.SeriesLabels.Orientation = Infragistics.UltraChart.Shared.Styles.TextOrientation.VerticalLeftFacing;
// show the chart this.ultraChartResults.Visible = true; }
private DataTable GetHistDataTable() { // Turn the array into a datatable DataTable retDT = new DataTable(); retDT.Columns.Add("Month", typeof(String)); retDT.Columns.Add("Quantity", typeof(Single)); for (int index = 0; index < this.arrHist.Length; index++) retDT.Rows.Add(new Object[ { this.arrHist[index].Month, this.arrHist[index].Quantity }); return retDT; }
DataTable dt = new DataTable();dt.Columns.Add("col1", typeof(string));dt.Columns.Add("col2", typeof(int));dt.Columns.Add("col3", typeof(int));dt.Rows.Add(new object[ { "J 03", 1208, 1208 });dt.Rows.Add(new object[ { "F 03", 1156, 1182 });dt.Rows.Add(new object[ { "M 03", 1277, 1214 });dt.Rows.Add(new object[ { "A 03", 1253, 1229 });dt.Rows.Add(new object[ { "M 03", 1246, 1259 });dt.Rows.Add(new object[ { "J 03", 1160, 1220 });dt.Rows.Add(new object[ { "J 03", 1227, 1211 });
this.ultraChart1.ColumnLineChart.ColumnData.DataSource = dt;this.ultraChart1.ColumnLineChart.ColumnData.IncludeColumn("col3", false);this.ultraChart1.ColumnLineChart.ColumnData.DataBind();this.ultraChart1.ColumnLineChart.LineData.DataSource = dt;this.ultraChart1.ColumnLineChart.LineData.IncludeColumn("col2", false);this.ultraChart1.ColumnLineChart.LineData.SwapRowsAndColumns = true;this.ultraChart1.ColumnLineChart.LineData.DataBind();