Click or drag to resize

ChartPlotArea Class

Represents the plot area of a chart, which is the area where the data series are drawn.
Inheritance Hierarchy

Namespace: Spire.Xls.Charts
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class ChartPlotArea : XlsChartPlotArea

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
Methods
Name Description
Protected method AddReference
Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored.
(Inherited from XlsObject .)
Protected method CheckDisposed
Checks whether object was disposed and throws exception if it was.
(Inherited from XlsObject .)
Public method Clear Obsolete.
Clears objects.
(Inherited from XlsChartFrameFormat .)
Public method Clone Obsolete.
Clone current Record.
(Inherited from XlsChartFrameFormat .)
Public method Dispose
Dispose object and free resources.
(Inherited from XlsObject .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Destructor. Call dispose method of current object.
(Inherited from XlsObject .)
Protected method FindParent(Type)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParent( Type )
Find parent of object.
(Inherited from XlsObject .)
Protected method FindParent(Type, Boolean)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParents
Finds parent objects.
(Inherited from XlsObject .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Protected method OnDispose
Method which can be overriden by users to take any specific actions when object is disposed.
(Inherited from XlsObject .)
Protected method ReleaseReference
Decrease quantity of Reference. User must call this method when freeing resources.
(Inherited from XlsObject .)
Public method SetDefaultValues Obsolete.
Set variable to the default state.
(Inherited from XlsChartFrameFormat .)
Protected method SetParent
Sets parent of the object.
(Inherited from XlsObject .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
Fields
Name Description
Protected field m_bIsDisposed
Flag which indicates if the object was disposed or not.
(Inherited from XlsObject .)
Top
See Also