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