Ask Your Question

Problem with no automatic data range update for charts [closed]

asked 2013-11-28 09:55:44 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

When I set up a chart and define a data range larger than the actual set of numbers, the range reverts to the size of the range actually containing numbers. When I add new data, I then have to redefine the data range so that the new data is reflected in the chart. With Excel I could simply define a data range any size I wanted, and data added later within this range was automatically shown in the chart. Is it possible to implement this in LibreOffice? I find this an irritating and time wasting limitation.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-07 02:56:12.180423

2 Answers

Sort by » oldest newest most voted

answered 2013-11-28 20:54:38 +0200

Regina gravatar image

There exists an enhancement request .

If you do not want to open the data range dialog, you can workaround it this way: Mark the whole data range in the spreadsheet. Then drag the marked area and drop it onto the chart. The chart takes the new range while preserving all formatting.

edit flag offensive delete link more


Wonderful, it works well if the data is in adjacent columns, but there is still a problem if the columns are not adjacent. In any case, many thanks, it is at least a temporary solution.

Blacky25 gravatar imageBlacky25 ( 2013-11-29 14:11:15 +0200 )edit

answered 2014-12-19 15:16:51 +0200

Lorenzo gravatar image

There is a different workaround.

  1. First, go to Menu->Tools->Options->Libre Office Calc->General, then check the "Enlarge ranges references when adding rows/columns" checkbutton.
  2. Add a row and a column to your range and fill them whit non-numerical chars, like "-" (minus) for instance. Let call this row/column in the following as "boundary".
  3. Define this new expanded range as range for your chart, to the "boundaries" included.

When necessary, add a new row/column selecting the "boundary" row or column and making "add row/column" The range in your chart will remain defined to the moved "boundaries" and will include the new added row/column.

edit flag offensive delete link more

Question Tools



Asked: 2013-11-28 09:55:44 +0200

Seen: 1,499 times

Last updated: Dec 19 '14