Need help in Charting: retrieving the series.

[annanathan]

Hi All,

I'm trying to retrieve the series from an already configured chart. I need to know what column is it referring to on the chart.

Any help is appreciated,
Thank you in advance.

 

[annanathan]

Maybe I haven't explained the problem clearly...

I have created a linear chart in Excel.
I would like to retrieve the column id (eg. A, B, ... ) that the chart is reffering to using VBA. I need this id so that I could use it later in my VBA coding for other puposes.

How do I do this?
Please help.
Thank you.

 

[xlbo]

See if this gets you anywhere:
For i = 1 To ActiveChart.SeriesCollection.Count
MsgBox ActiveChart.SeriesCollection(i).Formula
Next i
You should be able to extract the column from the formula property - just assign to a string and use left/mid/right/find etc
HTH Rgds
~Geoff~