- Joined
- Feb 24, 2006
- Messages
- 1
- Reaction score
- 0
ActiveChart.SeriesCollection(1).Values
Can be used to set values for an Excel chart
e.g.
ActiveChart.SeriesCollection(1).Values = mystring mystring = "1,2,3,4,5,6, etc"
ActiveChart.SeriesCollection(1).Values = Some worksheet range (A1:A1000)
mystring has to be less than 256 characters. Is there a way to use a collection etc to draw a chart > 256 characters in length but I want to do it in VBA i.e.
ActiveChart.SeriesCollection(1).Values = "some kind of array or collection"
If this is on the wrong board please let me know
Richard
Can be used to set values for an Excel chart
e.g.
ActiveChart.SeriesCollection(1).Values = mystring mystring = "1,2,3,4,5,6, etc"
ActiveChart.SeriesCollection(1).Values = Some worksheet range (A1:A1000)
mystring has to be less than 256 characters. Is there a way to use a collection etc to draw a chart > 256 characters in length but I want to do it in VBA i.e.
ActiveChart.SeriesCollection(1).Values = "some kind of array or collection"
If this is on the wrong board please let me know
Richard
Last edited: