I am trying to create a chart that automatically updates when I fill in the
corresponding data. To do this I googled a bit and found a solution that used
named ranges with an offset function. So I implemented this into my excel
sheet with the following code:
=OFFSET(Cost!$A$2;1;0;COUNT(Cost!$A$3:$A$2004);1)
This works perfectly as for one thing, I cant seem to get the last entry
joined with the others! What am I doing wrong?
I am using excel 2003.