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.AxisX.MajorGridlinesStroke = new SolidColorBrush(Windows.UI.Colors.Red); chart.AxisX.MajorGridlinesStrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.Dash; chart.AxisX.MajorGridlinesStrokeThickness = 2; chart.AxisX.MajorTickHeight = 10; chart.AxisX.MajorTickPosition = GrapeCity.Xaml.SpreadSheet.Data.AxisTickPosition.Cross; chart.AxisX.MajorTickStroke = new SolidColorBrush(Windows.UI.Colors.Yellow); chart.AxisX.MajorTickThickness = 2; chart.AxisY.MajorGridlinesStroke = new SolidColorBrush(Windows.UI.Colors.Orange); chart.AxisY.MajorGridlinesStrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.LongDashDot; chart.AxisY.MajorGridlinesStrokeThickness = 2; chart.AxisY.MajorTickHeight = 10; chart.AxisY.MajorTickPosition = GrapeCity.Xaml.SpreadSheet.Data.AxisTickPosition.Cross; chart.AxisY.MajorTickStroke = new SolidColorBrush(Windows.UI.Colors.Magenta); chart.AxisY.MajorTickThickness = 2; 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.AxisX.MajorGridlinesStroke = New SolidColorBrush(Windows.UI.Colors.Red) chart.AxisX.MajorGridlinesStrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.Dash chart.AxisX.MajorGridlinesStrokeThickness = 2 chart.AxisX.MajorTickHeight = 10 chart.AxisX.MajorTickPosition = GrapeCity.Xaml.SpreadSheet.Data.AxisTickPosition.Cross chart.AxisX.MajorTickStroke = New SolidColorBrush(Windows.UI.Colors.Yellow) chart.AxisX.MajorTickThickness = 2 chart.AxisY.MajorGridlinesStroke = New SolidColorBrush(Windows.UI.Colors.Orange) chart.AxisY.MajorGridlinesStrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.LongDashDot chart.AxisY.MajorGridlinesStrokeThickness = 2 chart.AxisY.MajorTickHeight = 10 chart.AxisY.MajorTickPosition = GrapeCity.Xaml.SpreadSheet.Data.AxisTickPosition.Cross chart.AxisY.MajorTickStroke = New SolidColorBrush(Windows.UI.Colors.Magenta) chart.AxisY.MajorTickThickness = 2 GcSpreadSheet1.ActiveSheet.Charts.Add(chart)