GrapeCity.Xaml.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0,0, 200, 200); gcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 1 }, { 2 }, { 3 }, { 4 }, { 5 }, { 6 }, { 7 }, { 8 }, { 9 }, { 10 } }); chart.AxisY.DisplayUnit = 100; chart.AxisX.Min = 2; chart.AxisX.Max = 5; chart.AxisX.AutoMin = true; chart.AxisX.AutoMax = true; chart.AxisX.MinorUnit = 2; chart.AxisX.MajorUnit = 3; chart.AxisX.LabelFormatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("mm/dd/yyyy"); chart.AxisX.LabelAngle = 30; chart.AxisX.AutoBaseTimeUnit = true; gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
Dim chart As New GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0, 0, 200, 200) GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New Object(,) {{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}}) chart.AxisY.DisplayUnit = 100 chart.AxisX.Min = 2 chart.AxisX.Max = 5 chart.AxisX.AutoMin = True chart.AxisX.AutoMax = True chart.AxisX.MinorUnit = 2 chart.AxisX.MajorUnit = 3 chart.AxisX.LabelFormatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("mm/dd/yyyy") chart.AxisX.LabelAngle = 30 chart.AxisX.AutoBaseTimeUnit = True GcSpreadSheet1.ActiveSheet.Charts.Add(chart)