Macro for naming a series in a chart

[paul061]

Hello, I have a macro for creating a chart. I'd like to have the series names come from a particular cell. I've had some help with some other things like this but can't seem to make them work the same. My programming is zero, so I've been shooting in the dark trying to make this work. This is what I've come up with but it doesn't work. I'd appreciate someone telling me how to make it work and why mine didn't work so I can begin to understand how this all is done. Thak you!

ActiveChart.SeriesCollection(3).Value = Range("B4").Value

 

[Andrew Poulsom]

Try qualifying the range with its worksheet, eg:

ActiveChart.SeriesCollection(3).Name = Worksheets("Sheet9").Range("B7").Value

If you don't, Excel will use the active sheet, and that may not be a worksheet.

 

[paul061]

That worked!!! Thank you both so much for taking the time to help me. This is my first foray into this type of programming. It's kind of fun and a nice change from my normal mechanical engineering job.

Paul