Re: [libreoffice-users] Changing date on a chart
Use a database. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Changing date on a chart
Dear All I am responsible for the assembly of the attached “Fund Progress Dec 2011” spreadsheet. Everything has gone fine up to now, however I will shortly want to amend the “Monthly Income Bank Interest Paid” chart by covering income etc. from January 2010 forward. Obviously I would wish to retain the data on “sheet 1”. I have tried amending the data ranges but rather than just removing the data from Dec 2008 to Dec 2009 all other things happen. I am sure someone out there has a very simple explanation what I should do next, I would be very thankful for your help. John http://nabble.documentfoundation.org/file/n3571301/Fund_Progress_Dec_2011.ods Fund_Progress_Dec_2011.ods -- View this message in context: http://nabble.documentfoundation.org/Changing-date-on-a-chart-tp3571301p3571301.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Changing date on a chart
John On 12/08/2011 03:42 PM, lismurn wrote: Dear All I am responsible for the assembly of the attached “Fund Progress Dec 2011” spreadsheet. Everything has gone fine up to now, however I will shortly want to amend the “Monthly Income Bank Interest Paid” chart by covering income etc. from January 2010 forward. Obviously I would wish to retain the data on “sheet 1”. I have tried amending the data ranges but rather than just removing the data from Dec 2008 to Dec 2009 all other things happen. I am sure someone out there has a very simple explanation what I should do next, I would be very thankful for your help. John http://nabble.documentfoundation.org/file/n3571301/Fund_Progress_Dec_2011.ods Fund_Progress_Dec_2011.ods -- View this message in context: http://nabble.documentfoundation.org/Changing-date-on-a-chart-tp3571301p3571301.html Sent from the Users mailing list archive at Nabble.com. You can create a copy of the worksheet. Right click on the sheet tab and select Move/Copy. In the dialog box select make copy; you can rename now or later. On the copy, you can cut and paste the data over the data you do need. This will allow you to keep the historical data and have a current worksheet for current data. 0 -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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