How do I graph a cell vs one that it changes for a range of valu.

[Guest]

One cell changes another cell as determined by a formula not explicitly
contained in either cell.
I want to range a cell from 0.5-1 in small increments and line-plot it vs
the other.
How do I express a range of values and the steps of increments?

 

[Stephen Bullen]

Hi Kentlm,

One cell changes another cell as determined by a formula not explicitly
contained in either cell.
I want to range a cell from 0.5-1 in small increments and line-plot it vs
the other.
How do I express a range of values and the steps of increments?

It sounds like you want a Data Table. Look in Excel's Help to see how to set
it up.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk