presume you numeric data is in B1:B100
use a helper column C with the following formula in C1:C24:

=INDIRECT("B"&MAX(IF(LEN($B$1:$B$100)0,ROW($B$1:$ B$100)+ROW
()-24,"")))

CTRL+SHIFT+ENTER to insert this array-formula (instead of using just
ENTER)

pls click YES if this helped



On 30 Maj, 03:59, rayteach wrote:
I have a chart displaying 2 years worth of data – each month is a data point.
I want to automatically drop the oldest data point and add the newest when I
start to enter data for the new month. I know how to change the data range
manually to do this. Can it be done automatically? Using Excel 2003 running
under XP Pro.
--
ray