Click or drag to resize

ChartSerie Class

Represents a series of data in a chart, containing the data points and related configuration settings for display.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet XlsObject
Spire.Xls.Core.Spreadsheet.Charts XlsChartSerie
Spire.Xls.Charts ChartSerie

Namespace: Spire.Xls.Charts
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public class ChartSerie : XlsChartSerie

The ChartSerie 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.
(Inherited from XlsChartSerie .)
Public property DataFormat
Returns data format. Read-only.
Public property DataLabels
Gets or sets the data labels associated with the chart series, overriding any base class implementation.
Public property DataPoints
Returns data points collection for the chart series. Read-only.
Public property EnteredDirectlyBubbles
Represents bubble values as entered directly.
(Inherited from XlsChartSerie .)
Public property EnteredDirectlyCategoryLabels
Represents category values as entered directly.
(Inherited from XlsChartSerie .)
Public property EnteredDirectlyValues
Represents value as entered directly.
(Inherited from XlsChartSerie .)
Public property ErrorBarsX
Represents X error bars. Read only.
(Inherited from XlsChartSerie .)
Public property ErrorBarsY
Represents Y error bars. Read only.
(Inherited from XlsChartSerie .)
Public property Format
Returns serie format.
Public property HasDroplines
Sets whether the series has drop lines.
(Inherited from XlsChartSerie .)
Public property HasErrorBarsX
Indicates if serie contains X error bars.
(Inherited from XlsChartSerie .)
Public property HasErrorBarsY
Indicates if serie contains Y error bars.
(Inherited from XlsChartSerie .)
Public property Index
Represents index of the series.
(Inherited from XlsChartSerie .)
Public property InvertNegaColor
Indicates wheter to invert its colors if the value is negative.
(Inherited from XlsChartSerie .)
Public property Name
Name of the series.
(Inherited from XlsChartSerie .)
Public property NamedRange
Series Name range for the series.
(Inherited from XlsChartSerie .)
Public property NameOrFormula
Gets series name or formula value (not actual string value).
(Inherited from XlsChartSerie .)
Public property Number
Number of the series.
(Inherited from XlsChartSerie .)
Public property Parent
Reference to Parent object. Read-only.
(Inherited from XlsObject .)
Public property ParentSeries
Gets parent serie collection. Read - only.
(Inherited from XlsChartSerie .)
Public property ParetoLineFormat
Return frame format. Read-only.
(Inherited from XlsChartSerie .)
Public property PointNumber
Returns number of points in the series. Read-only.
(Inherited from XlsChartSerie .)
Public property RealIndex
Synonym for Index property.
(Inherited from XlsChartSerie .)
Protected property ReferenceCount
Get quantity of instance references.
(Inherited from XlsObject .)
Public property SerieType
Represents serie type.
(Inherited from XlsChartSerie .)
Public property StartType
Returns serie start type. Read-only.
(Inherited from XlsChartSerie .)
Public property TrendLines
Represents serie trend lines collection. Read only.
(Inherited from XlsChartSerie .)
Public property UsePrimaryAxis
Indicates whether to use primary axis for series drawing.
(Inherited from XlsChartSerie .)
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.
(Inherited from XlsChartSerie .)
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.
(Inherited from XlsChartSerie .)
Public method ErrorBar(Boolean, ErrorBarIncludeType)
Creates error bar object.
(Inherited from XlsChartSerie .)
Public method ErrorBar(Boolean, IXLSRange, IXLSRange)
Sets custom error bar type.
(Inherited from XlsChartSerie .)
Public method ErrorBar(Boolean, ErrorBarIncludeType, ErrorBarType)
Creates error bar object.
(Inherited from XlsChartSerie .)
Public method ErrorBar(Boolean, ErrorBarIncludeType, ErrorBarType, Double)
Creates error bar object.
(Inherited from XlsChartSerie .)
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.
(Inherited from XlsChartSerie .)
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.
(Inherited from XlsChartSerie .)
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