IChartInterior Interface |
Represents the chart interior. Interior of chart is supported in Chart area and Plot area only.
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The IChartInterior type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
BackgroundColor |
Background color (RGB).
Examples
The following code illustrates the use of BackgroundColor property:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Cone3DClustered;</para><para>//Set the backgroundColor color of the chart</para><para>chart.ChartArea.Interior.BackgroundColor = Color.Pink;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
BackgroundKnownColor |
Background color index.
Examples
The following code illustrates the use of BackgroundKnownColor property:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Cone3DClustered;</para><para>//Set the index of background color</para><para>chart.ChartArea.Interior.BackgroundKnownColor = ExcelColors.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
ForegroundColor |
Foreground color (RGB).
Examples
The following code illustrates the use of ForegroundColor property:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Cone3DClustered;</para><para>//Set the foreground color of the chart</para><para>chart.ChartArea.Interior.ForegroundColor = Color.Blue;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
ForegroundKnownColor |
Index of foreground color.
Examples
The following code illustrates the use of ForegroundKnownColor property:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Cone3DClustered;</para><para>//Set the index of foreground color</para><para>chart.ChartArea.Interior.ForegroundKnownColor = ExcelColors.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
Pattern |
Area pattern.
Examples
The following code illustrates the use of Pattern property:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Cone3DClustered;</para><para>//Set the pattern of the chart</para><para>chart.ChartArea.Interior.Pattern = ExcelPatternType.Angle;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
SwapColorsOnNegative |
Foreground and background are swapped when the data value is negative.
Examples
The following code illustrates the use of SwapColorsOnNegative property:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Cone3DClustered;</para><para>//True if foreground and background colors are swapped when the data value is negative</para><para>chart.Series[0].Format.Interior.SwapColorsOnNegative = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
UseDefaultFormat |
If true - use automatic format; otherwise custom.
Examples
The following code illustrates the use of UseDefaultFormat property:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart and set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["B2:C6"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Cone3DClustered;</para><para>//True to use default format for interior</para><para>chart.ChartArea.Interior.UseDefaultFormat = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
See Also
