I have two columns of data in a sheet. The first column is the date
and the second is value. The dates are arranged in a descending order.
Thus the latest date appears in cell A1 and its corresponding value in
B1. I need to graph the latest six values, datewise i.e.
=series($A$1:$A$6,$B$1:$B$6,1). The problem is when I insert a new row
to add the value and date for the latest date, the sheet the graph
automatically leaves out the latest date and still plots the the
previous six values ie. it plots =series($A$2:$A$7,$B$2:$B$7,1). How
can I make excel to stick to the first six values only.

Thanks
Utkarsh