DataLabel and DataLabels Members

Use the DataLabels collection to add data labels to series. Use the Series object’s DataLabels property to get a reference to this collection. Use the DataLabel object to format individual data labels. The DataLabels collection and DataLabel object have the following members. Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Application 2

AutoScaleFont 2

AutoText 2

Border 2

Caption

Characters

Count 1

Creator 2

Delete( ) 2

Fill 2

Font 2

HorizontalAlignment 2

Interior 2

Item 1

Left

Name 2

NumberFormat 2

NumberFormatLinked 2

NumberFormatLocal 2

Orientation 2

Parent 2

Position 2

ReadingOrder 2

Select 2

Separator 2

Shadow 2

ShowBubbleSize 2

ShowCategoryName 2

ShowLegendKey 2

ShowPercentage 2

ShowSeriesName 2

ShowValue 2

Text

Top

Type 2

VerticalAlignment 2

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial