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<T>

IEnumerable

Derived

ExcelBubbleChartSeries

ExcelHistogramChartSeries

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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; }

Parameters

PositionID int

The position of the series.

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(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)

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(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