View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Using Variable array in Excel VBA charting

Indeed you can make charts with no source data in cells, but with your 1000
x-y points it's not straightforward and would require quite a lot of work
(it entails writing the data to named "vertical" arrays). If the only reason
is to save time, writing data to 1000x2 cells is barely an eye-blink if you
do it in one go -

ReDim arr(1 To 1000, 1 To 2) As Double
populate the array with x-y values
Range("a1").Resize(UBound(arr), UBound(arr, 2)).Value = arr

Regards,
Peter T


"hsPipe" wrote in message
...
I am trying to plot the generated data (over 1000 x-y scatter points) from
the variable arrays directly rather than depositing the array to the
spread
sheet and than plotting it. This is in the hope that it will reduce the
time
required to plot the chart.
I need help on how to specify the series using arrays rather than cell
ranges.

Than you.
--
Ho-Shu