On 07/07/2016 09:37 AM, Pat Brown wrote: > Every year I open a new sheet in Calc to record data from a new year. The > layout remains exactly the same each year, only the data changes. The > simplest is to copy the whole of the previous year's sheet and past it into > a new sheet. Then delete all the previous year's data and fill in the new > data. I have two graphs on this page and this is where my problem comes in. > The simplest method would be to select the graph and then change the Data > Range to read from the new sheet, BUT, once a graph has been created I > cannot find any way to edit the data range. Am I missing something or is > this just not possible? Is it really necessary to re-create each graph from > scratch? >
Instead of clearing out a previous sheet, why not create a template and use that to create a new sheet each year? At the very least, you could create a blank sheet and copy it to the current year. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted