Point.ApplyDataLabels Method
Applies data labels to a point.
Namespace: Microsoft.Office.Interop.PowerPoint
Assembly: Microsoft.Office.Interop.PowerPoint (in Microsoft.Office.Interop.PowerPoint.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.PowerPoint.XlDataLabelsType
The type of data label to apply.
- LegendKey
Type: System.Object
True to show the legend key next to the point. The default value is False.
- AutoText
Type: System.Object
True if the object automatically generates appropriate text based on content.
- HasLeaderLines
Type: System.Object
For the Chart and [Series#SameCHM] objects, True if the series has leader lines.
- ShowSeriesName
Type: System.Object
Pass a boolean value to enable or disable the series name for the data label.
- ShowCategoryName
Type: System.Object
Pass a boolean value to enable or disable the category name for the data label.
- ShowValue
Type: System.Object
Pass a boolean value to enable or disable the value for the data label.
- ShowPercentage
Type: System.Object
Pass a boolean value to enable or disable the percentage for the data label.
- ShowBubbleSize
Type: System.Object
Pass a boolean value to enable or disable the bubble size for the data label.
- Separator
Type: System.Object
The separator for the data label.
Return Value
Type: System.Object
Remarks
Type can be one of these XlDataLabelsType constants.
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). |
Examples
This example applies category labels to series one of the first chart in the active document.
With ActivePresentation.Slides(1).Shapes(1)
If .HasChart Then
.Chart.SeriesCollection(1). _
ApplyDataLabelsType:=xlDataLabelsShowLabel
End If
End With