View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benedikt
 
Posts: n/a
Default How I can use the same graph in multiple worksheets?

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!