dynamic range and chart - big help!!

  • Thread starter Thread starter Xaraam
  • Start date Start date
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?!
 
You need to have a dynamic range for every series on the chart, and one for
the labels.
 
Back
Top