View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Excelerate-nl
 
Posts: n/a
Default Chart: range info from seriescollection?

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