In excel, how do I vary a cell over a data range & see its effect?

[Guest]

I would like to plot a chart where values of a cell vary over data range and
effect of this change are seen on a related cell. I could have copied the
cells and the formula as many times as the number of values of the first
cell. Wanted to have a smarter way.

 

[Jon Peltier]

The simpler way (and therefore usually smarter) is to copy the formula as
many times as you need points. A trickier way which only requires the
formula to be used once is to set up a data table in the worksheet. Here is
a tutorial:

http://www.ce.cmu.edu/~hsm/bca2005/lnotes/XLDataTablesMonochrome2001.pdf

- Jon