Class ExcelChartExSerie¶

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

A chart serie

public class ExcelChartExSerie : ExcelChartSerie

Inheritance¶

object ← XmlHelper ← ExcelChartSerie ← ExcelChartExSerie

Derived¶

ExcelBoxWhiskerChartSerie
ExcelHistogramChartSerie
ExcelRegionMapChartSerie
ExcelTreemapChartSerie
ExcelWaterfallChartSerie

Inherited Members¶

ExcelChartSerie.Border
ExcelChartSerie.Effect
ExcelChartSerie.Fill
ExcelChartSerie.Header
ExcelChartSerie.HeaderAddress
ExcelChartSerie.NumberLiteralsX
ExcelChartSerie.NumberLiteralsY
ExcelChartSerie.NumberOfItems
ExcelChartSerie.Series
ExcelChartSerie.StringLiteralsX
ExcelChartSerie.ThreeD
ExcelChartSerie.TrendLines
ExcelChartSerie.XSeries
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

DataDimensions¶

The dimensions of the serie

public ExcelChartExDataCollection DataDimensions { get; }

Property Value¶

ExcelChartExDataCollection

DataLabel¶

Data label properties

public ExcelChartExSerieDataLabel DataLabel { get; }

Property Value¶

ExcelChartExSerieDataLabel

DataPoints¶

A collection of individual data points

public ExcelChartExDataPointCollection DataPoints { get; }

Property Value¶

ExcelChartExDataPointCollection

HasDataLabel¶

If the chart has datalabel

public bool HasDataLabel { get; }

Property Value¶

bool

Header¶

The header text for the serie.

public override string Header { get; set; }

Property Value¶

string

HeaderAddress¶

Header address for the serie.

public override ExcelAddressBase HeaderAddress { get; set; }

Property Value¶

ExcelAddressBase

Hidden¶

If the serie is hidden

public bool Hidden { get; set; }

Property Value¶

bool

NumberOfItems¶

Number of items. Will always return 0, as no item data is stored.

public override int NumberOfItems { get; }

Property Value¶

int

Series¶

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

public override string Series { get; set; }

Property Value¶

string

TrendLines¶

Trendline do not apply to extended charts.

public override ExcelChartTrendlineCollection TrendLines { get; }

Property Value¶

ExcelChartTrendlineCollection

XSeries¶

Set an address for the horizontal labels

public override string XSeries { get; set; }

Property Value¶

string