Changing graph

[Utkarsh Majmudar]

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

 

[Guest]

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.

 

[Frank Kabel]

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