View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Harley Cudney Harley Cudney is offline
external usenet poster
 
Posts: 1
Default In copied worksheet, embedded chart uses data fm orig - change?

When I copy a worksheet, I want the embedded chart to automatically use data
from the new worksheet, Instead, it uses data from the original worksheet.
So I have to edit each data series in the chart everytime I create a new
worksheet by copying an old one.
Example: worksheet displaying hours worked that week. When I copy the sheet
to start a new week, the embedded chart is displaying data from last week.