Copying an Excel.Series...HOW?

[samadams_2006]

Hello,

I have an Excel.Series (ie: objSeries1) and I'm interested in
creating another Excel.Series (objSeries2) that is exactly the same as
this original. I've tried a number of things such as copying and
casting, etc., but nothing seems to work. Does anyone have any ideas?

Thanks
Sam

 

[Jon Peltier]

Select the first series, select the formula in the formula bar and copy it,
then unselect the series by selecting the plot area or chart area, then
paste.

- Jon