Class ExcelChartSeries<T>¶

Namespace: OfficeOpenXml.Drawing.Chart
Assembly: EPPlus.dll

Collection class for chart series

public class ExcelChartSeries<T> : IEnumerable<T>, IEnumerable where T : ExcelChartSerie

Type Parameters¶

T

Inheritance¶

object ← ExcelChartSeries<T>

Implements¶

IEnumerable
IEnumerable<T>

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelChartSeries()¶

public ExcelChartSeries()

Properties¶

Chart¶

A reference to the chart object

public ExcelChart Chart { get; }

Property Value¶

ExcelChart

Count¶

Number of items in the collection

public int Count { get; }

Property Value¶

int

this[int]¶

Returns the serie at the specified position.

public T this[int PositionID] { get; }

Property Value¶

T

Methods¶

Add(ExcelRangeBase)¶

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

public virtual T Add(ExcelRangeBase Serie)

Parameters¶

Serie ExcelRangeBase

The value serie range

Returns¶

T

The serie

Add(string)¶

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

public virtual T Add(string Serie)

Parameters¶

Serie string

The value serie range

Returns¶

T

The serie

Add(ExcelRangeBase, ExcelRangeBase)¶

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

public virtual T Add(ExcelRangeBase Serie, ExcelRangeBase XSerie)

Parameters¶

Serie ExcelRangeBase

The Y-Axis range

XSerie ExcelRangeBase

The X-Axis range

Returns¶

T

The serie

Add(string, string)¶

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

public virtual T Add(string SerieAddress, string XSerieAddress)

Parameters¶

SerieAddress string

The Y-Axis range

XSerieAddress string

The X-Axis range

Returns¶

T

The serie

AddSeries(string, string, string)¶

Adds a new serie to the chart

protected T AddSeries(string SerieAddress, string XSerieAddress, string bubbleSizeAddress)

Parameters¶

SerieAddress string

The Y-Axis range

XSerieAddress string

The X-Axis range

bubbleSizeAddress string

Bubble chart size

Returns¶

T

Delete(int)¶

Delete the chart at the specific position

public void Delete(int PositionID)

Parameters¶

PositionID int

Zero based

GetEnumerator()¶

Gets the enumerator for the collection

public IEnumerator<T> GetEnumerator()

Returns¶

IEnumerator<T>

The enumerator