Share via

ShowSeriesName Property [Excel 2003 VBA Language Reference]

  • Article

Returns or sets a Boolean to indicate the series name display behavior for the data labels on a chart. True to show the series name. False to hide. Read/write.

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 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

Applies to | DataLabel Object | DataLabels Collection Object