Click or drag to resize

XlsChartSerie Class

Represents a series in an Excel chart, containing data and formatting options for that series.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet XlsObject
Spire.Xls.Core.Spreadsheet.Charts XlsChartSerie
Spire.Xls.Charts ChartSerie

Namespace: Spire.Xls.Core.Spreadsheet.Charts
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class XlsChartSerie : XlsObject, 
	IChartSerie, IExcelApplication, INamedObject

The XlsChartSerie type exposes the following members.

Properties
Name Description
Public property Bubbles
Bubble sizes for the series.
Public property CategoryLabels
Category labels for the series.
Public property ChartGroup
Index of the chart group.
Public property DataLabels
Gets or sets the data labels for the chart series.
Public property DataPoints
Returns collection of data points. Read-only.
Public property EnteredDirectlyBubbles
Represents bubble values as entered directly.
Public property EnteredDirectlyCategoryLabels
Represents category values as entered directly.
Public property EnteredDirectlyValues
Represents value as entered directly.
Public property ErrorBarsX
Represents X error bars. Read only.
Public property ErrorBarsY
Represents Y error bars. Read only.
Public property Format
Returns format of current serie.
Public property HasDroplines
Sets whether the series has drop lines.
Public property HasErrorBarsX
Indicates if serie contains X error bars.
Public property HasErrorBarsY
Indicates if serie contains Y error bars.
Public property Index
Represents index of the series.
Public property InvertNegaColor
Indicates wheter to invert its colors if the value is negative.
Public property Name
Name of the series.
Public property NamedRange
Series Name range for the series.
Public property NameOrFormula
Gets series name or formula value (not actual string value).
Public property Number
Number of the series.
Public property Parent
Reference to Parent object. Read-only.
(Inherited from XlsObject .)
Public property ParentSeries
Gets parent serie collection. Read - only.
Public property ParetoLineFormat
Return frame format. Read-only.
Public property PointNumber
Returns number of points in the series. Read-only.
Public property RealIndex
Synonym for Index property.
Protected property ReferenceCount
Get quantity of instance references.
(Inherited from XlsObject .)
Public property SerieType
Represents serie type.
Public property StartType
Returns serie start type. Read-only.
Public property TrendLines
Represents serie trend lines collection. Read only.
Public property UsePrimaryAxis
Indicates whether to use primary axis for series drawing.
Public property Values
Values range for the series.
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 Clone
Clone current instance.
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 .)
Public method ErrorBar(Boolean)
Creates error bar object.
Public method ErrorBar(Boolean, ErrorBarIncludeType)
Creates error bar object.
Public method ErrorBar(Boolean, IXLSRange, IXLSRange)
Sets custom error bar type.
Public method ErrorBar(Boolean, ErrorBarIncludeType, ErrorBarType)
Creates error bar object.
Public method ErrorBar(Boolean, ErrorBarIncludeType, ErrorBarType, Double)
Creates error bar 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 GetCommonSerieFormat
Gets common serie format.
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetSerieNameRange
Gets serie name range.
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 SetDefaultName
Sets default serie name.
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