Copying sheets

[Aardvark]

Dear All,

I have 3 worksheets for one week, these are 1) values, 2) summaries of
values and 3) graphs of the same. I have copied this within the workbook so
that I now have sheets for weeks 2, 3 and 4 and it has worked well except
for the graphs. The values for the graphs still relate to the values from
week 1. Why is this? Is there a way round it without redoing the data
sources for each of the graphs?

Thanks,

Danny

 

[Frank Kabel]

Hi
have a look at
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

 

[Aardvark]

Thanks for both answers Frank!

Hi
have a look at
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

 

[Frank Kabel]

Hi
you're welcome