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
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@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