Trying to define a changing range for chart

  • Thread starter Thread starter Rcarper
  • Start date Start date
R

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,

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

RC
 
Back
Top