Chart automatically growing with new data

Hello I have two columns of data, both grow depending on data entered elsewhere, and through IF function the data is added to these two columns which I want to keep being added to my chart. Can anyone help? Thank you

Eventually try Dynamic ranges

Thank you for help- but not solved.

The problem appears to be that I am not physically entering the data in to the columns that are the series for the graph. I have an IF formula copied down the column, which returns the value required to graph. I have dragged down this formula far down the column. In the name manager, when I click on 'refers to' all cells that I have the If function in are highlighted, even with no data present.

=OFFSET('Tidy'!$DW$3,1,0,COUNTA('Tidy'!$DW:$DW)-1,2)- This is the formula for the dynamic range,

=IF(B17>0,DS17," ") This is the IF formula copied down DW

I hope this makes sense? Can you see a way around this?

Then perhaps

Please Login or Register  to view this content.

Originally Posted by arthurbr

Then perhaps

Please Login or Register  to view this content.

I'mot sure quite how I got to this, a mixture of help, videos, articles- but what worked for me was
=OFFSET('Tidy'!$EG$3,1,0,COUNT('Tidy'!$EG:$EG),1)

Thanks anyway