MS CHART

Question

I want to create a chart control in asp.net3.5 which will bind dynamically from database i can add it buti can not group it(ColunmStackedColunm) can anyone help Thank in advance

paul daniel · Answer

Refer this links http://weblogs.asp.net/ssnair/archive/2009/10/20/mschart-dynamic-chartarea-series-legends-etc.aspx http://www.programminghelp.com/web-development/asp-net/install-and-use-microsoft-chart-controls-to-render-a-graph-from-data-table-in-c/

Sunita Tajanpure · Answer

thanks for the reply but im using MS Chart Like this Random random = new Random(); String sSeries =; Chart1.ChartAreas[ChartArea1].AxisX.Title = Plant; Chart1.ChartAreas[ChartArea1].AxisX.IsMarginVisible = false; Chart1.ChartAreas[ChartArea1].AxisX.Maximum = 2; //Chart1.ChartAreas[ChartArea1].AxisX.Minimum = 0; Chart1.ChartAreas[ChartArea1].AxisX.Interval = 2; //Chart1.ChartAreas[ChartArea1].Area3DStyle.PointGapDepth=25; Chart1.Legends.Add(ChartArea1); for (int j = 0; j { Chart1.Legends[j].BorderColor = Color.Black; Chart1.Legends[j].BorderWidth = 1; Chart1.Legends[j].BorderDashStyle = ChartDashStyle.Solid; Chart1.Legends[j].ShadowOffset = 1; Chart1.Legends[j].LegendStyle = LegendStyle.Table; Chart1.Legends[j].TableStyle = LegendTableStyle.Auto; Chart1.Legends[j].Docking = Docking.Bottom; Chart1.Legends[j].Alignment = StringAlignment.Center; Chart1.Legends[j].Enabled = true; Chart1.Legends[j].Font = new System.Drawing.Font(Verdana 8 System.Drawing.FontStyle.Bold); Chart1.Legends[j].AutoFitMinFontSize = 5; Chart1.Legends[j].HeaderSeparator = LegendSeparatorStyle.DoubleLine; Chart1.Legends[j].HeaderSeparatorColor = Color.Gray; } //call method to get the dataset DataSet ds = CreateDataSet(); LegendItem legendItem = new LegendItem(); foreach (DataRow DRRow in ds.Tables[0].Rows) { int rowIndex = ds.Tables[0].Rows.IndexOf(DRRow); DataSet ObjDSCell = CreateCellDataSet(Convert.ToInt32(DRRow[kaizen2Q_plant_id].ToString())); foreach (DataRow DRCellRow in ObjDSCell.Tables[0].Rows) { if (DRCellRow[kaizen2Q_cell_Name].ToString() != ) { sSeries = DRCellRow[kaizen2Q_cell_Name].ToString(); if (Chart1.Series.FindByName(DRCellRow[kaizen2Q_cell_Name].ToString()) == null) { Chart1.Series.Add(sSeries); Chart1.ChartAreas[ChartArea1].AxisX.IsMarginVisible = false; Chart1.Series[sSeries].BorderWidth =1; Chart1.Series[sSeries].ChartType = SeriesChartType.Column; Chart1.Series[sSeries].IsValueShownAsLabel = true; Chart1.Series[sSeries].Points.AddY(DRCellRow[Exp1].ToString()); if (rowIndex == 1) { Chart1.Series[sSeries][StackedGroupName] = Group1; } else if (rowIndex == 2) { Chart1.Series[sSeries][StackedGroupName] = Group2; } else if (rowIndex == 3) { Chart1.Series[sSeries][StackedGroupName] = Group1; } } } } //if (rowIndex == 1) //{ // break; //} } Chart1.Series[sSeries].IsValueShownAsLabel = true; i can not get the grouping beteen the series......... Chart Should Show- kaizen count per cell for a perticuler plant e.g. for plant id=1 there are 5 cells and cell 1-kaisen count is 100cell 2 kaizen count is 20 and so on.............

kiran kumar · Answer

hello sunita check this link http://www.aspnettutorials.com/tutorials/controls/chart-compart-aspnet2-csharp.aspx mark the answer if it helps you