Can xy graph origin be controlled from a cell?

[Jo]

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

 

[Jon Peltier]

You need to rely on a little VBA for this:

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

- Jon