Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.