Class ExcelChartSeries<T>

Collection class for chart series

Inheritance

System.Object

ExcelChartSeries<T>

ExcelBubbleChartSeries

ExcelHistogramChartSeries

Implements

System.Collections.Generic.IEnumerable<T>

System.Collections.IEnumerable

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.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
System.Int32

Item[Int32]

Returns the serie at the specified position.

Declaration

public T this[int PositionID] { get; }

Parameters

Type	Name	Description
System.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
System.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
System.String	SerieAddress	The Y-Axis range
System.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
System.String	SerieAddress	The Y-Axis range
System.String	XSerieAddress	The X-Axis range
System.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
System.Int32	PositionID	Zero based

GetEnumerator()

Gets the enumerator for the collection

Declaration

public IEnumerator<T> GetEnumerator()

Returns

Type	Description
System.Collections.Generic.IEnumerator<T>	The enumerator

Explicit Interface Implementations

IEnumerable<T>.GetEnumerator()

Declaration

IEnumerator<T> IEnumerable<T>.GetEnumerator()

Returns

Type	Description
System.Collections.Generic.IEnumerator<T>

IEnumerable.GetEnumerator()

Declaration

IEnumerator IEnumerable.GetEnumerator()

Returns

Type	Description
System.Collections.IEnumerator

Implements

System.Collections.Generic.IEnumerable<T>

System.Collections.IEnumerable