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

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



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