View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Paste charts to reference new worksheet

When I copy and paste a chart between worksheets, the new chart plots the
data series from the old sheet. I want it to plot the values from the new
sheet (of cells with the same references). How do I do it?