Chart Area

The chart area represents the entire chart area. You can set the font, background, foreground, and border for the chart control area. The chart elements use the chart area font unless specifically set.

The chart uses default values when the fill is set to automatic.

Element Default Value
Area Automatic fill
Chart Area White background
Plot Area White background
Axis Inherited from chart
Legend Inherited from chart
Data Series Generated automatically
Data Point Generated automatically
Data Label White background

The following image displays custom settings for the chart area.

Using Code

The following example sets the chart area border, background, foreground, and fonts.

  1. Add values to the control. 
  2. Create a bar chart with the SpreadChart class. 
  3. Set the appearance properties such as Fill using the SpreadChart 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 Brush foreground;

strokeThickness = 2;
stroke = new SolidColorBrush(Windows.UI.Colors.Green);
fillBrush = new SolidColorBrush(Windows.UI.Colors.Red);
foreground = new SolidColorBrush(Windows.UI.Colors.Blue);
chartFontSize = 25;
axisFontSize = 25;
fontFamily = new FontFamily("Arial Narrow");
Windows.UI.Text.FontStyle fontStyle = Windows.UI.Text.FontStyle.Italic;
Windows.UI.Text.FontWeight fontWeight = Windows.UI.Text.FontWeights.Bold;
Windows.UI.Text.FontStretch fontStretch = Windows.UI.Text.FontStretch.ExtraExpanded;

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 } });

//stroke
chart.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.Dot;
chart.StrokeThickness = strokeThickness;
chart.Stroke = stroke;
////fill
chart.Fill = fillBrush;
chart.FontSize = chartFontSize;
chart.FontFamily = FontFamily;
chart.FontStyle = fontStyle;
chart.FontWeight = fontWeight;
chart.FontStretch = fontStretch;
chart.Foreground = foreground;

gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
VB
Copy Code
Private strokeThickness As Double
Private stroke As Brush
Private fillBrush As Brush
Private chartFontSize As Double
Private axisFontSize As Double

strokeThickness = 2
stroke = New SolidColorBrush(Windows.UI.Colors.Green)
fillBrush = New SolidColorBrush(Windows.UI.Colors.Red)
foreground = New SolidColorBrush(Windows.UI.Colors.Blue)
chartFontSize = 25
axisFontSize = 25
fontFamily = New FontFamily("Arial Narrow")

FontStyle = Windows.UI.Text.FontStyle.Italic
FontWeight = Windows.UI.Text.FontWeights.Bold
FontStretch = Windows.UI.Text.FontStretch.ExtraExpanded

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}})

'stroke
chart.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.Dot
chart.StrokeThickness = strokeThickness
chart.Stroke = stroke
'fill
chart.Fill = fillBrush
chart.FontSize = chartFontSize
chart.FontFamily = fontFamily
chart.FontStyle = FontStyle
chart.FontWeight = FontWeight
chart.FontStretch = FontStretch
chart.Foreground = foreground

GcSpreadSheet1.ActiveSheet.Charts.Add(chart)

 

 


Copyright © GrapeCity, inc. All rights reserved.