Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

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


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 (Build ID: e183d5b), Version: Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8 and Version: Build ID: a06aa316117a6ff0f05c697c82831c227812d810, all on Vista.



To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.