Can xy graph origin be controlled from a cell?
 

Hi everyone,

Say you have xy graph with (0,0) as its origin. Of course you can
make
the origin has any non-zero value by clicking the x axis and chaging
the value from 0 to, say, 5. Same thing to y axis by clicking on it.


If I have to make the origin value change frequently, is there a way
to do so from a cell?


Thanks,
Jo

Can xy graph origin be controlled from a cell?
 

You need to rely on a little VBA for this:

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

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


"Jo" wrote in message
oups.com...
Hi everyone,

Say you have xy graph with (0,0) as its origin. Of course you can
make
the origin has any non-zero value by clicking the x axis and chaging
the value from 0 to, say, 5. Same thing to y axis by clicking on it.


If I have to make the origin value change frequently, is there a way
to do so from a cell?


Thanks,
Jo