The tip submitted by P S Bharadhwaj, India

To copy one data series from one chart to another:

 
1. Select the series on the first chart.
2. Click in the formula bar, select and copy the series formula
3. Click on the edge of the second chart to select the chart.
4. Click in the formula bar and paste
5. Press Enter