Whenever you want to plot a formula, you should put a list of X values in
one column, then put the formula for Y in the next column, then select the
two columns and make a chart.

For example, if I want to plot Y=X, I put X values in A2:A10, and in B2 I
enter the formula =A2, and I fill it down to B10. The range A1:B10 will look
like this:

A B
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9

Select A1:B10 and make an XY chart.

For a simple linear equation, you only need two points, the start and end of
the line, because the connecting line automatically includes all
intermediate points.

If you are only plotting one point, you just need the equivalent to A1:B2
above. Change what you enter for X and the value of Y will change to match.

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


"Mas" wrote in message
...
Hi all,

I would like to plot a graph for the equation R=1+E, where at anytime I
want to put a value in R it should automatically plot the value of E on
the graph.

Is this possible?

Thanks in advance.

Mas