Class ExcelChartDataLabel¶

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

Data labels on the chart level. This class is inherited by ExcelChartSerieDataLabel

public abstract class ExcelChartDataLabel : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelChartDataLabel

Derived¶

ExcelChartDataLabelStandard
ExcelChartExDataLabel

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

Border¶

Access border properties

public ExcelDrawingBorder Border { get; }

Property Value¶

ExcelDrawingBorder

Effect¶

Effects

public ExcelDrawingEffectStyle Effect { get; }

Property Value¶

ExcelDrawingEffectStyle

Fill¶

Access fill properties

public ExcelDrawingFill Fill { get; }

Property Value¶

ExcelDrawingFill

Font¶

Access font properties

public ExcelTextFont Font { get; }

Property Value¶

ExcelTextFont

Format¶

The Numberformat string.

public string Format { get; set; }

Property Value¶

string

Position¶

The position of the data labels

public abstract eLabelPosition Position { get; set; }

Property Value¶

eLabelPosition

Separator¶

Separator string

public abstract string Separator { get; set; }

Property Value¶

string

ShowBubbleSize¶

Show Bubble Size

public abstract bool ShowBubbleSize { get; set; }

Property Value¶

bool

ShowCategory¶

Show category names

public abstract bool ShowCategory { get; set; }

Property Value¶

bool

ShowLeaderLines¶

Show the leader lines

public abstract bool ShowLeaderLines { get; set; }

Property Value¶

bool

ShowLegendKey¶

Show the Lengend Key

public abstract bool ShowLegendKey { get; set; }

Property Value¶

bool

ShowPercent¶

Show percent values

public abstract bool ShowPercent { get; set; }

Property Value¶

bool

ShowSeriesName¶

Show series names

public abstract bool ShowSeriesName { get; set; }

Property Value¶

bool

ShowValue¶

Show the values

public abstract bool ShowValue { get; set; }

Property Value¶

bool

SourceLinked¶

The Numberformats are linked to the source data.

public bool SourceLinked { get; set; }

Property Value¶

bool

TextBody¶

Access to text body properties

public ExcelTextBody TextBody { get; }

Property Value¶

ExcelTextBody

TextSettings¶

Text settings like fills, text outlines and effects

public ExcelDrawingTextSettings TextSettings { get; }

Property Value¶

ExcelDrawingTextSettings

ThreeD¶

3D properties

public ExcelDrawing3D ThreeD { get; }

Property Value¶

ExcelDrawing3D

Methods¶

GetPosEnum(string)¶

Translates the enum position

protected eLabelPosition GetPosEnum(string pos)

Parameters¶

pos string

The string value to translate

Returns¶

eLabelPosition

The enum value

GetPosText(eLabelPosition)¶

Translates the label position

protected string GetPosText(eLabelPosition pos)

Parameters¶

pos eLabelPosition

The position enum

Returns¶

string

The string