Click or drag to resize

ChartPlotArea Properties

The ChartPlotArea type exposes the following members.

Properties
Name Description
Public property BackGroundColor
Represents foreground known color.
(Inherited from XlsChartFrameFormat .)
Public property BackGroundColorObject
Represents background color.
(Inherited from XlsChartFrameFormat .)
Public property BackGroundKnownColor
Represents the known color used for the background in Excel.
(Inherited from XlsChartFrameFormat .)
Public property Border
Represents chart border. Read only.
Public property Code example Fill
Represents XlsFill gradient format. Read only.
Examples
The following code illustrates the use of Fill property:
Copy 
<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.Column3DClustered;</para><para>//Gets fill options for the chart element</para><para>IShapeFill fillChart = chart.ChartArea.Fill;</para><para>fillChart.FillType = ShapeFillType.Gradient;</para><para>fillChart.BackColor = Color.FromArgb(205, 217, 234);</para><para>fillChart.ForeColor = Color.White;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from XlsChartFrameFormat .)
Public property ForeGroundColor
Represents foreground known color.
(Inherited from XlsChartFrameFormat .)
Public property ForeGroundColorObject
Represents foreground color.
(Inherited from XlsChartFrameFormat .)
Public property ForeGroundKnownColor
Represents foreground known color.
(Inherited from XlsChartFrameFormat .)
Public property Code example Format3D
Gets the chart3 D properties.
Examples
The following code illustrates the use of Shadow property:
Copy 
<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.Column3DClustered;</para><para>//Gets shadow formatting properties for the chart element</para><para>ChartShadow shadowChart = chart.ChartArea.Shadow;</para><para>shadowChart.ShadowPrespectiveType = XLSXChartPrespectiveType.Below;</para><para>shadowChart.Color = Color.Aqua;</para><para>shadowChart.Blur = 22;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from XlsChartFrameFormat .)
Public property HasFormat3D
This property Indicates whether the Shadow object has been created(which includes the 3D properties)
(Inherited from XlsChartFrameFormat .)
Public property HasInterior
Indicates whether interior object was created. Read-only.
(Inherited from XlsChartFrameFormat .)
Public property HasLineProperties
Indicates whether border formatting object was created. Read-only.
(Inherited from XlsChartFrameFormat .)
Public property HasManualLayout Obsolete.
Indicates whether border formatting object was created. Read-only.
(Inherited from XlsChartFrameFormat .)
Public property HasShadow
This property indicates whether the shadow object has been created
(Inherited from XlsChartFrameFormat .)
Public property Height
Y-size. 1/4000 of chart plot. IsHMode Shall set to True
(Inherited from XlsChartFrameFormat .)
Public property InnerLayoutTarget Obsolete.
Gets or sets the inner layout target. Note: This property is obsolete and the get and set operations are not implemented.
(Inherited from XlsChartFrameFormat .)
Public property Interior
Represents frame interior. Read only
Public property IsAutomaticFormat
Represents if use automatic format.
(Inherited from XlsChartFrameFormat .)
Public property IsAutoPosition
Calculates position automatically.
(Inherited from XlsChartFrameFormat .)
Public property IsAutoSize
Calculates size automatically.
(Inherited from XlsChartFrameFormat .)
Public property IsBorderCornersRound
Gets or sets if border corners is round.
(Inherited from XlsChartFrameFormat .)
Public property IsHMode
false value Specifies that the Height shall be interpreted as the Bottom of the chart element..
(Inherited from XlsChartFrameFormat .)
Public property IsWMode
false value Specifies that the Width shall be interpreted as the Right of the chart element..
(Inherited from XlsChartFrameFormat .)
Public property IsXMode
true value Specifies that the X shall be interpreted as the Left of the chart element..
(Inherited from XlsChartFrameFormat .)
Public property IsYMode
true value Specifies that the Y shall be interpreted as the Top of the chart element..
(Inherited from XlsChartFrameFormat .)
Public property LineProperties
Gets chart border. Read-only.
(Inherited from XlsChartFrameFormat .)
Public property Parent
Reference to Parent object. Read-only.
(Inherited from XlsObject .)
Public property Pattern
Represents pattern.
(Inherited from XlsChartFrameFormat .)
Public property RectangleStyle Obsolete.
Rectangle style.
(Inherited from XlsChartFrameFormat .)
Protected property ReferenceCount
Get quantity of instance references.
(Inherited from XlsObject .)
Public property Code example Shadow
Gets the shadow properties.
Examples
The following code illustrates the use of Shadow property:
Copy 
<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.Column3DClustered;</para><para>//Gets shadow formatting properties for the chart element</para><para>ChartShadow shadowChart = chart.ChartArea.Shadow;</para><para>shadowChart.ShadowPrespectiveType = XLSXChartPrespectiveType.Below;</para><para>shadowChart.Color = Color.Aqua;</para><para>shadowChart.Blur = 22;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
(Inherited from XlsChartFrameFormat .)
Public property Visible
Represents visiblity.
(Inherited from XlsChartFrameFormat .)
Public property Width
X-size. 1/4000 of chart plot. IsWMode Shall set to True
(Inherited from XlsChartFrameFormat .)
Public property Workbook
Represents a new workbook instance.
Public property X
X-position of upper-left corner. 1/4000 of chart plot. IsXMode Shall set to True
(Inherited from XlsChartFrameFormat .)
Public property Y
Y-position of upper-left corner. 1/4000 of chart plot. IsYMode Shall set to True
(Inherited from XlsChartFrameFormat .)
Top
See Also