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" <jrussl.29el10_1150307103.2904@excelforum-nospam.com> wrote in
message news:jrussl.29el10_1150307103.2904@excelforum-nospam.com...
>
> 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
>