View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Elliot
 
Posts: n/a
Default Combine worksheets with graphs into one file

I have many spreadsheets with data and graphs which I need to combine as tabs
in one workbook. When I cut and paste sheets, the graphs remain linked to
the old sheets. All of the rows, columns and data are the same, so is there
an easy way to break the link and get the graph pointed at the new sheet
without editing each series?