Dynamic Graph Range

[Nivvy]

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.

 

[GWteB]

Hi Nivvy, welcome to MrExcel.

I would recommend to convert the data range on your worksheet to a table. Select your range (C1:D1500) > Ribbon > Home > Format as Table
The moment data is added in cell D1501 your graph will be updated automatically, ie the chart data range will change to =Table!$C$1:$D$1501.

 

[Nivvy]

Hi Nivvy, welcome to MrExcel.

I would recommend to convert the data range on your worksheet to a table. Select your range (C1:D1500) > Ribbon > Home > Format as Table
The moment data is added in cell D1501 your graph will be updated automatically, ie the chart data range will change to =Table!$C$1:$D$1501.

Thany you. So simple!

 

[GWteB]

You are welcome!