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

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


"jrussl" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>