Series.ApplyDataLabels Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Applies data labels to a point, a series, or all the series in a chart.
public object ApplyDataLabels (Microsoft.Office.Interop.Excel.XlDataLabelsType Type = Microsoft.Office.Interop.Excel.XlDataLabelsType.xlDataLabelsShowValue, object LegendKey, object AutoText, object HasLeaderLines, object ShowSeriesName, object ShowCategoryName, object ShowValue, object ShowPercentage, object ShowBubbleSize, object Separator);
Public Function ApplyDataLabels (Optional Type As XlDataLabelsType = Microsoft.Office.Interop.Excel.XlDataLabelsType.xlDataLabelsShowValue, Optional LegendKey As Object, Optional AutoText As Object, Optional HasLeaderLines As Object, Optional ShowSeriesName As Object, Optional ShowCategoryName As Object, Optional ShowValue As Object, Optional ShowPercentage As Object, Optional ShowBubbleSize As Object, Optional Separator As Object) As Object
Parameters
- Type
- XlDataLabelsType
Optional XlDataLabelsType. The type of data label to apply.
- LegendKey
- Object
Optional Object. True to show the legend key next to the point. The default value is False.
- AutoText
- Object
Optional Object. True if the object automatically generates appropriate text based on content.
- HasLeaderLines
- Object
Optional Object. For the Chart and Series objects, True if the series has leader lines.
- ShowSeriesName
- Object
Optional Object. The series name for the data label.
- ShowCategoryName
- Object
Optional Object. The category name for the data label.
- ShowValue
- Object
Optional Object. The value for the data label.
- ShowPercentage
- Object
Optional Object. The percentage for the data label.
- ShowBubbleSize
- Object
Optional Object. The bubble size for the data label.
- Separator
- Object
Optional Object. The separator for the data label.
Returns
Applies to
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기