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

You can add the latest data at the bottom of your data range (i.e. : A12:B12) and then sort range "A:B" by descending and your chart will be updated automatically.

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