| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chart: range info from seriescollection?
It is not a simple thing to do.
John Walkenbach has info and a download that may help here... http://j-walk.com/ss/excel/tips/tip83.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Excelerate-nl" wrote in message 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SeriesCollection - Incorrect ColorIndex Assigned to Chart | Charts and Charting in Excel | |||
| Excel Chart SeriesCollection Formula | Excel Discussion (Misc queries) | |||
| Chart: range info from seriescollection? | Charts and Charting in Excel | |||
| Formatting a new seriescollection in a chart object | Excel Programming | |||
| Adding to the SeriesCollection of a chart object in VB6 | Excel Programming | |||
Hybrid Mode
