Show / Hide Table of Contents

Class ExcelChartSeries<T>

Collection class for chart series

Inheritance
Object
ExcelChartSeries<T>
ExcelBubbleChartSeries
ExcelHistogramChartSeries
Implements
IEnumerable<T>
IEnumerable
Inherited Members
Object.Equals(Object)
Object.Equals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Object.ReferenceEquals(Object, Object)
Object.ToString()
Namespace: OfficeOpenXml.Drawing.Chart
Assembly: EPPlus.dll
Syntax
public class ExcelChartSeries<T> : IEnumerable<T>, IEnumerable where T : ExcelChartSerie
Type Parameters
Name Description
T

Properties

Chart

A reference to the chart object

Declaration
public ExcelChart Chart { get; }
Property Value
Type Description
ExcelChart

Count

Number of items in the collection

Declaration
public int Count { get; }
Property Value
Type Description
Int32

Item[Int32]

Returns the serie at the specified position.

Declaration
public T this[int PositionID] { get; }
Parameters
Type Name Description
Int32 PositionID

The position of the series.

Property Value
Type Description
T

Methods

Add(ExcelRangeBase)

Adds a new serie to the chart. Do not apply to pivotcharts.

Declaration
public virtual T Add(ExcelRangeBase Serie)
Parameters
Type Name Description
ExcelRangeBase Serie

The value serie range

Returns
Type Description
T

The serie

Add(ExcelRangeBase, ExcelRangeBase)

Adds a new serie to the chart. Do not apply to pivotcharts.

Declaration
public virtual T Add(ExcelRangeBase Serie, ExcelRangeBase XSerie)
Parameters
Type Name Description
ExcelRangeBase Serie

The Y-Axis range

ExcelRangeBase XSerie

The X-Axis range

Returns
Type Description
T

The serie

Add(String)

Adds a new serie to the chart. Do not apply to pivotcharts.

Declaration
public virtual T Add(string Serie)
Parameters
Type Name Description
String Serie

The value serie range

Returns
Type Description
T

The serie

Add(String, String)

Adds a new serie to the chart.Do not apply to pivotcharts.

Declaration
public virtual T Add(string SerieAddress, string XSerieAddress)
Parameters
Type Name Description
String SerieAddress

The Y-Axis range

String XSerieAddress

The X-Axis range

Returns
Type Description
T

The serie

AddSeries(String, String, String)

Adds a new serie to the chart

Declaration
protected T AddSeries(string SerieAddress, string XSerieAddress, string bubbleSizeAddress)
Parameters
Type Name Description
String SerieAddress

The Y-Axis range

String XSerieAddress

The X-Axis range

String bubbleSizeAddress

Bubble chart size

Returns
Type Description
T

Delete(Int32)

Delete the chart at the specific position

Declaration
public void Delete(int PositionID)
Parameters
Type Name Description
Int32 PositionID

Zero based

GetEnumerator()

Gets the enumerator for the collection

Declaration
public IEnumerator<T> GetEnumerator()
Returns
Type Description
IEnumerator<T>

The enumerator

Explicit Interface Implementations

IEnumerable<T>.GetEnumerator()

Declaration
IEnumerator<T> IEnumerable<T>.GetEnumerator()
Returns
Type Description
IEnumerator<T>

IEnumerable.GetEnumerator()

Declaration
IEnumerator IEnumerable.GetEnumerator()
Returns
Type Description
IEnumerator

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable
In this article
Back to top Generated by DocFX