DataLabel.ShowSeriesName Property

Syntax

expression.ShowSeriesName

expression A variable that represents a DataLabel object.

Remarks

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

Example

This example enables the series name to be shown for the data labels of the first series on the first chart. This example assumes a chart exists on the active worksheet.

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

See also:

• DataLabel Object
• DataLabel Object Members