Perfect! Thanks. Now...

I have four similar pieces of equipment I would like to monitor the same
way. For operator convenience, I would like to do this through one ss with a
named tab for each piece of equipment. Will this work if I just change the
Dynamic Name references or will I have to add new names for each tab? AND...

I don't care about scale so I prefer this to be a line chart, not XY.
However, the Y values are an automatic date and time stamp. The line chart
only recognizes the date portion, ignoring the time, so I end up with
multiple points on the same day. Is this avoidable in a line chart or do I
have to go with XY?

Thanks.

"Jon Peltier" wrote:

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.