Is it possible to set up a calc chart such that, given a data table that is updated on a daily basis with new items, the chart automatically increases the data range?
The problem I’m having is that if I, say, set up a chart with the data range $Sheet1.$A$1:$C$16
but there is only data up to $C$10
, the data range will revert to the latter. When the data is subsequently updated and new rows added to the table, the chart doesn’t reflect the changes and forces one to manually:
- double click the chart area to activate it
- right click and select Data Ranges
- correct the value in the data range textbox
Linux x64; Libreoffice 4.0.2.2