View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
HEK
 
Posts: n/a
Default How to copy Chart and its data to another excel worksheet

Margarita:
You can copy an entire worksheet into a new workbook. Assuming yr data and
chart are in the same worksheet, right-click the tab where the name of the
sheet appears (somewhere near the bottom left side), select "Move or Copy..."
in the pop-up menu, select the destination workbook (drop it down under "To
Book") and the rest is automatic. Pls note to check "create a copy" in case
you want to keep yr data/chart in the original worksheet also, otherwise it
just moves.
Good luck.
Br,
Henk

"Margarita" wrote:

I need to copy a set of data AND the chart that I made from it to a specific
worksheet in another workbook... but when I try to just select it, copy it
and paste it in the ither worksheet, the source of the data remains on the
other workbook... is there a way of doing it without having to re-establish
all the links?? Please help!