I have a simple line graph of a column of data, something like: =Table!$C$1:$D$1500.
However, the data is added to regularly, so the upper limit needs to be dynamic (lower limit is fixed at C1).
I can use the COUNT function to calculate the upper limit, but have no idea how to use it for a dynamic range?
i.e. The count value, with any offset removed, I can put in say cell F3, so I need the graph range to be
something like:
=Table!$C$3:$D$(contents(F3)).
I've not found a way to do this, using a dynamic reference for the upper limit; any help very welcome.
However, the data is added to regularly, so the upper limit needs to be dynamic (lower limit is fixed at C1).
I can use the COUNT function to calculate the upper limit, but have no idea how to use it for a dynamic range?
i.e. The count value, with any offset removed, I can put in say cell F3, so I need the graph range to be
something like:
=Table!$C$3:$D$(contents(F3)).
I've not found a way to do this, using a dynamic reference for the upper limit; any help very welcome.