Hi,

Have a look at Jon's example, hopefully you can modify to suit your data.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy

tiw wrote:
I'm trying to create a chart that automatically will chart the last 90
entries of a list of information (containing only numbers) without having to
change the range every time. Please any suggestions????

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info