This documentation is archived and is not being maintained.

DataLabel Interface

Represents the data label on a chart point or trendline.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[InterfaceTypeAttribute()]
[GuidAttribute("000208B2-0000-0000-C000-000000000046")]
public interface DataLabel

On a series, the DataLabel object is a member of the DataLabels collection. The DataLabels collection contains a DataLabel object for each point. For a series without definable points (such as an area series), the DataLabels collection contains a single DataLabel object.

Use DataLabels(index), where index is the data-label index number, to return a single DataLabel object.

Use the DataLabel property to return the DataLabel object for a single point.

On a trendline, the DataLabel property returns the text shown with the trendline. This can be the equation, the R-squared value, or both (if both are showing).

Show: