A plot area is the graphics area in which data points (bars, points, lines) are drawn. A plot area will contain a collection of series. Each series is a collection of data points. A plot area may also contain an axis(s). The axis(s) enhances the visual appearance of the plot area and is usually painted just outside the plot area.
You can set the background and border for the plot area.
Using Code
The following example sets a background for the plot area.
-
Add values to the control with the SetArray method.
-
Create a bar chart with the SpreadChart class.
-
Set the plot area properties such as Fill using the PlotArea class.
-
Add the chart.
| CS |
Copy Code |
|---|---|
| private double strokeThickness; private Brush stroke; private Brush fillBrush; strokeThickness = 2; stroke = new SolidColorBrush(Windows.UI.Colors.Green); fillBrush = new SolidColorBrush(Windows.UI.Colors.Red); 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.PlotArea.Stroke = stroke; chart.PlotArea.StrokeThickness = strokeThickness; chart.PlotArea.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.LongDash; chart.PlotArea.Fill = fillBrush; gcSpreadSheet1.ActiveSheet.Charts.Add(chart); | |
| VB |
Copy Code |
|---|---|
| Private strokeThickness As Double Private stroke As Brush Private fillBrush As Brush strokeThickness = 2 stroke = New SolidColorBrush(Windows.UI.Colors.Green) fillBrush = New SolidColorBrush(Windows.UI.Colors.Red) 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.PlotArea.Stroke = stroke chart.PlotArea.StrokeThickness = strokeThickness chart.PlotArea.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.LongDash chart.PlotArea.Fill = fillBrush GcSpreadSheet1.ActiveSheet.Charts.Add(chart) | |
See Also