No need for VBA, just worksheet formulas and dynamic defined names. It's
similar to this example:

http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______



"Rcarper" wrote in message
...
Hello,

I'm currently working on a MS Excel worksheet where I constantly have data
entered in. Now, I want to keep all of the data, but only want to graph
the
last 10 values. I tried programming this, but from what I understand I'll
have to create the graph every time, which is not feasible. Is it possible
to
get excel to do this for me and how? I have almost no understanding of VBA
if
this is the course to take.

Thanks in advance,

RC