Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to assign an array to a SeriesCollection
Can I create an array and assign it to a SeriesCollection of a chart
without that array coming from a range of cells, but as the result of array operations? Stephen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to assign an array to a SeriesCollection
Use a sheet name and set the refernce for that name to be ={your array
operations here} /Lars Hammarberg www.camako.se "Stephen Boulet" wrote in message ... Can I create an array and assign it to a SeriesCollection of a chart without that array coming from a range of cells, but as the result of array operations? Stephen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to assign an array to a SeriesCollection
Stephen -
In VBA: ActiveChart.SeriesCollection(1).Values = Array(3,2,1) or Sub AssignArray() Dim i As Integer Dim myVals(1 To 5) As Double For i = 1 To 5 myVals(i) = 7 - i Next ActiveChart.SeriesCollection(1).Values = myVals End Sub - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Stephen Boulet wrote: Can I create an array and assign it to a SeriesCollection of a chart without that array coming from a range of cells, but as the result of array operations? Stephen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SeriesCollection question | Charts and Charting in Excel | |||
Assign Values to array | Excel Discussion (Misc queries) | |||
Assign data to chart series, using array | Excel Programming | |||
how to assign ranges on different sheets to an array | Excel Programming | |||
how to assign ranges on different sheets to an array | Excel Programming |