Hi,

This page describes the last 12 months. You should be able to modify for
your needs.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Fay" wrote in message
...
Hello,

Need help with a dynamic graph. I am using a defined names to
automatically
update a chart range but I want the number of horizontal data points to be
fixed at say 10 data points. I want to truncate old data points and add
the
newest each time a new entry is made.

Thanks