adding new series to a chart in vba

[dinotom]

I having trouble adding additional series to an existing chart. What is the proper method? .NewSeries or .Add?

I am currently using something like

For x = 2 to y+1
Set srsNew = ObjChart.SeriesCollection.NewSeries
With srsNew
.Name = "Name"
.XValues = testrange 'already defined earlier in code
.Values = testrange2
.ChartType = xlXYScatterLinesNoMarkers
End With
Next x

The problem is it is changing the plotting axes. How do I get it to plot on the same axes as the primary chart

 

[Jon Peltier]

>NewSeries is fine, and your code looks okay.

Is the primary chart a different chart type? Sometimes Excel "helpfully" places different series types on different axes.

Inside the With srsNew/End With block, insert this line:

.AxisGroup = xlPrimary

 

[dinotom]

I had found that already, thank you. How do I set the line style and line color for the added series if they are xy charts? The object tree doesn't show much for mseriescollection

 

[Jon Peltier]

Tom -

I forget what version of Excel you're using. If it's 2003 or earlier, turn on the macro recorder while formatting a dummy chart, or a copy of your main chart. What you want is found under the Series object in the Object Browser. The line is really the Series.Border object, which has LineStyle and Colorindex properties.