How to append existing series?

[Michael C via OfficeKB.com]

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?

 

[Tushar Mehta]

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/newsgroups/dynamic_charts/index.html

--
Regards,

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