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

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.

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

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/l...chrome2001.pdf

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


"Bimal" wrote in message
...
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.