View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default copying worksheet including graphs to new worksheet

If you use "Move or Copy Sheets" to copy a sheet to a new worksheet, any
chart references from the original sheet will automatically be to the new
sheet on the copy. I'm not clear as to how you are doing your copy.
--
David Biddulph

"leif" wrote in message
...
I have a problem with finding an efficient method of copying an entire
worksheet including more graphs to a new worksheet without having to
redefine
each date sets in the graphs to the name of the new worksheet.

Can I define date in the graphs to copy so they ar refering to the
worksheet
they are included in?