Graphs and sheet referencing?

[Graham]

Hi

I've created a worksheet that contains data and 18 graphs related to
the data. I want to use this sheet (without data) like a template, so
I can copy and paste the sheet contents onto adjacent sheets and start
entering different data.
But, how do I stop the graphs from referring to the original worksheet
for the data?
Absolute within the page is fine but what can I do about the worksheet
referencing
Without going into each individual graph to change the worksheet
that's been referenced each time the template is copied

I'm hopping for some copy and paste type option

Thanks

Graham

 

[Graham]

Thanks for the reply, I will investigate you're method

However I had a good trawl using Google and found a couple of methods

I found a macro at http://peltiertech.com/Excel/Charts/ChgSrsFmla.html
that worked well

Then I found a bit about pressing CTRL and dragging the sheet tab.
I know the macro worked and subsequently found the click and drag
worked, if the second method only worked because of me having run the
macro I don't know. Whatever that bits fixed.
Now what I need is--------ummm---- how about winning the lottery

Thanks any way your reply was appreciated

Graham
=====================================