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)

No code example is currently available or this language may not be supported.

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: