If it's date and time, you should make an XY chart.

You can make a dynamic chart of the last N values:
http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"bflorox" wrote in message
...
I have a 2 column ss. One column is a date and time stamp, the other is a
number value. I want a Line graph that automatically plots the 20 (or
whatever) most-recent entries as soon as the entry is made. Can this be
done? Thanks.