| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array as chart series data source
Is it possible to use array variable values as the source for a chart series?
I have tried to use the SetSourceData method which failed because the method was looking for a range. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array as chart series data source
Sub test()
Dim sr As Series Dim vY, vX vY = Array(1, 2, 3) vX = Array("AA", "BB", "CC") Set sr = ActiveChart.SeriesCollection.NewSeries sr.Values = vY sr.XValues = vX End Sub Also look at series.Formula Regards, Peter T "Mitch" wrote in message ... Is it possible to use array variable values as the source for a chart series? I have tried to use the SetSourceData method which failed because the method was looking for a range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Source Data / Series | Charts and Charting in Excel | |||
| Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
| Source Data - Series Tab | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| Assign data to chart series, using array | Excel Programming | |||
Linear Mode
