View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Rcarper Rcarper is offline
external usenet poster
 
Posts: 9
Default 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