private void ReportServices_DailyGrab_GenVehicleData_VinChgEnergyHist(Vehicles v, int WeekNumber, int YearNumber) { GetChartData gd = new GetChartData(); DataTable DtRange = gd.GetDateRangeFromWeekNumber(WeekNumber, YearNumber); DataTable dataTable = gd.Dt_DailyGrab_GetVenChgEnergyHist(v.VinID, WeekNumber, YearNumber, Rounding); string mainTitle = string.Format("Chrg Energy kWh - {0} - {1} ", Convert.ToDateTime(DtRange.Rows[0]["StartDate"]).ToString("d"), Convert.ToDateTime(DtRange.Rows[0]["EndDate"]).ToString("d")); string subTitle = string.Format("{0} - {1}", v.CustomerName, v.Vin); hcFrutas.Title = new Title(mainTitle); hcFrutas.SubTitle = new SubTitle(subTitle); hcFrutas.Theme = "grid"; hcFrutas.Legend = new Legend { align = Align.right, layout = Layout.vertical, verticalAlign = VerticalAlign.top, x = -10, y = 70, borderWidth = 0 }; hcFrutas.Appearance = new Appearance { renderTo = "container", animation = false }; hcFrutas.YAxis.Add(new YAxisItem { title = new Title("Chrg Energy kWh") }); //Get point collection var pointCollectionChgEnergy = new PointCollection(); var pointCollectionCat = new PointCollection(); //var pointCollectionSocMax = new PointCollection(); //var pointCollectionSocDas = new PointCollection(); List<string> buckets = new List<string>(); // Add string using Add method foreach (DataRow row in dataTable.Rows) { pointCollectionChgEnergy.Add(new Point(Convert.ToDouble(row["Chg_Energy_kwh"]))); buckets.Add(row["ProcessDate"].ToString()); } //Add data to serie hcFrutas.XAxis.Add(new XAxisItem { type = AxisDataType.linear, tickColor = "#ccc", categories = buckets.ToArray(), tickLength = 1, title = new Title("Date") }); var series = new Collection<Serie> { new Serie { name = "Chrg Energy kWh", data = pointCollectionChgEnergy.ToArray(), type = RenderType.column, showInLegend = false } }; //hcVendas.PlotOptions = new PlotOptionsLine { marker = new Marker { enabled = true }, dataLabels = new DataLabels { enabled = true } }; hcFrutas.PlotOptions = new PlotOptionsColumn { groupPadding = 0, pointPadding = 0, shadow = true, borderWidth = 2, borderColor = "#666", dataLabels = new DataLabels { enabled = true } }; //Bind the control hcFrutas.DataSource = series; hcFrutas.DataBind(); }