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

ExcelChartExDataLabel

ExcelChartDataLabelStandard

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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