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


--
jrussl
------------------------------------------------------------------------
jrussl's Profile: http://www.excelforum.com/member.php...o&userid=35427
View this thread: http://www.excelforum.com/showthread...hreadid=551961

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/P...cle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"jrussl" wrote in
message ...

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


--
jrussl
------------------------------------------------------------------------
jrussl's Profile:
http://www.excelforum.com/member.php...o&userid=35427
View this thread: http://www.excelforum.com/showthread...hreadid=551961