Re: [libreoffice-users] Automatic chart data range adjustment - is it possible?

On 2014-06-13 15:03, Regina Henschel wrote:
> Hi Richard,
>
> Richard Heathfield schrieb:
> > Every day, I add another row to my spreadsheet. This row's data must be
> > included in an existing chart, so the data range must grow by one row 
> > every
> > day. (The data hardly matters - if it helps, one example would be a 
> > record
> > and graph of all daily maximum temperatures since date X.)
> >
> > In Excel, I would specify a table and create the chart from the 
> > table. Then,
> > adding a row to the table would automatically regenerate the chart to
> > include the new data.
> >
> > Is this possible in LibreOffice?
>
> Yes, the trick for it is a very old one.
>
> You have to know, that the range of the chart is adapted, if you 
> insert a row not at the end but inside the existing range. So you have 
> to insert the values of the next day _inside_ the existing data range. 
> But logically you have to add them. The trick is, to add a dummy row 
> as last row and each day add your new data just above this dummy row. 
> Click on the dummy row or mark all dummy cells and use Insert > Row or 
> Insert > Cells respectively.
>
> When you work with an xy-chart, you can write a text into this dummy 
> row to remind you of the purpose of that row.
>
> When you work with a category chart, this dummy row needs at least one 
> entry in the category or in the value, even an empty string will work. 
> But I would use a reminder text like "add data above" in the value 
> column here too.
>
> Kind regards
> Regina

Richard/Regina:

After reading this, I recalled something I had seen in the Options Dialog:

Tools|Options|Calc|General|Expand references when new columns/rows are 
inserted

With this enabled, if you go to the select next empty row below your 
data, then insert a row, it expands the chart reference.
This works with Version 3.6.7.2 (Build ID: e183d5b), Version: 4.2.4.2 
Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8 and Version: 
4.3.0.0.beta2 Build ID: a06aa316117a6ff0f05c697c82831c227812d810, all on 
Vista.

Sincerely,

TomW

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