View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Excelfool Excelfool is offline
external usenet poster
 
Posts: 1
Default Paste a chart and get the source data to be from the new worksheet

I want to paste an Excel chart from worksheet 1 to worksheet 2 and for the
newly pasted chart in sheet 2 to reference the sourse data as worksheet 2 not
its original data from sheet 1.