I have a chart in which I daily insert a column. For reference sake this is the formula =SERIES(,Database!$C$2:$EB$2,Database!$C$25:$EB$25,1).
Whenever I insert the column the formula will shift one column and become =SERIES(,Database!$D$2:$EC$2,Database!$D$25:$EC$25,1). So what happens is that my inserted column does not automatically get included into the chart.
How do I keep the range static so that each day I'm plotting my new data.
I hope I've explaned my problem properly.
thanks
Bookmarks