Dynamic Chart Series Labels

Question

I have some Visual Basic Code that creates a chart for each row. It sets the series values using this code:

.SeriesCollection(1).Values = "=" & Ws.Name & "!R" & CurrRow & "C3:R" & CurrRow & "C8"

What I am struggling with is how do I set the series labels? The series labels will always be the 1st row and be in the corresponding column. I know this is much simplier than the code above, but I am stumped.

Any help is appreciated.

Answer 1

Use the Ws.Range("C1:H1").Value in the .SeriesCollection(1).ApplyDataLabels Method.