Class ExcelChartDataLabel
Datalabel on chart level. This class is inherited by ExcelChartSerieDataLabel
Inheritance
System.Object
ExcelChartDataLabel
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 abstract class ExcelChartDataLabel : XmlHelperProperties
Border
Access 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 fill properties
Declaration
public ExcelDrawingFill Fill { get; }Property Value
| Type | Description |
|---|---|
| ExcelDrawingFill |
Font
Access font properties
Declaration
public ExcelTextFont Font { get; }Property Value
| Type | Description |
|---|---|
| ExcelTextFont |
Format
The Numberformat string.
Declaration
public string Format { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
Position
The position of the data labels
Declaration
public abstract eLabelPosition Position { get; set; }Property Value
| Type | Description |
|---|---|
| eLabelPosition |
Separator
Separator string
Declaration
public abstract string Separator { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
ShowBubbleSize
Show Bubble Size
Declaration
public abstract bool ShowBubbleSize { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
ShowCategory
Show category names
Declaration
public abstract bool ShowCategory { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
ShowLeaderLines
Show the leader lines
Declaration
public abstract bool ShowLeaderLines { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
ShowLegendKey
Show the Lengend Key
Declaration
public abstract bool ShowLegendKey { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
ShowPercent
Show percent values
Declaration
public abstract bool ShowPercent { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
ShowSeriesName
Show series names
Declaration
public abstract bool ShowSeriesName { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
ShowValue
Show the values
Declaration
public abstract bool ShowValue { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
SourceLinked
The Numberformats are linked to the source data.
Declaration
public bool SourceLinked { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
TextBody
Access to text body properties
Declaration
public ExcelTextBody TextBody { get; }Property Value
| Type | Description |
|---|---|
| ExcelTextBody |
ThreeD
3D properties
Declaration
public ExcelDrawing3D ThreeD { get; }Property Value
| Type | Description |
|---|---|
| ExcelDrawing3D |
Methods
GetPosEnum(String)
Translates the enum position
Declaration
protected eLabelPosition GetPosEnum(string pos)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | pos | The string value to translate |
Returns
| Type | Description |
|---|---|
| eLabelPosition | The enum value |
GetPosText(eLabelPosition)
Translates the label position
Declaration
protected string GetPosText(eLabelPosition pos)Parameters
| Type | Name | Description |
|---|---|---|
| eLabelPosition | pos | The position enum |
Returns
| Type | Description |
|---|---|
| System.String | The string |