Re: [libreoffice-users] Data Range in Calc

On 07/07/16 14:37, 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?

No.

Double-click on the chart background to select it. Right-click on any 
point (or a trend line) and select "Data Ranges"



--
Mike Scott (unet2 <at> [deletethis] scottsonline.org.uk)
Harlow Essex England
"The only way is Brexit" -- anon.

--
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