hey!!

i'm working now with dynamic range for single column and charts.
i've a chart with number on the y axis and dates on the x axis and i would
like to make a chart in which every time a new number and date is added to
the sheet, the chart automatically updates.
I've tried using dynamic ranges with the offset function, like this:
OFFSET($A$1,0,0,COUNT($A:$A),1)

however every time new values are added, i necessarily have to make a new
chart.

can someone give me some hints?!