Re: [libreoffice-users] Data Range in Calc

2016-07-08 Thread Piet van Oostrum
Mike Scott wrote: > On 08/07/16 02:01, Pat Brown wrote: > > Mike, the problem is that when I double click on the chart and I right > > click, none of the options is "Data Ranges". The closest I can come is > > "Data Table.." This is what has been frustrating me. I wonder if it > > would help

Re: [libreoffice-users] Data Range in Calc

2016-07-08 Thread Mike Scott
On 08/07/16 02:01, Pat Brown wrote: Mike, the problem is that when I double click on the chart and I right click, none of the options is "Data Ranges". The closest I can come is "Data Table.." This is what has been frustrating me. I wonder if it would help to re-install LO as there may have been

Re: [libreoffice-users] Data Range in Calc

2016-07-07 Thread Mike Scott
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

Re: [libreoffice-users] Data Range in Calc

2016-07-07 Thread James Knott
On 07/07/2016 09:37 AM, 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 t

[libreoffice-users] Data Range in Calc

2016-07-07 Thread Pat Brown
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.