Class ExcelChartSerie

A chart serie

Inheritance
System.Object
XmlHelper
ExcelChartSerie
ExcelChartSerieWithErrorBars
ExcelPieChartSerie
ExcelRadarChartSerie
ExcelSurfaceChartSerie
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 ExcelChartSerie : XmlHelper, IDrawingStyleBase

Properties

Border

Access to border properties

Declaration
public ExcelDrawingBorder Border { get; }
Property Value
Type Description
ExcelDrawingBorder

Effect

Effects

Declaration
public ExcelDrawingEffectStyle Effect { get; }
Property Value
Type Description
ExcelDrawingEffectStyle

Fill

Access to fill properties

Declaration
public ExcelDrawingFill Fill { get; }
Property Value
Type Description
ExcelDrawingFill

Header

Header for the serie.

Declaration
public string Header { get; set; }
Property Value
Type Description
System.String

HeaderAddress

Header address for the serie.

Declaration
public ExcelAddressBase HeaderAddress { get; set; }
Property Value
Type Description
ExcelAddressBase

NumberLiteralsX

Literals for the X serie, if the literal values are numeric

Declaration
public double[] NumberLiteralsX { get; }
Property Value
Type Description
System.Double[]

NumberLiteralsY

Literals for the Y serie, if the literal values are numeric

Declaration
public double[] NumberLiteralsY { get; }
Property Value
Type Description
System.Double[]

NumberOfItems

Number of items in the serie

Declaration
public int NumberOfItems { get; }
Property Value
Type Description
System.Int32

Series

Set this to a valid address or the drawing will be invalid.

Declaration
public virtual string Series { get; set; }
Property Value
Type Description
System.String

StringLiteralsX

Literals for the X serie, if the literal values are strings

Declaration
public string[] StringLiteralsX { get; }
Property Value
Type Description
System.String[]

ThreeD

3D properties

Declaration
public ExcelDrawing3D ThreeD { get; }
Property Value
Type Description
ExcelDrawing3D

TrendLines

Access to the trendline collection

Declaration
public ExcelChartTrendlineCollection TrendLines { get; }
Property Value
Type Description
ExcelChartTrendlineCollection

XSeries

Set an address for the horisontal labels

Declaration
public virtual string XSeries { get; set; }
Property Value
Type Description
System.String

Methods

CreateCache()

Creates a num cach for a chart serie. Please note that a serie can only have one column to have a cache.

Declaration
public void CreateCache()