Selecting Specific Name in VBA Chart Points Value

[kyoung]

Hope someone can provide some guidance on this. I've created the below macro to format graphs. The challenge I'm having is for the line "ActiveChart.SeriesCollection(1).Points(15).Select" I would like Points(15) to select a specific name in the range and not the value such as "Panther". For each chart "Panther" may be in a different row.

Is there a way to select the specific name rather than the numeric value? Appreciate any guidance!!


ActiveSheet.ChartObjects("CA_Chart").Activate
ActiveChart.SeriesCollection(1).Select
ActiveChart.SeriesCollection(1).ApplyDataLabels
ActiveChart.SeriesCollection(1).DataLabels.Font.Size = 8
ActiveChart.SeriesCollection(2).Select
ActiveChart.SeriesCollection(2).ApplyDataLabels
ActiveChart.SeriesCollection(2).DataLabels.Font.Size = 8
ActiveChart.SeriesCollection(1).Points(15).Select
With Selection.Format.Fill
.ForeColor.RGB = RGB(255, 0, 0)
End With