DataLabel.ShowCategoryName property (Excel)

True to display the category name for the data labels on a chart. False to hide. Read/write Boolean .


expression. ShowCategoryName

expression An expression that returns a DataLabel object.


The chart must first be active before you can access the data labels programmatically or a run-time error will occur.


This example shows the category name for the data labels of the first series on the first chart. This example assumes a chart exists on the active worksheet.

Sub UseCategoryName() 
 ActiveChart.SeriesCollection(1) _ 
 .DataLabels.ShowCategoryName = True 
End Sub

See also

DataLabel Object