IDataLabelFormat

IDataLabelFormat interface

Represents formatting options for DataLabel.

public interface IDataLabelFormat : IFormattedTextContainer

Properties

NameDescription
AsIFormattedTextContainer { get; }Allows to get base IFormattedTextContainer interface. Read-only IFormattedTextContainer.
Format { get; }Represents the format of the data label. Read-only IFormat.
IsNumberFormatLinkedToSource { get; set; }Read/write Boolean.
NumberFormat { get; set; }Represents the format string for the DataLabels object. Read/write String.
Position { get; set; }Represents the position of the data label. Read/write LegendDataLabelPosition.
Separator { get; set; }Sets or returns a Variant representing the separator used for the data labels on a chart. Read/write String.
ShowBubbleSize { get; set; }Represents a specified chart’s data label bubble size value display behavior. True displays the bubble size value. False to hide. Read/write Boolean.
ShowCategoryName { get; set; }Represents a specified chart’s data label category name display behavior. True to display the category name for the data labels on a chart. False to hide. Read/write Boolean.
ShowLabelAsDataCallout { get; set; }Determines either specified chart’s data label will be displayed as data callout or as data label. If parent of this DataLabelFormat object is a DataLabelCollection collection of data labels then this property gets or sets the default value of the ShowLabelAsDataCallout property for the new data labels in the DataLabelCollection collection. Set this property with value also sets this value to the ShowLabelAsDataCallout property for all data labels in the DataLabelCollection collection (i.e. “DataLabels.DefaultDataLabelFormat.ShowLabelAsDataCallout = val;” cause to all DataLabels[i].ShowLabelAsDataCallout is equal to val).
ShowLabelValueFromCell { get; set; }Represents a specified chart’s data label cell value display behavior. True displays cell value. False to hide. Read/write Boolean.
ShowLeaderLines { get; set; }Represents a specified chart’s data label leader lines display behavior. True displays the leader lines. False to hide. Read/write Boolean.
ShowLegendKey { get; set; }Represents a specified chart’s data label legend key display behavior. True if the data label legend key is visible. Read/write Boolean.
ShowPercentage { get; set; }Represents a specified chart’s data label percentage value display behavior. True displays the percentage value. False to hide. Read/write Boolean.
ShowSeriesName { get; set; }Returns or sets a Boolean to indicate the series name display behavior for the data labels on a chart. True to show the series name. False to hide. Read/write Boolean.
ShowValue { get; set; }Represents a specified chart’s data label percentage value display behavior. True displays the percentage value. False to hide. Read/write Boolean.

See Also