Class ExcelChartSeries<T>
Collection class for chart series
Inherited Members
Namespace: OfficeOpenXml.Drawing.Chart
Assembly: EPPlus.dll
Syntax
public class ExcelChartSeries<T> : IEnumerable<T>, IEnumerable where T : ExcelChartSerieType 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 |
|---|---|
| int |
this[int]
Returns the serie at the specified position.
Declaration
public T this[int PositionID] { get; }Parameters
| Type | Name | Description |
|---|---|---|
| int | 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(int)
Delete the chart at the specific position
Declaration
public void Delete(int PositionID)Parameters
| Type | Name | Description |
|---|---|---|
| int | PositionID | Zero based |
GetEnumerator()
Gets the enumerator for the collection
Declaration
public IEnumerator<T> GetEnumerator()Returns
| Type | Description |
|---|---|
| IEnumerator<T> | The enumerator |