Edit

ShowSeriesName property (Excel Graph)

  • Article

Allows the user to show the series name for the data labels on a chart. Read/write Boolean.

Syntax

expression.ShowSeriesName

expression Required. An expression that returns one of the objects in the Applies To list.

Remarks

The chart must first be active before you can access the data labels programmatically.

Example

This example enables the series name to be shown for the data labels of the first series on the first chart.

Sub UseSeriesName() 
 
 ActiveSheet.ChartObjects(1).Activate 
 ActiveChart.SeriesCollection(1) _ 
 .DataLabels.ShowSeriesName = True 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.