Dynamic Chart Series Labels

Posted by McVey on Stack Overflow See other posts from Stack Overflow or by McVey
Published on 2010-05-24T20:31:16Z Indexed on 2010/05/25 0:51 UTC
Read the original article Hit count: 327

Filed under:
|
|
|

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.

© Stack Overflow or respective owner

Related posts about excel

Related posts about vba