I have an OpenOffice.org spreadsheet that contains a number of graphs. As I append more data to this spreadsheet, I want to update all the data ranges in those graphs, basically changing
A1:A101, then to
A1:A102 and so on…
This is a borig manual work. Is there a way to automatize it with some clever trick? For example, can I use
INDIRECT() function in data range definition?