Thread: Charting Arrays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
boyze boyze is offline
external usenet poster
 
Posts: 4
Default Charting Arrays

I am trying to xy scatter plot with pre-defined arrays. A sampling of the
code is below but it does not recognize the arrays. Please advise.

Thanks in advance.

Dim Shear() As Double, NodeCoordinates() As Double
Dim MyNewSrs1 As Series
Set MyNewSrs1 = ActiveChart.SeriesCollection.NewSeries
With MyNewSrs1
.Name = Shear
.Values = Shear
.XValues = NodeCoordinates
End With