Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

_Chart.ApplyDataLabels Method

Applies data labels to a point, a series, or all the series in a chart.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
void 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.
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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.