IDataLabelFormat class

IDataLabelFormat class

Represents formatting options for DataLabel.

The IDataLabelFormat type exposes the following members:

Properties

PropertyDescription
is_number_format_linked_to_sourceRead/write bool.
number_formatRepresents the format string for the DataLabels object.
Read/write str.
formatRepresents the format of the data label.
Read-only IFormat.
positionRepresents the position of the data label.
Read/write LegendDataLabelPosition.
show_legend_keyRepresents a specified chart’s data label legend key display behavior.
True if the data label legend key is visible.
Read/write bool.
show_valueRepresents a specified chart’s data label percentage value display behavior.
True displays the percentage value. False to hide.
Read/write bool.
show_category_nameRepresents 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 bool.
show_series_nameReturns 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 bool.
show_percentageRepresents a specified chart’s data label percentage value display behavior.
True displays the percentage value. False to hide.
Read/write bool.
show_bubble_sizeRepresents a specified chart’s data label bubble size value display behavior.
True displays the bubble size value. False to hide.
Read/write bool.
show_leader_linesRepresents a specified chart’s data label leader lines display behavior.
True displays the leader lines. False to hide.
Read/write bool.
show_label_as_data_calloutDetermines 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).
show_label_value_from_cellRepresents a specified chart’s data label cell value display behavior.
True displays cell value. False to hide.
Read/write bool.
separatorSets or returns a Variant representing the separator used for the data labels on a chart.
Read/write str.
text_format
chart
slide
presentation

See Also