OpenOffice.org calc: how to dynamically update a data range for a graph?

openoffice-calc charts

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:A100 to 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?


Solution 1:

Unfortunately it cannot be done in Calc. This feature is on the TODO list for the 3.x version. Calc is not able to ignore empty cells. When this feature is added, you can select the entire column or a wider range and ask Calc to ignore empty cells.

Related

Keep notification area always show on GNOME 3
GoToMeetin​g and Webex end client control when client switches to Visual Studio or SQL Server Management Studio
Software to capture 3d geometry?
Vim: ignore case in "f" and "t" motion commands
How to search in windows according to access date
Add another monitor to VirtualBox while running?
gedit indent guides
Characterization of normal distribution
Mind-boggling property of a prime
Good video lectures in Differential Geometry
How to evaluate the integral $\int_0^\infty \frac{x^{a-1}}{1+bx^a} e^{-x} dx$
Prove: $\sqrt[3]{\frac{a^{2}+bc}{b^2+c^2}}+\sqrt[3]{\frac{b^{2}+ac}{a^2+c^2}}+\sqrt[3]{\frac{c^{2}+ab}{a^2+b^2}}\geq 9\frac{\sqrt[3]{abc}}{a+b+c}$