If you know the range that constitutes the source for a particular
series set the Values (and XValues) properties. Something like:

ActiveChart.SeriesCollection(1).Values = _
"='" & ActiveSheet.Name & "'!" _
& Range("F1").Resize(4, 1).Address( _
RowAbsolute:=True, ColumnAbsolute:=True, _
ReferenceStyle:=xlR1C1)

Or you can use named formulas for series a la
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , says...
I want to append specific series on a chart.
I realize using the extend method would do the trick, but that will append
all the series in the chart.Hence the format SeriesCollection.Extend

I want to be able to extend specific series so SeriesCollection(index).Extend,
but it gives me a runtime error when using that code.

Anyone know how would I extend an existing specific series?