I am trying to create a macro that will move the data range used in an XY graph backward or forward by on cell at a time. I have a very large data set and want to graph 30 XY points and be able to step backward and forward throught the data and watch the graphs change.

Can anyone show me how to create this macro?

Jeff