I am so glad I found this forum. Now I can find out about all the little anoying things!
I will frequently create a workbook where I will set up all sorts of calcuations and graphs on the first sheet and then copy it all to the next sheet where I use a different data set to do the same things. When I copy a graph over though it always has a data source that points to sheet 1. Is there any way to copy it over so it becomes a more generic format and points to the same cells but the new sheet (or no sheet at all)?
Thanks for your help about the curve integration. With a little tweaking I was able to use the macro you pointed out.
Maureen
I will frequently create a workbook where I will set up all sorts of calcuations and graphs on the first sheet and then copy it all to the next sheet where I use a different data set to do the same things. When I copy a graph over though it always has a data source that points to sheet 1. Is there any way to copy it over so it becomes a more generic format and points to the same cells but the new sheet (or no sheet at all)?
Thanks for your help about the curve integration. With a little tweaking I was able to use the macro you pointed out.
Maureen