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.ChartTitle = new GrapeCity.Xaml.SpreadSheet.Data.ChartTitle(); chart.AxisX.Text = "-1234"; //stroke chart.AxisX.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.DashDot; chart.AxisX.StrokeThickness = 2; chart.AxisX.Stroke = new SolidColorBrush(Windows.UI.Colors.Cyan); //fill chart.AxisX.Fill = new SolidColorBrush(Windows.UI.Colors.Red); //font chart.AxisX.FontSize = 12; chart.AxisX.FontFamily = FontFamily; chart.AxisX.FontStyle = Windows.UI.Text.FontStyle.Italic; chart.AxisX.FontWeight = Windows.UI.Text.FontWeights.Bold; chart.AxisX.FontStretch = Windows.UI.Text.FontStretch.ExtraExpanded; chart.AxisX.Foreground = new SolidColorBrush(Windows.UI.Colors.Blue); chart.AxisX.LineCapType = PenLineCap.Round; chart.AxisX.LineJoinType = PenLineJoin.Bevel; chart.AxisX.LabelAngle = 60; chart.AxisX.LabelFormatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("##.00"); chart.AxisX.Reversed = true; chart.AxisX.LogBase = 100; chart.AxisX.UseLogBase = 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.ChartTitle = New GrapeCity.Xaml.SpreadSheet.Data.ChartTitle() chart.AxisX.Text = "-1234" 'stroke chart.AxisX.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.DashDot chart.AxisX.StrokeThickness = 2 chart.AxisX.Stroke = New SolidColorBrush(Windows.UI.Colors.Cyan) 'fill chart.AxisX.Fill = New SolidColorBrush(Windows.UI.Colors.Red) 'font chart.AxisX.FontSize = 12 chart.AxisX.FontFamily = FontFamily chart.AxisX.FontStyle = Windows.UI.Text.FontStyle.Italic chart.AxisX.FontWeight = Windows.UI.Text.FontWeights.Bold chart.AxisX.FontStretch = Windows.UI.Text.FontStretch.ExtraExpanded chart.AxisX.Foreground = New SolidColorBrush(Windows.UI.Colors.Blue) chart.AxisX.LineCapType = PenLineCap.Round chart.AxisX.LineJoinType = PenLineJoin.Bevel chart.AxisX.LabelAngle = 60 chart.AxisX.LabelFormatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("##.00") chart.AxisX.Reversed = True chart.AxisX.LogBase = 100 chart.AxisX.UseLogBase = True GcSpreadSheet1.ActiveSheet.Charts.Add(chart)