Re: Dynamic range in Diagrams

Hello Francis,

possible solution that works:
1. Open Gnumeric, input/paste your data as mentioned.
2. Select columns A and B with mouse.
3. Create diagram.
4. As you append data it will be included automatically in your diagram.

When you double click the diagram and look up the data range, you see something like Sheet1!$A$2:$A$65536, that's why/how it works.


Am 08.04.2012 14:26, schrieb FrancisA:

Hello, I created a histogramm.

    A B ...
1 1
2 2
3 3
4 2
5 3
6 1
7 3

A Histogram (I have much more Diagrams based on that Datas) in the range

So from time to time, I want to append datas (for example A8 and A9), and as
it is now, I have to correct alls data ranges in each diagram (extend from
A7 to A9 in this example)

So my question is: is there any possibility for the diagrams to look for the
last filled in cell in a column?

Thank you in advance!

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]