Defines the properties for all displayed for this .
Inheritance
Properties
Section titled "Properties"Height
Section titled "Height"Inherited from: DataLabel
Returns or sets a value that represents the height of the label, expressed as a ratio, relative to the size of the chart area.
public virtual double Height { get; set; }IsDeleted
Section titled "IsDeleted"Inherited from: DataLabel
Returns or sets a boolean value indicating whether this label has been deleted.
public virtual bool IsDeleted { get; set; }LabelPosition
Section titled "LabelPosition"Inherited from: DataLabel
Returns or sets a value which determines the label's position as relative to the series bar/line.
public DataLabelPosition LabelPosition { get; set; }Separator
Section titled "Separator"Inherited from: DataLabel
Returns or sets the separator used between multiple values in the label.
public string Separator { get; set; }ShowBubbleSize
Section titled "ShowBubbleSize"Inherited from: DataLabel
Returns or sets if the bubble size is shown. Applies only to which are displayed within a bubble chart.
public ExcelDefaultableBoolean ShowBubbleSize { get; set; }ShowCategoryName
Section titled "ShowCategoryName"Inherited from: DataLabel
Returns or sets a value indicating whether the category name is shown.
public ExcelDefaultableBoolean ShowCategoryName { get; set; }ShowLegendKey
Section titled "ShowLegendKey"Inherited from: DataLabel
Returns or sets if the key is shown.
public ExcelDefaultableBoolean ShowLegendKey { get; set; }ShowPercentage
Section titled "ShowPercentage"Inherited from: DataLabel
Returns or sets a value indicating whether the percentage of the range is shown.
public ExcelDefaultableBoolean ShowPercentage { get; set; }ShowSeriesName
Section titled "ShowSeriesName"Inherited from: DataLabel
Returns or sets a value indicating whether the series is shown in the label.
public ExcelDefaultableBoolean ShowSeriesName { get; set; }ShowRange
Section titled "ShowRange"Inherited from: DataLabel
Returns or sets a boolean value indicating whether the data label range is shown.
public ExcelDefaultableBoolean ShowRange { get; set; }ShowValue
Section titled "ShowValue"Inherited from: DataLabel
Returns or sets a value indicating whether the value is shown.
public ExcelDefaultableBoolean ShowValue { get; set; }Width
Section titled "Width"Inherited from: DataLabel
Returns or sets a value that represents the width of the label, expressed as a ratio, relative to the size of the chart area.
public virtual double Width { get; set; }NumberFormat
Section titled "NumberFormat"Inherited from: ChartLabelBase
Returns or sets the format to use for numbers.
public string NumberFormat { get; set; }NumberFormatLinked
Section titled "NumberFormatLinked"Inherited from: ChartLabelBase
True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).
public bool NumberFormatLinked { get; set; }Border
Section titled "Border"Inherited from: ChartTextAreaBase
Determines the appearance of the border drawn around the text area, as well as whether a border appears.
public ChartBorder Border { get; set; }DefaultFont
Section titled "DefaultFont"Inherited from: ChartTextAreaBase
Defines the font properties for each formatted run in the that has no more specific setting. Read-only.
public IWorkbookFont DefaultFont { get; }Inherited from: ChartTextAreaBase
Returns or sets a derived object which defines the fill properties for the text area.
public ChartFillBase Fill { get; set; }Formula
Section titled "Formula"Inherited from: ChartTextAreaBase
The formula used to get the text displayed within the text area. (read-only).
public virtual Formula Formula { get; }HorizontalOverflow
Section titled "HorizontalOverflow"Inherited from: ChartTextAreaBase
Determines whether text is allowed to continue horizontally outside the bounds of the containing element.
public TextHorizontalOverflow HorizontalOverflow { get; set; }Inherited from: ChartTextAreaBase
The left position of the text area (ignored unless is set to 'Custom').
public virtual double Left { get; set; }Position
Section titled "Position"Inherited from: ChartTextAreaBase
Determines whether the position of the text area is automatic or custom as specified by the and properties.
public virtual ElementPosition Position { get; set; }ReadingOrder
Section titled "ReadingOrder"Inherited from: ChartTextAreaBase
Determines the reading order
public ReadingOrder ReadingOrder { get; set; }Rotation
Section titled "Rotation"Inherited from: ChartTextAreaBase
Determines the rotation of the text area, expressed in degrees.
public double Rotation { get; set; }Inherited from: ChartTextAreaBase
Returns or sets a object which defines the text to be displayed by the associated chart element.
public virtual FormattedString Text { get; set; }TextDirection
Section titled "TextDirection"Inherited from: ChartTextAreaBase
Determines the orientation and direction in which text flows.
public TextDirection TextDirection { get; set; }Inherited from: ChartTextAreaBase
The top position of the text area (ignored unless is set to 'Custom').
public virtual double Top { get; set; }VerticalAlignment
Section titled "VerticalAlignment"Inherited from: ChartTextAreaBase
Determines the vertical alignment of the text area.
public VerticalTitleAlignment VerticalAlignment { get; set; }VerticalOverflow
Section titled "VerticalOverflow"Inherited from: ChartTextAreaBase
Determines whether text is allowed to continue vertically outside the bounds of the containing element.
public TextVerticalOverflow VerticalOverflow { get; set; }WrapText
Section titled "WrapText"Inherited from: ChartTextAreaBase
Determines whether text is wrapped when it would exceed the bounds of the containing element.
public bool WrapText { get; set; }Chart
Section titled "Chart"Inherited from: ChartObject
Returns the owning chart (read-only)
public WorksheetChart Chart { get; }Owner
Section titled "Owner"Inherited from: ChartObject
returns this object's owner. (read-only)
public ChartObject Owner { get; }Sheet
Section titled "Sheet"Inherited from: ChartObject
The owning sheet (read-only)
public Sheet Sheet { get; }Workbook
Section titled "Workbook"Inherited from: ChartObject
The owning workbook (read-only)
public Workbook Workbook { get; }Worksheet
Section titled "Worksheet"Inherited from: ChartObject
The owning worksheet (read-only)
public Worksheet Worksheet { get; }DataLabelsRange
Section titled "DataLabelsRange"Returns a which defines the cell range from which part or all of the label text is obtained.
public Formula DataLabelsRange { get; }ParentLabelLayout
Section titled "ParentLabelLayout"Returns or sets a value which determines the label positioning for a Treemap chart.
public ParentLabelLayout ParentLabelLayout { get; set; }ShowLeaderLines
Section titled "ShowLeaderLines"Returns or sets a boolean value indicating whether are displayed for the data labels associated with this instance.
public bool ShowLeaderLines { get; set; }Methods
Section titled "Methods"SetFormula(string, CellReferenceMode?)
Section titled "SetFormula(string, CellReferenceMode?)"Inherited from: ChartTextAreaBase
Assigns a new to this instance.
public virtual void SetFormula(string formula, CellReferenceMode? cellReferenceMode = null)Parameters
- formula:
string - cellReferenceMode:
CellReferenceMode?
Returns any
SetDataLabelsRange(string, CellReferenceMode?)
Section titled "SetDataLabelsRange(string, CellReferenceMode?)"Assigns a to the
public void SetDataLabelsRange(string formula, CellReferenceMode? cellReferenceMode = null)Parameters
- formula:
string - cellReferenceMode:
CellReferenceMode?