Macro for graphing

[jrussl]

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

 

[Jon Peltier]

You don't need a macro, you can do it with dynamic ranges. Here are some
examples and links to other examples:

http://peltiertech.com/Excel/Charts/Dynamics.html

This more detailed example may be appropriate to your application:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

- Jon