Interface IChartBorder

Namespace

Spire.Xls.Core

Assembly

Spire.XLS.dll

Represents chart border. Provides Border options for Chart Area and Plot Area.

public interface IChartBorder

Properties

Color

Color of line. The following code illustrates the use of Color property:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart and set range
IChart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["B2:C6"];

//Set line color for chart area border
chart.ChartArea.Border.Color = Color.DarkOrange;

//Save to file
workbook.SaveToFile("Chart.xlsx");

Color Color { get; set; }

Property Value

Color

KnownColor

Line color index.

ExcelColors KnownColor { get; set; }

Property Value

ExcelColors

Pattern

Line pattern. The following code illustrates the use of LinePattern property:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart and set range
IChart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["B2:C6"];

//Set line pattern for plot area border
chart.ChartArea.Border.Pattern = ChartLinePatternType.DashDotDot;

//Save to file
workbook.SaveToFile("Chart.xlsx");

ChartLinePatternType Pattern { get; set; }

Property Value

ChartLinePatternType

Transparency

Returns the transparency level of the specified Solid color shaded XlsFill as a floating-point value from 0.0 (Clear) through 1.0(Opaque). The following code illustrates the use of Weight property:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart and set range
IChart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["B2:C6"];

//Set the transparency level of the solid color
chart.ChartArea.Border.Transparency =0.85;
chart.ChartArea.Border.Color = Color.Red;

//Save to file
workbook.SaveToFile("Chart.xlsx");

double Transparency { get; set; }

Property Value

double

UseDefaultFormat

If true - default format; otherwise custom.

bool UseDefaultFormat { get; set; }

Property Value

bool

UseDefaultLineColor

Custom format for line color.

bool UseDefaultLineColor { get; set; }

Property Value

bool

Weight

Weight of line. The following code illustrates the use of Weight property:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Create chart and set range
IChart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["B2:C6"];

//Set line weight for plot area border
chart.ChartArea.Border.Weight = ChartLineWeightType.Wide;

//Save to file
workbook.SaveToFile("Chart.xlsx");

ChartLineWeightType Weight { get; set; }

Property Value

ChartLineWeightType