Skip to main content

DataLabelCollection Members

A collection that stores customized data labels and data label options for a series in the chart.

Properties

Name Description
Count Gets the number of elements contained in the ICollection. Inherited from ICollection.
Fill Provides access to fill options for the specified drawing object. Inherited from ShapeFormatBase.
Font Provides access to font attributes for text displayed in a chart element. Inherited from ShapeTextFormat.
Hidden Gets or sets a value indicating whether the data label is hidden. Inherited from DataLabelBase.
HiddenLabels Returns the collection of hidden labels.
IsSynchronized Gets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
LabelPosition Gets or sets the position of data labels on the chart. Inherited from DataLabelBase.
LeaderLines Provides access to settings used to draw the leader lines for data labels in a pie or doughnut chart. Inherited from DataLabelOptions.
NumberFormat Provides access to number format options for numerical values displayed in data labels. Inherited from DataLabelBase.
Outline Provides access to the options used to format an outline of the specified drawing object. Inherited from ShapeFormatBase.
Range Obtains a range used as a reference for data labels.
Separator Gets or sets the string value that represents a separator for different items displayed in a data label. Inherited from DataLabelBase.
ShowBubbleSize Gets or sets a value indicating whether the bubble size should be displayed in a data label on the bubble chart. Inherited from DataLabelBase.
ShowCategoryName Gets or sets a value indicating whether the category name should be displayed in a data label. Inherited from DataLabelBase.
ShowLegendKey Gets or sets a value indicating whether the legend key should be displayed in a data label. Inherited from DataLabelBase.
ShowPercent Gets or sets a value indicating whether the percentage value should be displayed in a data label on the pie or doughnut chart. Inherited from DataLabelBase.
ShowSeriesName Gets or sets a value indicating whether the series name should be displayed in a data label. Inherited from DataLabelBase.
ShowValue Gets or sets a value indicating whether the data point value should be displayed in a data label. Inherited from DataLabelBase.
SyncRoot Gets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.
TextDirection Gets or sets the text direction in a chart element. Inherited from ShapeTextFormat.
TextRotation Gets or sets the rotation angle of the text in a chart element. Inherited from ShapeTextFormat.

Methods

Name Description
Add(Int32) Creates a new item and adds it to the collection.
Clear() Removes all items from a collection.
Contains(DataLabel) Determines whether the collection contains the specified item.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
FindByIndex(Int32) Gets an item by its index in the collection.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(DataLabel) Returns the index of the specified item in the collection.
IsVisible(Int32) Determines whether a data label is visible for the specified data point.
Remove(DataLabel) Removes the specified data label from the collection.
RemoveAt(Int32) Removes the item at the specified index of the DataLabelCollection instance.
ResetReference() Resets the reference to cells that contain data labels.
ResetToMatchStyle() Removes custom formatting of the chart element and applies default formatting based on the chart style. Inherited from ShapeFormat.
SetReference(CellRange) Specifies the cell range used as a source for the data labels.
SetReference(String) Specifies the cell range used as a source for the data labels.
SetVisibility(Int32, Boolean) Shows or hides a data label for the specified data point.
See Also