Excel Chart Add Series with VBA

[Juan Schwartz]

Let's say

chartdepth = "0,1,2,3,4,5,6,7"
chartdays = "0,1,2,3,4,5,6,7,8,9"

When I execute the following code, the values for .XValues fills in
just fine, but the data for .Values just sits at 0.

Dim MyNewSrs As Series
Set MyNewSrs = ActiveChart.SeriesCollection.NewSeries
With MyNewSrs
.Name = well_array(k, 2)
MsgBox (chartdepth)
.Values = Array(chartdepth)
.XValues = Array(chartdays)
End With

Can anyone help me out?

 

[Juan Schwartz]

Let's say

chartdepth = "0,1,2,3,4,5,6,7"
chartdays = "0,1,2,3,4,5,6,7,8,9"

When I execute the following code, the values for .XValues fills in
just fine, but the data for .Values just sits at 0.

Dim MyNewSrs As Series
Set MyNewSrs = ActiveChart.SeriesCollection.NewSeries
With MyNewSrs
.Name = well_array(k, 2)
MsgBox (chartdepth)
.Values = Array(chartdepth)
.XValues = Array(chartdays)
End With

Can anyone help me out?

Just to add, the "arrays" have the same number of items in each...

 

[Juan Schwartz]

Just to add, the "arrays" have the same number of items in each...

Figured it out... you just don't put ARRAY() around the vars



chartdepth = "0,1,2,3,4,5,6,7"
chartdays = "2,3,4,5,6,7,8,9"

Dim MyNewSrs As Series
Set MyNewSrs = ActiveChart.SeriesCollection.NewSeries
With MyNewSrs
.Name = well_array(k, 2)
MsgBox (chartdepth)
.Values = Array(chartdepth)
.XValues = Array(chartdays)
End With