Share via

Point.ApplyDataLabels Method

  • Article

Applies data labels to a point in a chart.

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

Syntax

'Declaration
Function ApplyDataLabels ( _
    Type As XlDataLabelsType, _
    LegendKey As Object, _
    AutoText As Object, _
    HasLeaderLines As Object, _
    ShowSeriesName As Object, _
    ShowCategoryName As Object, _
    ShowValue As Object, _
    ShowPercentage As Object, _
    ShowBubbleSize As Object, _
    Separator As Object _
) As Object
'Usage
Dim instance As Point
Dim Type As XlDataLabelsType
Dim LegendKey As Object
Dim AutoText As Object
Dim HasLeaderLines As Object
Dim ShowSeriesName As Object
Dim ShowCategoryName As Object
Dim ShowValue As Object
Dim ShowPercentage As Object
Dim ShowBubbleSize As Object
Dim Separator As Object
Dim returnValue As Object

returnValue = instance.ApplyDataLabels(Type, _
    LegendKey, AutoText, HasLeaderLines, _
    ShowSeriesName, ShowCategoryName, _
    ShowValue, ShowPercentage, ShowBubbleSize, _
    Separator)

Object ApplyDataLabels(
    XlDataLabelsType Type,
    Object LegendKey,
    Object AutoText,
    Object HasLeaderLines,
    Object ShowSeriesName,
    Object ShowCategoryName,
    Object ShowValue,
    Object ShowPercentage,
    Object ShowBubbleSize,
    Object Separator
)

Parameters

  • Type
    Type: Microsoft.Office.Interop.Excel.XlDataLabelsType

    Optional XlDataLabelsType. The type of data label to apply. Can be one of the following XlDataLabelsType constants:

    xlDataLabelsShowBubbleSizes

    xlDataLabelsShowLabelAndPercent Percentage of the total and category for the point. Available only for pie charts and doughnut charts.

    xlDataLabelsShowPercent Percentage of the total. Available only for pie charts and doughnut charts.

    xlDataLabelsShowLabel Category for the point.

    xlDataLabelsShowNone No data labels.

    xlDataLabelsShowValue Default. Value for the point (assumed if this argument isn't specified).

  • LegendKey
    Type: System.Object

    Optional Object. True to show the legend key next to the point. The default value is False.

  • AutoText
    Type: System.Object

    Optional Object. True if the object automatically generates appropriate text based on content.

  • HasLeaderLines
    Type: System.Object

    Optional Object. For the Chart and Series objects, True if the series has leader lines.

  • ShowSeriesName
    Type: System.Object

    Optional Object. The series name for the data label.

  • ShowCategoryName
    Type: System.Object

    Optional Object. The category name for the data label.

  • ShowValue
    Type: System.Object

    Optional Object. The value for the data label.

  • ShowPercentage
    Type: System.Object

    Optional Object. The percentage for the data label.

  • ShowBubbleSize
    Type: System.Object

    Optional Object. The bubble size for the data label.

  • Separator
    Type: System.Object

    Optional Object. The separator for the data label.

Return Value

Type: System.Object

See Also

Reference

Point Interface

Point Members

Microsoft.Office.Interop.Excel Namespace