Chart: range info from seriescollection?

[Guest]

I would like to fill a combobox (Rowsource) with data that are used in for
instance the XValues or Values of a Seriescollection of a graph.
"ActiveChart.SeriesCollection(1).Values" does not give the right type (I was
hoping for a string type of info like "Sheet1.Range(a1:a10)").
How to get a Range to be used as Rowsource for my combobox???

Thanks for your suggestions,

JB

 

[Jon Peltier]

The Values and XValues will return an array of values. To get the range
address like this, you will need to parse the series formula. Or you could
use John Walkenbach's class module for extracting elements of the chart
series:

http://www.j-walk.com/ss/excel/tips/tip83.htm

- Jon