ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Copying an Excel.Series...HOW? (https://www.excelbanter.com/charts-charting-excel/138815-copying-excel-series-how.html)

[email protected]

Copying an Excel.Series...HOW?
 
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

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





All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com