list of series

[shadow12345]

When i click on a series on my chart I can see the series details in the formula bar.

Can i get a list of all of them, rather than clicking each series in turn? Is that possible?

 

[pgc01]

Hi Shadow

Select the chart and execute this code. You'll get the list of the series and their formulas in columns A:B, starting in A1.

Sub ListSeriesFormulas()
Dim ser As Series
Dim lRow As Long
 
For Each ser In ActiveChart.SeriesCollection
    lRow = lRow + 1
    Range("A" & lRow) = ser.Name
    Range("B" & lRow) = "'" & ser.Formula
Next ser
End Sub

 

[shadow12345]

Damit... i spent days trolling the internet looking for this.

I finally got something working ish, using a whole bunch of code with class module and all i needed was that.


*sigh*

Im sure there is a secret to this im missing. Thanks for the reply though, im going to use your instead at least i kind of understand what its doing.