Chart Copying Issue

  • Thread starter Thread starter plh
  • Start date Start date
P

plh

Hello all,
Please help my boss's boss with this:
1) Select whole page, including chart
2) Copy
3) Open new workbook
4) select page
5) paste
So far so good, BUT the new copy references the cells in the old workbook. The
new workbook has the same information in the same cells. How do I make this copy
in such a way that the new chart references cells in it's own (the new )
workbook?
Thanx,
-plh
 
Hi,

With the original file, right click the sheet tab in the and pick Move
or Copy...
Use the To book dropdown to specify (new book).

Sheet and chart will appear in a new workbook.

Cheers
Andy
 
Hi,

With the original file, right click the sheet tab in the and pick Move
or Copy...
Use the To book dropdown to specify (new book).

Sheet and chart will appear in a new workbook.

Cheers
Andy
Click to expand...

Thanx, Andy, I figured it was something nice and simple, but heretofore unknown
to moi.
-plh
 
Back
Top