How I can use the same graph in multiple worksheets?

B

Benedikt

I want to copy worksheets in the same Excel 2003 file to change the data but
not the layout and formulas again (for several repetitions of one
experiment). Is there a function which enables a graph to use the particular
worksheet itself as data source and not the the data range on the original
worksheet (so instead of "='sheet1'!A1:A2" kind of: ='worksheet where the
graph is on'!A1:A2).

Thank you!
 
B

Benedikt

To be more exact I was writing about the chartfunction. But I think this
problem is not only applicable on charts.
 
Top