View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mr. Mike Mr. Mike is offline
external usenet poster
 
Posts: 1
Default pasting chart getting source data from new location

I have a spreadsheet and chart of which I need several instances. When I
copy and paste the sheet, the source data for the new chart is pointing to
the original spreadsheet. My goal is to have a new sheet and chart that is
independent from the original, however works the same way. New data entered
into the new spredsheet will display on the the new graph.