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)
Syntax
'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("000208B2-0000-0000-C000-000000000046")> _
Public Interface DataLabel
'Usage
Dim instance As DataLabel
[InterfaceTypeAttribute()]
[GuidAttribute("000208B2-0000-0000-C000-000000000046")]
public interface DataLabel
Remarks
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).