Spread WPF 17
Spread WPF Documentation / Developer's Guide / Working with Charts / Understanding Charts / Plot Area
In This Topic
    Plot Area
    In This Topic

    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.

    Plot area with a red background and a green border

    Using Code

    The following example sets a background for the plot area.

    1. Add values to the control with the SetArray method.
    2. Create a bar chart with the SpreadChart class.
    3. Set the plot area properties such as Fill using the PlotArea class.
    4. Add the chart.
    CS
    Copy Code
    private double strokeThickness;
    private Brush stroke;
    private Brush fillBrush;
    private double chartFontSize;
    private double axisFontSize;
    private FontFamily fontFamily;
    private FontStyle fontStyle;
    private FontWeight fontWeight;
    private FontStretch fontStretch;
    private Brush foreground;

    strokeThickness = 2;
    stroke = new SolidColorBrush(Colors.Green);
    fillBrush = new SolidColorBrush(Colors.Red);

    GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.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.Windows.SpreadSheet.Data.StrokeDashType.LongDashDotDot;
    chart.PlotArea.Fill = fillBrush;

    gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
    VB.NET
    Copy Code
    Private strokeThickness As Double
    Private stroke As Brush
    Private fillBrush As Brush
    Private chartFontSize As Double
    Private axisFontSize As Double
    Private fontFamily As FontFamily
    Private fontStyle As FontStyle
    Private fontWeight As FontWeight
    Private fontStretch As FontStretch
    Private foreground As Brush

    strokeThickness = 2
    stroke = New SolidColorBrush(Colors.Green)
    fillBrush = New SolidColorBrush(Colors.Red)

    Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.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.Windows.SpreadSheet.Data.StrokeDashType.LongDashDotDot
    chart.PlotArea.Fill = fillBrush
    GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
    See Also
    SpreadChartElement Class