I think the simple way to do that is to duplicate your sheet (using Edit/Sheet/Duplicate or the contextual manage sheets menu) and then change the data. Hope this helps.
Regards, Jean Le vendredi 20 août 2010 à 18:50 +0000, Andreas Schneider a écrit : > For a research project I have filled several sheets in a gnumeric-file > with different values. All sheets are identically formatted, based > upon the same data mask. I have created a complex barchart for the > first of the sheets (took me quite some time...) and I exspected, that > if I copy/paste this chart into the remaining sheets it will take use > of the data there and show updated bars. For example the graph data > for my x-axis in the first sheet reads "'sheet1'!$A$2:$A$101". After > copy/pasting to "sheet2" it doesn't change to "'sheet2'!$A$2:$A$101" > but still remains "'sheet1'!$A$2:$A$101". Do I have to adapt all the > references by hand for every sheet or is there a trick to do the job > automatically, e.g. by a search-and-replace-function or a special > piece of code instead of "'sheet1'!"? Any help appreciated =) > > _______________________________________________ > gnumeric-list mailing list > [email protected] > http://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
