Hi
you may define a name for your range like
=INDIRECT("A1:A6") and use this defined name ('Insert - Name - Define')
as data source for your chart


--
Regards
Frank Kabel
Frankfurt, Germany


Utkarsh Majmudar wrote:
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