Trying to define a changing range for chart

[Rcarper]

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 Peltier]

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

 

[Rcarper]

Jon,

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

RC