Trying to define a changing range for chart
 

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

Trying to define a changing range for chart
 

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

Trying to define a changing range for chart
 

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