View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Copying an Excel.Series...HOW?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ups.com...
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