Re: [libreoffice-users] Data Range in Calc

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+unsubscribe@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