X
Xaraam
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?!
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?!