Re: Dynamic range in Diagrams

[so09 gmx de]

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.

Regards
Soeren


Am 08.04.2012 14:26, schrieb FrancisA:
> Hello, I created a histogramm.
>
> Example
>     A B ...
> 1 1
> 2 2
> 3 3
> 4 2
> 5 3
> 6 1
> 7 3
> 8...
>
> A Histogram (I have much more Diagrams based on that Datas) in the range
> A1:A7
>
> 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!