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

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

Jon,

Thank you! This was exactly what I needed! I've been working on this problem
for weeks. Once again, I appreciate everything.

RC

"Jon Peltier" wrote:

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